Retrieves detailed information about a specific database project including branches, databases, storage/compute metrics, connection host, and linked deployments. Fetches live usage statistics from Neon API.
curl --request GET \
--url https://api.case.dev/database/v1/projects/{id} \
--header 'Authorization: Bearer <token>'{
"id": "proj_abc123",
"name": "case-mgmt-db",
"description": "Production case management database",
"region": "aws-us-east-1",
"pgVersion": 17,
"status": "active",
"connectionHost": "ep-quiet-meadow-123456.us-east-1.aws.neon.tech",
"storageSizeBytes": 1073741824,
"computeTimeSeconds": 3600,
"branches": [
{
"id": "branch_main_789",
"name": "main",
"isDefault": true,
"status": "active",
"createdAt": "2025-01-10T08:00:00Z"
},
{
"id": "branch_staging_012",
"name": "staging",
"isDefault": false,
"status": "active",
"createdAt": "2025-01-12T10:00:00Z"
}
],
"databases": [
{
"id": "db_neondb_345",
"name": "neondb",
"ownerName": "neondb_owner"
}
],
"linkedDeployments": [
{
"type": "compute",
"id": "app_xyz789",
"name": "case-portal",
"url": "https://case-portal.case.systems",
"envVarName": "DATABASE_URL"
}
],
"createdAt": "2025-01-10T08:00:00Z",
"updatedAt": "2025-01-15T10:30:00Z"
}API key starting with sk_case_
Database project ID
Project details retrieved successfully
Project ID
Project name
AWS region
PostgreSQL major version
Project status
active, suspended, deleted Database connection hostname (masked for security)
Current storage usage in bytes
Total compute time consumed in seconds
All branches in this project
Show child attributes
Databases in the default branch
Show child attributes
Linked deployments using this database
Show child attributes
Project creation timestamp
Project last update timestamp
Project description
Was this page helpful?
curl --request GET \
--url https://api.case.dev/database/v1/projects/{id} \
--header 'Authorization: Bearer <token>'{
"id": "proj_abc123",
"name": "case-mgmt-db",
"description": "Production case management database",
"region": "aws-us-east-1",
"pgVersion": 17,
"status": "active",
"connectionHost": "ep-quiet-meadow-123456.us-east-1.aws.neon.tech",
"storageSizeBytes": 1073741824,
"computeTimeSeconds": 3600,
"branches": [
{
"id": "branch_main_789",
"name": "main",
"isDefault": true,
"status": "active",
"createdAt": "2025-01-10T08:00:00Z"
},
{
"id": "branch_staging_012",
"name": "staging",
"isDefault": false,
"status": "active",
"createdAt": "2025-01-12T10:00:00Z"
}
],
"databases": [
{
"id": "db_neondb_345",
"name": "neondb",
"ownerName": "neondb_owner"
}
],
"linkedDeployments": [
{
"type": "compute",
"id": "app_xyz789",
"name": "case-portal",
"url": "https://case-portal.case.systems",
"envVarName": "DATABASE_URL"
}
],
"createdAt": "2025-01-10T08:00:00Z",
"updatedAt": "2025-01-15T10:30:00Z"
}