Retrieves all serverless Postgres database projects for the authenticated organization. Includes storage and compute metrics, plus linked deployments from Thurgood apps and Compute instances.
curl --request GET \
--url https://api.case.dev/database/v1/projects \
--header 'Authorization: Bearer <token>'{
"projects": [
{
"id": "proj_abc123",
"name": "case-management-db",
"description": "Production database for case management system",
"region": "aws-us-east-1",
"pgVersion": 17,
"status": "active",
"storageSizeBytes": 1073741824,
"computeTimeSeconds": 3600,
"linkedDeployments": [
{
"type": "thurgood",
"id": "app_xyz789",
"name": "case-portal",
"url": "https://case-portal.case.systems"
}
],
"createdAt": "2025-01-10T08:00:00Z",
"updatedAt": "2025-01-15T10:30:00Z"
}
]
}Was this page helpful?
curl --request GET \
--url https://api.case.dev/database/v1/projects \
--header 'Authorization: Bearer <token>'{
"projects": [
{
"id": "proj_abc123",
"name": "case-management-db",
"description": "Production database for case management system",
"region": "aws-us-east-1",
"pgVersion": 17,
"status": "active",
"storageSizeBytes": 1073741824,
"computeTimeSeconds": 3600,
"linkedDeployments": [
{
"type": "thurgood",
"id": "app_xyz789",
"name": "case-portal",
"url": "https://case-portal.case.systems"
}
],
"createdAt": "2025-01-10T08:00:00Z",
"updatedAt": "2025-01-15T10:30:00Z"
}
]
}