---
title: "List database projects"
method: GET
path: "/database/v1/projects"
tags: ["Database"]
---

# List database projects

`GET /database/v1/projects`

Retrieves all serverless Postgres database projects for the authenticated organization. Includes storage and compute metrics, plus linked application deployments and Compute instances.

## Response `200`

Projects retrieved successfully

- object
  - `projects` object[], required
    - `id` string — Project ID
    - `name` string — Project name
    - `description` string, nullable — Project description
    - `region` string — AWS region where database is deployed
    - `pgVersion` integer — PostgreSQL major version
    - `status` 'active' | 'suspended' | 'deleted' — Current project status
    - `storageSizeBytes` number — Current storage usage in bytes
    - `computeTimeSeconds` number — Total compute time consumed in seconds
    - `linkedDeployments` object[] — Linked application deployments using this database
      - `type` 'compute' — Type of deployment
      - `id` string — Deployment ID
      - `name` string — Deployment name
      - `url` string — Deployment URL
    - `createdAt` string, date-time — Project creation timestamp
    - `updatedAt` string, date-time — Project last update timestamp

## Other responses

- `401` — Invalid or missing API key
- `500` — Failed to list database projects

---

[API](https://skmtc.net/casemark/apis/case-dev-api.md) · [All operations](https://skmtc.net/casemark/apis/case-dev-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/casemark/case-dev-api/revisions/5b7e64e6d6f9/schema)