---
title: "List the project's issued database credentials"
method: GET
path: "/v1/projects/{project_id}/database/access"
---

# List the project's issued database credentials

`GET /v1/projects/{project_id}/database/access`

## Request

- Base URL: `https://app.ohmyho.st`
- URL: `https://app.ohmyho.st/v1/projects/{project_id}/database/access`
- Auth: HTTP bearer

Returns at most the 50 newest credentials with their derived state (active, expired or revoked). Connection URIs and passwords are never returned again; only the credential metadata is readable.

## Path parameters

- `project_id` string, required

## Query parameters

- `environment` 'dev' | 'prod'

## Headers

- `X-Request-Id` string

## Response `200`

The newest database credentials for this project, newest first.

- ProjectDatabaseAccessPage
  - `items` ProjectDatabaseAccess[], required
    - `access_id` string, required
    - `environment` 'dev' | 'prod', required
    - `mode` 'read' | 'write', required
    - `role_name` string, required
    - `host` string, required
    - `database` 'neondb', required
    - `label` string, nullable, required
    - `state` 'active' | 'expired' | 'revoked', required
    - `issued_at` string, date-time, required
    - `expires_at` string, date-time, required
    - `revoked_at` string, date-time, nullable, required
    - `revocation_reason` 'principal' | 'expired' | 'budget' | 'creation_failed' | 'data_change' | 'null', nullable, required

## Other responses

- `400`: The request failed.
- `401`: The request failed.
- `404`: The resource does not exist or is not visible to the authenticated principal.
- `429`: The request failed.
- `503`: The request failed.

---

[API](https://skmtc.dev/ohmyho/apis/ohmyho-st-api.md) · [All operations](https://skmtc.dev/ohmyho/apis/ohmyho-st-api/llms.txt) · [OpenAPI document](https://skmtc.dev/ohmyho/apis/ohmyho-st-api/revisions/d069888c0017?raw)