# Fly Io Postgres Clusters API

**Canonical:** https://apis.io/apis/fly-io/fly-io-postgres-clusters-api/  
**Provider:** Fly Io — https://apis.io/providers/fly-io/  
**Base URL:** https://api.machines.dev  
**Documentation:** https://fly.io/docs/machines/api/

Fly Io Postgres Clusters API is one of 14 APIs that [Fly Io](https://apis.io/providers/fly-io/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include Postgres Clusters. The published artifact set on APIs.io includes an OpenAPI specification.

Create and manage Postgres clusters, including databases, users, extensions, backups, and app attachments.

## Operations (25)

| Method | Path | Summary |
|---|---|---|
| GET | `/v1/postgres` | List Postgres Clusters |
| POST | `/v1/postgres` | Create Postgres Cluster |
| GET | `/v1/postgres/plans` | List Postgres Plans |
| GET | `/v1/postgres/{postgres_cluster_id}` | Get Postgres Cluster |
| DELETE | `/v1/postgres/{postgres_cluster_id}` | Delete Postgres Cluster |
| POST | `/v1/postgres/{postgres_cluster_id}/attachments` | Attach Cluster to App |
| DELETE | `/v1/postgres/{postgres_cluster_id}/attachments/{app_name}` | Detach Cluster from App |
| GET | `/v1/postgres/{postgres_cluster_id}/backups` | List Backups |
| POST | `/v1/postgres/{postgres_cluster_id}/backups` | Create Backup |
| GET | `/v1/postgres/{postgres_cluster_id}/databases` | List Databases |
| POST | `/v1/postgres/{postgres_cluster_id}/databases` | Create Database |
| DELETE | `/v1/postgres/{postgres_cluster_id}/databases/{database_name}` | Drop Database |
| GET | `/v1/postgres/{postgres_cluster_id}/databases/{database_name}/extensions` | List Extensions |
| POST | `/v1/postgres/{postgres_cluster_id}/databases/{database_name}/extensions` | Enable Extension |
| DELETE | `/v1/postgres/{postgres_cluster_id}/databases/{database_name}/extensions/{extension_name}` | Disable Extension |
| POST | `/v1/postgres/{postgres_cluster_id}/fork` | Fork Cluster to New Cluster |
| GET | `/v1/postgres/{postgres_cluster_id}/queries/active` | List Active Queries |
| GET | `/v1/postgres/{postgres_cluster_id}/queries/slow` | List Slow Queries |
| POST | `/v1/postgres/{postgres_cluster_id}/restore` | Restore Backup or Point in Time to New Cluster |
| GET | `/v1/postgres/{postgres_cluster_id}/users` | List Users |
| POST | `/v1/postgres/{postgres_cluster_id}/users` | Create User |
| DELETE | `/v1/postgres/{postgres_cluster_id}/users/{username}` | Delete User |
| PATCH | `/v1/postgres/{postgres_cluster_id}/users/{username}` | Update User Role |
| GET | `/v1/postgres/{postgres_cluster_id}/users/{username}/credentials` | Get User Credentials |
| POST | `/v1/postgres/{postgres_cluster_id}/users/{username}/rotate_password` | Rotate User Password |

## Machine-readable artifacts (1)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/fly-io/refs/heads/main/openapi/fly-io-postgres-clusters-api-openapi.yml

## Other Fly Io APIs (12)

- [Fly.io Machines API](https://apis.io/apis/fly-io/machines-api/)
- [Fly.io GraphQL API](https://apis.io/apis/fly-io/graphql-api/)
- [Fly.io Extensions API](https://apis.io/apis/fly-io/extensions-api/)
- [fly-io Apps API](https://apis.io/apis/fly-io/fly-io-apps-api/)
- [fly-io SSO API](https://apis.io/apis/fly-io/fly-io-sso-api/)
- [fly-io Tokens API](https://apis.io/apis/fly-io/fly-io-tokens-api/)
- [fly-io Volumes API](https://apis.io/apis/fly-io/fly-io-volumes-api/)
- [fly-io Webhooks API](https://apis.io/apis/fly-io/fly-io-webhooks-api/)
- [Fly Io O Auth API](https://apis.io/apis/fly-io/fly-io-oauth-api/)
- [Fly Io Organizations API](https://apis.io/apis/fly-io/fly-io-organizations-api/)
- [Fly Io Platform API](https://apis.io/apis/fly-io/fly-io-platform-api/)
- [Fly Io Secrets API](https://apis.io/apis/fly-io/fly-io-secrets-api/)

## Tags

Postgres Clusters

---

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