Skip to main content
Database connections store credentials and manage connection pools for external databases. Supported databases: PostgreSQL, ClickHouse, Snowflake Key properties:
PropertyDescription
nameUnique connection name
connection_typepostgresql, clickhouse, or snowflake
host, port, database, username, passwordConnection details
ssl_modeOptional SSL configuration
configPool settings (min_pool_size, max_pool_size)
Passwords are encrypted at rest. Connection pools are managed automatically and invalidated when settings change. Endpoints (admin only): 
POST   /api/v1/database-connections                    # Create connection
GET    /api/v1/database-connections                    # List connections
GET    /api/v1/database-connections/{name}             # Get by name
PATCH  /api/v1/database-connections/{id}               # Update
DELETE /api/v1/database-connections/{id}               # Delete
POST   /api/v1/database-connections/test               # Test raw connection params
POST   /api/v1/database-connections/{id}/test          # Test saved connection