---
title: "Get database project"
method: GET
path: "/database/v1/projects/{id}"
tags: ["Database"]
---

# Get database project

`GET /database/v1/projects/{id}`

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.

## Path parameters

- `id` string, required

## Response `200`

Project details retrieved successfully

- object
  - `id` string, required — Project ID
  - `name` string, required — Project name
  - `description` string, nullable — Project description
  - `region` string, required — AWS region
  - `pgVersion` integer, required — PostgreSQL major version
  - `status` 'active' | 'suspended' | 'deleted', required — Project status
  - `connectionHost` string, required — Database connection hostname (masked for security)
  - `storageSizeBytes` number, required — Current storage usage in bytes
  - `computeTimeSeconds` number, required — Total compute time consumed in seconds
  - `branches` object[], required — All branches in this project
    - `id` string — Branch ID
    - `name` string — Branch name
    - `isDefault` boolean — Whether this is the default branch
    - `status` string — Branch status
    - `createdAt` string, date-time — Branch creation timestamp
  - `databases` object[], required — Databases in the default branch
    - `id` string — Database ID
    - `name` string — Database name
    - `ownerName` string — Database owner role name
  - `linkedDeployments` object[], required — Linked deployments using this database
    - `type` 'compute' — Deployment type
    - `id` string — Deployment ID
    - `name` string — Deployment name
    - `url` string — Deployment URL
    - `envVarName` string — Environment variable name for connection string
  - `createdAt` string, date-time, required — Project creation timestamp
  - `updatedAt` string, date-time, required — Project last update timestamp

## Other responses

- `400` — Invalid project ID
- `401` — Invalid or missing API key
- `404` — Database project not found
- `500` — Failed to get database project

---

[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)