---
title: "List all databases"
method: GET
path: "/project/{project}/service/{service_name}/clickhouse/db"
tags: ["Service:_ClickHouse"]
---

# List all databases

`GET /project/{project}/service/{service_name}/clickhouse/db`

## Path parameters

- `project` string, required
- `service_name` string, required

## Response `200`

Response

- ServiceClickHouseDatabaseListResponse — ServiceClickHouseDatabaseListResponse
  - `databases` object[], required — List of databases
    - `engine` string, required — Database engine
    - `name` string, required — Database name
    - `required` boolean, required — Required database
    - `state` 'ok' | 'pending_creation' | 'pending_removal' — Database state
  - `errors` object[] — List of errors occurred during request processing
    - `message` string, required — Printable error message
    - `more_info` string — URL to the documentation of the error
    - `status` integer, required — HTTP error status code
  - `message` string — Printable result of the request

---

[API](https://skmtc.net/aiven/apis/aiven-api-documentation.md) · [All operations](https://skmtc.net/aiven/apis/aiven-api-documentation/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aiven/aiven-api-documentation/versions/ecaeabf1da31/schema)