Projects

Create and manage database projects

A project is a serverless PostgreSQL database with automatic scaling, backups, and connection pooling. Each project starts with a default main branch and neondb database.

Create a project

cURL

curl -X POST https://api.case.dev/database/v1/projects \
  -H "Authorization: Bearer $CASEDEV_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "litigation-docs-db",
    "description": "Production database for litigation documents",
    "region": "aws-us-east-1"
  }'

Parameters

Parameter	Type	Required	Description
name	string	Yes	Project name (letters, numbers, hyphens, underscores only)
description	string	No	Optional project description
region	string	No	AWS region (defaults to aws-us-east-1)

Response

Field	Type	Description
id	string	Project ID
name	string	Project name
description	string	Project description
region	string	AWS region
pgVersion	integer	PostgreSQL version (17)
status	string	active, suspended, or deleted
defaultBranch	object	Default branch info (id, name)
createdAt	string	ISO 8601 timestamp

List projects

cURL

curl https://api.case.dev/database/v1/projects \
  -H "Authorization: Bearer $CASEDEV_API_KEY"

Response

[
  {
    "id": "proj_abc123",
    "name": "case-management-prod",
    "description": "Production database",
    "region": "aws-us-east-1",
    "pgVersion": 17,
    "status": "active",
    "storageSizeBytes": 52428800,
    "computeTimeSeconds": 3600,
    "linkedDeployments": [
      {
        "id": "deploy_xyz",
        "type": "compute",
        "name": "Case Intake Portal",
        "envVarName": "DATABASE_URL"
      }
    ],
    "createdAt": "2025-01-10T08:00:00Z",
    "updatedAt": "2025-01-15T12:00:00Z"
  }
]

Get project details

cURL

curl https://api.case.dev/database/v1/projects/proj_abc123 \
  -H "Authorization: Bearer $CASEDEV_API_KEY"

Response

{
  "id": "proj_abc123",
  "name": "case-management-prod",
  "description": "Production database",
  "region": "aws-us-east-1",
  "pgVersion": 17,
  "status": "active",
  "storageSizeBytes": 52428800,
  "computeTimeSeconds": 3600,
  "connectionHostname": "ep-***-123456.us-east-1.aws.neon.tech",
  "branches": [
    {
      "id": "branch_main",
      "name": "main",
      "isDefault": true,
      "status": "active",
      "createdAt": "2025-01-10T08:00:00Z"
    },
    {
      "id": "branch_staging",
      "name": "staging",
      "isDefault": false,
      "parentBranchId": "branch_main",
      "status": "active",
      "createdAt": "2025-01-12T10:00:00Z"
    }
  ],
  "databases": [{ "name": "neondb", "ownerName": "neondb_owner" }],
  "linkedDeployments": [],
  "createdAt": "2025-01-10T08:00:00Z",
  "updatedAt": "2025-01-15T12:00:00Z"
}

Delete a project

Deleting a project is permanent and irreversible. All data, branches, and backups will be destroyed.

cURL

curl -X DELETE https://api.case.dev/database/v1/projects/proj_abc123 \
  -H "Authorization: Bearer $CASEDEV_API_KEY"

Regions reference

Region	Location	Use case
aws-us-east-1	N. Virginia	US East coast, default
aws-us-east-2	Ohio	US Central
aws-us-west-2	Oregon	US West coast
aws-eu-central-1	Frankfurt	EU users, GDPR
aws-eu-west-1	Ireland	EU users
aws-eu-west-2	London	UK users
aws-ap-southeast-1	Singapore	Asia-Pacific
aws-ap-southeast-2	Sydney	Australia/NZ

Choose a region close to your application servers for lowest latency. For compliance requirements (GDPR, data residency), select a region in the appropriate jurisdiction.

Project statuses

Status	Description
active	Project is running and accepting connections
suspended	Project is paused (no compute charges, data retained)
deleted	Project has been deleted (cannot be recovered)