# ClickHouse Postgres API

**Canonical:** https://apis.io/apis/clickhouse/clickhouse-postgres-api/  
**Provider:** ClickHouse — https://apis.io/providers/clickhouse/  
**Base URL:** https://{clickhouse-host}:8443  
**Documentation:** https://clickhouse.com/docs/en/interfaces/http

ClickHouse Postgres API is one of 21 APIs that [ClickHouse](https://apis.io/providers/clickhouse/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include Postgres. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and an API reference.

The Postgres API from ClickHouse — 12 operation(s) for postgres.

## Operations (17)

| Method | Path | Summary |
|---|---|---|
| POST | `/v1/organizations/{organizationId}/postgres` | Create new Postgres service |
| GET | `/v1/organizations/{organizationId}/postgres` | List of organization Postgres services |
| GET | `/v1/organizations/{organizationId}/postgres/{postgresId}` | Get PostgreSQL service details |
| DELETE | `/v1/organizations/{organizationId}/postgres/{postgresId}` | Delete a PostgreSQL service |
| PATCH | `/v1/organizations/{organizationId}/postgres/{postgresId}` | Update a PostgreSQL service |
| GET | `/v1/organizations/{organizationId}/postgres/{postgresId}/caCertificates` | Get Postgres CA certs |
| POST | `/v1/organizations/{organizationId}/postgres/{postgresId}/restoredService` | Restore a Postgres service |
| PATCH | `/v1/organizations/{organizationId}/postgres/{postgresId}/password` | Update Postgres superuser password |
| PATCH | `/v1/organizations/{organizationId}/postgres/{postgresId}/state` | Update Postgres service state |
| POST | `/v1/organizations/{organizationId}/postgres/{postgresId}/readReplica` | Create a read replica for a Postgres service |
| GET | `/v1/organizations/{organizationId}/postgres/{postgresId}/config` | Get PostgreSQL service configuration |
| POST | `/v1/organizations/{organizationId}/postgres/{postgresId}/config` | Replace Postgres service configuration |
| PATCH | `/v1/organizations/{organizationId}/postgres/{postgresId}/config` | Update Postgres service configuration |
| GET | `/v1/organizations/{organizationId}/postgres/{postgresId}/metrics` | Get Postgres time-series metrics |
| GET | `/v1/organizations/{organizationId}/postgres/{postgresId}/slowQueryPatterns` | List Postgres slow query patterns |
| GET | `/v1/organizations/{organizationId}/postgres/{postgresId}/slowQueryPatterns/{queryId}` | Get a Postgres slow query pattern with recent executions |
| GET | `/v1/organizations/{organizationId}/postgres/{postgresId}/logs` | List Postgres server logs |

## Machine-readable artifacts (5)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/openapi/clickhouse-postgres-api-openapi.yml
- **ToolCrosswalk** — https://raw.githubusercontent.com/api-evangelist/clickhouse/refs/heads/main/mcp/clickhouse-tool-crosswalk.yml
- **Documentation** — https://clickhouse.com/docs/cloud/manage/api/api-overview
- **APIReference** — https://clickhouse.com/docs/products/cloud/api-reference/organization/get-list-of-available-organizations
- **Swagger** — https://clickhouse.com/docs/cloud/manage/api/swagger

## Other ClickHouse APIs (12)

- [ClickHouse HTTP Interface](https://apis.io/apis/clickhouse/clickhouse-http-interface/)
- [ClickHouse Native TCP Interface](https://apis.io/apis/clickhouse/clickhouse-native/)
- [ClickHouse MySQL Interface](https://apis.io/apis/clickhouse/clickhouse-mysql/)
- [ClickHouse PostgreSQL Interface](https://apis.io/apis/clickhouse/clickhouse-postgresql/)
- [ClickHouse gRPC Interface](https://apis.io/apis/clickhouse/clickhouse-grpc/)
- [ClickHouse HTTP Interface API](https://apis.io/apis/clickhouse/clickhouse-clickhouse-http-interface-api/)
- [ClickHouse Ping API](https://apis.io/apis/clickhouse/clickhouse-ping-api/)
- [ClickHouse Play API](https://apis.io/apis/clickhouse/clickhouse-play-api/)
- [ClickHouse Replicas Status API](https://apis.io/apis/clickhouse/clickhouse-replicas-status-api/)
- [ClickHouse API keys API](https://apis.io/apis/clickhouse/clickhouse-api-keys-api/)
- [ClickHouse Backup API](https://apis.io/apis/clickhouse/clickhouse-backup-api/)
- [ClickHouse Billing API](https://apis.io/apis/clickhouse/clickhouse-billing-api/)

## Tags

Postgres

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/clickhouse/clickhouse-postgres-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/clickhouse/.