dbwarden-pgsql-extensions 0.1.0

DBWarden PostgreSQL extensions object plugin proof.

dbwarden-pgsql-extensions

PostgreSQL extension management for DBWarden.

dbwarden-pgsql-extensions is an official DBWarden plugin. It is discovered automatically through its dbwarden.plugins entry point and loaded without a consent prompt once installed.

What It Provides

An object handler for the pg_extension object type. It participates in DBWarden's schema diff pipeline (extract, canonicalize, diff, emit) so that PostgreSQL extensions declared in your configuration are converged with the database. The handler runs in the preamble, before tables, using public ordering anchors (after=PREAMBLE, before=BEFORE_TABLES).

It emits idempotent DDL:

CREATE EXTENSION IF NOT EXISTS "btree_gist";
-- rollback:
DROP EXTENSION IF EXISTS "btree_gist";

Install

dbwarden plugin add dbwarden-pgsql-extensions

plugin add verifies the package provenance (a PyPI PEP 740 attestation from the official repository) before installing. You can also install it directly:

uv add dbwarden-pgsql-extensions
# or
pip install dbwarden-pgsql-extensions

PostgreSQL only.

Use

Declare the extensions your schema needs in your DBWarden configuration (pg_extensions). With the plugin loaded, dbwarden make-migrations diffs the declared extensions against the live database and emits the CREATE EXTENSION / DROP EXTENSION statements in the correct order. Confirm the plugin is loaded:

dbwarden plugin list

Development

pip install -e . pytest
pytest -q

See the object-plugin docs.

License

MIT