pgplex/pgschema

Health v2 · maintenance only

Adoption not part of the score

1023 stars · 60 forks observed · 2026-09-03

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

pgschema is a Go CLI tool that brings Terraform-style declarative schema migration to PostgreSQL: dump the current schema, edit the desired state, then plan and apply the generated DDL. It is Postgres-only with deep support for Postgres-specific objects like RLS policies, partitioned tables, and partial indexes, and requires no shadow database.

Use cases

• manage postgres schema migrations declaratively like terraform
• replace hand-written flyway or liquibase migration files
• diff edited schema against live database and generate migration DDL
• version-control database schema as plain SQL in git
• reconcile schemas across multi-tenant postgres databases
• apply schema changes safely in CI/CD pipelines
• dump a postgres schema in a clean readable SQL format

When to choose

• you use PostgreSQL 14+ and want state-based, declarative schema management
• you need Postgres-specific features like RLS, partitioning, and partial indexes tracked in migrations
• you want a free open-source tool with no feature gating and no shadow database infrastructure
• you prefer reviewing generated SQL plans before applying changes

When to avoid

• you need to manage database-level settings, roles, tablespaces, or extensions
• you use Windows natively (only Linux and macOS are supported)
• you use MySQL, SQL Server, or other non-Postgres databases
• you prefer traditional numbered migration-file workflows

Facets

cli-tool · maturity active

database infrastructure-as-code cli developer-tools ci-cd databases developer-tools cli go postgres schema-migration declarative terraform-style ddl schema-diff gitops multi-tenant database-migrations devops automation linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="pgplex/pgschema")