Databases API

Endpoints

text
GET    /api/v1/databases          - List all databases
POST   /api/v1/databases          - Add a new database
GET    /api/v1/databases/:id      - Get database details
PUT    /api/v1/databases/:id      - Update database config
DELETE /api/v1/databases/:id      - Remove a database
POST   /api/v1/databases/:id/test - Test connection

Add a Database

bash
curl -X POST https://api.dbabrain.ai/api/v1/databases \
  -H "X-API-Key: your-api-key" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "production-primary",
    "host": "db.example.com",
    "port": 5432,
    "database": "myapp",
    "username": "dbabrain_monitor",
    "password": "secure-password",
    "sslMode": "require"
  }'

Response

json
{
  "id": "db_abc123",
  "name": "production-primary",
  "status": "connected",
  "postgresVersion": "16.2",
  "createdAt": "2026-01-15T10:30:00Z"
}