The Universal API for PostgreSQL provides a single, unified interface to interact with PostgreSQL database instances. Using this API, developers can securely authenticate and execute SQL queries, including SELECT, INSERT, UPDATE, and DELETE, without managing database-specific connections. Leveraging OAuth 2.0 authentication, it simplifies data analytics, reporting, and schema operations while maintaining full control over your PostgreSQL database workflows.
POST Token
Endpoint: {{base_url}}/token
This endpoint is used to retrieve an authentication token from the API. The token serves as an authorization mechanism to access and interact with all API endpoints.
Body (form-data)
- username: {{Username}}
- password: {{Password}}
POST – API for PostgreSQL
Endpoint:
{{base_url}}/universalAPI?db_name=PostgreSQL&db_version=All
The Universal API for PostgreSQL offers a streamlined interface for securely managing PostgreSQL databases. With this API, developers can authenticate via OAuth 2.0 and execute SQL queries, including SELECT, INSERT, UPDATE, and DELETE, without handling database-specific connection details. It simplifies database operations, accelerates data analytics, and allows seamless integration into applications while maintaining full control over PostgreSQL workflows.
Authorization
OAuth 2.0
Query Parameters
- db_name: PostgreSQL
- db_version: All
Body (raw JSON)
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}
