sources

Add connection

Create a new connection of any supported type. The type field determines which connection type to create.

POST /api/v1/sources/

Headers

Authorizationrequired

any - API key authentication using Bearer scheme

Request Body

One of these shapes, selected by type.

PostgresConnectionRequest

typerequired

string - Connection type identifier. Must be `POSTGRES`

account_name

string - Display name for the connection

hostname

string - PostgreSQL server hostname

port

integer - Port number

username

string - Database username

password

string - Database password

database_name

string - Database name

connection_string

string - Alternative: full connection string instead of individual parameters

selected_schemas

array - List of schema names to include in queries and overviews. If empty, all schemas except system schemas will be included.

Response

idrequired

integer - The ID of the created connection

public_key_sql

string - SQL command to add public key to Snowflake (only for Snowflake key-pair auth)

cURL

curl --request POST \
  --url https://api.camelai.com/api/v1/sources/ \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "type": "POSTGRES",
  "account_name": "PostgreSQL",
  "hostname": "db.example.com",
  "port": 5432,
  "username": "db_user",
  "password": "secure-password",
  "database_name": "analytics",
  "connection_string": "postgresql://db_user:secure-password@db.example.com:5432/analytics",
  "selected_schemas": [
    "public"
  ]
}'

200

{
  "id": 123,
  "public_key_sql": "key_123"
}

Add connection

Headers

Request Body

PostgresConnectionRequest

MySQLConnectionRequest

SnowflakeConnectionRequest

BigQueryConnectionRequest

MotherDuckConnectionRequest

ClickHouseConnectionRequest

MongoDBConnectionRequest

SingleStoreConnectionRequest

MSSQLConnectionRequest

MCPConnectionRequest

FileUploadConnectionRequestRequest

Response