Skip to main content
POST
/
api
/
v1
/
app-connections
/
postgres
cURL
curl --request POST \
  --url https://us.infisical.com/api/v1/app-connections/postgres \
  --header 'Content-Type: application/json' \
  --data '
{
  "credentials": {
    "host": "<string>",
    "port": 123,
    "database": "<string>",
    "username": "<string>",
    "password": "<string>",
    "sslEnabled": true,
    "sslRejectUnauthorized": true,
    "sslCertificate": "<string>"
  },
  "name": "<string>",
  "description": "<string>",
  "projectId": "<string>",
  "isPlatformManagedCredentials": false,
  "gatewayId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "rotation": "<unknown>"
}
'
{
  "appConnection": {
    "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "name": "<string>",
    "orgId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "createdAt": "2023-11-07T05:31:56Z",
    "updatedAt": "2023-11-07T05:31:56Z",
    "credentials": {
      "host": "<string>",
      "database": "<string>",
      "port": 123,
      "username": "<string>",
      "sslEnabled": true,
      "sslRejectUnauthorized": true,
      "sslCertificate": "<string>"
    },
    "description": "<string>",
    "version": 1,
    "isPlatformManagedCredentials": false,
    "gatewayId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "projectId": "<string>",
    "isAutoRotationEnabled": false,
    "rotation": {
      "rotationInterval": 123,
      "rotateAtUtc": {
        "hours": 123,
        "minutes": 123
      },
      "lastRotationMessage": "<string>",
      "nextRotationAt": "2023-11-07T05:31:56Z"
    },
    "credentialsHash": "<string>",
    "project": {
      "name": "<string>",
      "id": "<string>",
      "type": "<string>",
      "slug": "<string>"
    }
  }
}

Documentation Index

Fetch the complete documentation index at: https://infisical-docs-self-host-infra.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

Check out the configuration docs for PostgreSQL Connections to learn how to obtain the required credentials.

Body

application/json
​
method
enum<string>
required

The method used to authenticate with PostgreSQL.

Available options:
username-and-password
​
credentials
object
required

The credentials used to connect with PostgreSQL.

​
name
string
required

The name of the PostgreSQL Connection to create. Must be slug-friendly.

Required string length: 1 - 64
​
description
string | null

An optional description for the PostgreSQL Connection.

Maximum string length: 256
​
projectId
string

The ID of the project to create the PostgreSQL Connection in.

​
isPlatformManagedCredentials
boolean
default:false

Whether or not the PostgreSQL Connection credentials should be managed by Infisical. Once enabled this cannot be reversed.

​
gatewayId
string<uuid> | null

The Gateway ID to use for this connection.

​
isAutoRotationEnabled
enum<boolean>

Not supported for PostgreSQL Connections.

Available options:
false
​
rotation

Not supported for PostgreSQL Connections.

Response

Default Response

​
appConnection
PostgreSQL (Username and Password) · object
required