pgschema
Declarative Terraform-style schema migrations for PostgreSQL databases
All Skills in This Repository (4)
Pure Emerald Level Indicators
pgschemaValidate with Database
Validate live PostgreSQL schemas by comparing pg_dump and pgschema outputs.
pgschemaRun Tests
Run Go test suites for diff, plan, and dump workflows.
pgschemaPostgreSQL Syntax Reference
Map PostgreSQL grammar rules to DDL generation and SQL parsing.
pgschemapg_dump Reference
Guide developers in querying PostgreSQL system catalogs for schema extraction.
Frequently Asked Questions
FAQPage SchemaHow to install pgschema?▼
Run `npx skills add pgschema/pgschema --all -g -y` in your terminal to install all skills in this suite globally.
How does pgschema handle database migrations?▼
You declare the desired schema in plain SQL files, and pgschema diffs them against the live database to generate and apply the migration plan automatically, like Terraform for PostgreSQL.
Does pgschema need a shadow database?▼
No. It uses an embedded PostgreSQL instance internally to validate plans and cleans up after itself, so no extra infrastructure is required.
Which PostgreSQL versions does pgschema support?▼
pgschema supports PostgreSQL versions 14 through 18, including Postgres-specific objects like row-level security, partitioning, and constraint triggers.
Can AI agents use pgschema skills?▼
Yes. The bundled skills follow the standard SKILL.md format and guide agents through testing, database validation, and bug fixing in Claude Code and compatible tools.
Related Repositories in Software Engineering
View All in Software Engineering→
openclawopenclaw
Run a personal AI assistant across your devices and chat apps
obrasuperpowers
Gives coding agents a disciplined workflow from idea to merged code
facebookreact
AI agent skills for building, testing, and porting React core