pgschema
Official@pgschema
Declarative schema migration for Postgres
Agent Skills by pgschema
Showing 4 vetted skills indexed across 1 GitHub repositories.
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 About pgschema
FAQPage SchemaWhat specific database tasks does pgschema enable?▼
It enables declarative schema management by comparing live PostgreSQL system catalogs against defined states. Users can perform schema diffing, generate DDL statements, and validate database integrity by cross-referencing live outputs with expected grammar rules.
Which technical personas benefit from using pgschema?▼
Database administrators, backend engineers, and site reliability engineers managing PostgreSQL infrastructure benefit from these capabilities. It is designed for professionals requiring precise control over schema evolution and consistency across development, staging, and production environments.
What are the prerequisites for running pgschema tests?▼
Execution requires a Go development environment to run the provided test suites. Users must have access to a PostgreSQL instance to perform schema extraction via system catalog queries and validate results against pg_dump outputs.