Get connection string

GET

database

projects

{id}

connection

curl -X GET "https://api.case.dev/database/v1/projects/%3Cstring%3E/connection" \
  -H "Authorization: Bearer $CASEDEV_API_KEY"

{
  "connectionUri": "postgresql://user:password@ep-quiet-meadow-123456.us-east-1.aws.neon.tech/neondb?sslmode=require",
  "branch": "main",
  "pooled": false
}

Authorizations

Authorization

string

header

required

API key starting with sk_case_

Path Parameters

string

required

Database project ID

Query Parameters

branch

string

Branch name (defaults to 'main')

pooled

boolean

Use pooled connection (PgBouncer)

Response

Connection string retrieved successfully

connectionUri

string<uri>

required

PostgreSQL connection string (includes credentials)

branch

string

required

Branch name for this connection

pooled

boolean

required

Whether this is a pooled connection

Get database usage and billingReturns detailed database usage statistics and billing information for the current billing period. Includes compute hours, storage, data transfer, and branch counts with associated costs broken down by project.

⌘I

curl -X GET "https://api.case.dev/database/v1/projects/%3Cstring%3E/connection" \
  -H "Authorization: Bearer $CASEDEV_API_KEY"

{
  "connectionUri": "postgresql://user:password@ep-quiet-meadow-123456.us-east-1.aws.neon.tech/neondb?sslmode=require",
  "branch": "main",
  "pooled": false
}

Documentation Index

Authorizations

Path Parameters

Query Parameters

Response