pgplex
Official@pgplex
Modern Developer Stack for Postgres
Agent Skills by pgplex
Showing 6 vetted skills indexed across 1 GitHub repositories.
pgplexreview_comments
Triage and respond to GitHub PR review comments using the gh CLI.
pgplexfix_bug
Fixes GitHub issue bugs in pgschema using a TDD workflow with reproducing tests and PRs.
pgplexValidate with Database
Validate PostgreSQL schema drift by comparing pg_dump with pgschema outputs.
pgplexRun Tests
Run unit, integration, and dump tests for pgschema changes against fixtures.
pgplexPostgreSQL Syntax Reference
Parse PostgreSQL SQL and generate valid DDL in pgschema.
pgplexpg_dump Reference
Query PostgreSQL system catalogs and extract schema information using pg_dump patterns.
Frequently Asked Questions About pgplex
FAQPage SchemaWhat specific database tasks does pgplex enable?▼
Pgplex enables precise PostgreSQL schema validation, drift detection between live environments and pgschema outputs, and the generation of valid DDL. It facilitates rigorous testing of database changes by running unit and integration tests against established fixtures.
Which technical personas benefit from using pgplex?▼
Database administrators, backend engineers, and site reliability engineers managing PostgreSQL infrastructure benefit from these capabilities. It is designed for professionals requiring strict schema consistency, version-controlled database definitions, and reliable deployment validation within complex relational environments.
What are the primary prerequisites for implementing pgplex?▼
Implementation requires an existing PostgreSQL environment and access to pg_dump for schema extraction. Users must have their database schema defined within the pgschema format to enable comparison, drift detection, and the execution of the provided test suites.