fly mpg database extensions list, enable, and disable commands
Introduced 2026-07-08 · score 0.98
HOW TO USE IT
When managing extensions on an MPG cluster from a non-interactive workflow, use the documented list, enable, or disable command for the target database. The current official CLI docs use `databases` in the command path; the card and release note use `database`, so verify the installed CLI’s syntax before running it.
fly mpg databases extensions list <CLUSTER_ID> [flags]fly mpg databases extensions enable <EXTENSION> --cluster <CLUSTER_ID> --database <DATABASE> [--schema <SCHEMA>] [--create-schema]fly mpg databases extensions disable <EXTENSION> --cluster <CLUSTER_ID> --database <DATABASE> [--force]WHY THIS HELPS
Manage extensions on a Managed Postgres cluster from a non-interactive workflow such as CI.
BEFORE THIS CHANGE
The release note says extensions could previously only be enabled via the dashboard.
REQUIREMENTS AND LIMITATIONS
- Version: v0.4.68
- <CLUSTER_ID> (required): Target cluster ID for `list`.
- --database, -d: Target database within the cluster; listed as an option for `list`.
- --json, -j: Output list results as JSON.
- <EXTENSION> (required): Postgres extension to enable or disable.
- --cluster, -c (required): Target cluster ID for enable or disable.
- --database, -d (required): Target database within the cluster for enable or disable.
- --schema: Schema in which to create the extension; default is `public`.
- --create-schema: Create the schema if it does not exist.
- --force: Drop dependent objects as well (`CASCADE`) when disabling.
- --access-token, -t: Fly API access token global option.
- Prerequisite: Use a flyctl version that includes the commands; release v0.4.68 added them.
- Prerequisite: For enable or disable, authenticate with a Fly API access token; docs list `--access-token` as a global option.
- Applies to new V2 clusters and existing V1 clusters.
- Docs conflict: Card and release note use `fly mpg database extensions ...`; current official CLI docs document `fly mpg databases extensions ...` (plural). The official v0.4.68 source is at https://github.com/superfly/flyctl/blob/v0.4.68/internal/command/mpg/extensions.go, but the retrieved source page did not expose command usage text.
FIRST-PARTY EVIDENCE
- https://github.com/superfly/flyctl/releases/tag/v0.4.68
- https://github.com/superfly/flyctl/pull/4983
- https://fly.io/docs/flyctl/mpg-databases-extensions-list/
- https://fly.io/docs/flyctl/mpg-databases-extensions-enable/
- https://docs.fly.io/flyctl/cmd/fly_mpg_databases_extensions_disable
Check the installed version and the source before using it. Entry JSON