skills.rest
pgplexpgplexOfficial·6 Agent Skills Included

pgschema

Declarative Terraform-style schema migrations for PostgreSQL databases

Generates PostgreSQL migration plans automatically by comparing your desired schema files against the live database. Eliminates hand-written migration scripts, shadow databases, and manual change sequencing. Dumps, diffs, plans, and applies schema changes safely with concurrent change detection and lock timeout control.
1,023|60
↗
npx skills add pgplex/pgschema --all -g -y
Available:

Tells the AI agent how the pgschema codebase is structured, which development skills to invoke for tasks like testing, bug fixing, and database validation, and how to run builds and tests.

All Skills in This Repository (6)

Pure Emerald Level Indicators
📦 In Repo
pgplexpgplex

Validate with Database

Validate PostgreSQL schema drift by comparing pg_dump with pgschema outputs.

Official
Intermediate
📦 In Repo
pgplexpgplex

Run Tests

Run unit, integration, and dump tests for pgschema changes against fixtures.

Official
Advanced
📦 In Repo
pgplexpgplex

PostgreSQL Syntax Reference

Parse PostgreSQL SQL and generate valid DDL in pgschema.

Official
Intermediate
📦 In Repo
pgplexpgplex

pg_dump Reference

Query PostgreSQL system catalogs and extract schema information using pg_dump patterns.

Official
Advanced
📦 In Repo
pgplexpgplex

review_comments

Triage and respond to GitHub PR review comments using the gh CLI.

Official
Intermediate
📦 In Repo
pgplexpgplex

fix_bug

Fixes GitHub issue bugs in pgschema using a TDD workflow with reproducing tests and PRs.

Official
Advanced

Frequently Asked Questions

FAQPage Schema
How to install pgschema?▼

Run `npx skills add pgplex/pgschema --all -g -y` in your terminal to install all skills in this suite globally.

How does pgschema differ from Flyway or Liquibase?▼

Instead of writing numbered migration files, you declare the desired schema as plain SQL and pgschema generates the migration plan automatically, with no history table required.

Does pgschema need a shadow database?▼

No. It spins up a temporary embedded PostgreSQL instance internally to validate plans and cleans up after itself, so no extra infrastructure is needed.

Which PostgreSQL versions and objects are supported?▼

pgschema supports PostgreSQL 14 through 18 and covers tables, indexes, triggers, views, functions, row-level security policies, partitions, privileges, and more.

Can AI agents use pgschema for database changes?▼

Yes. It ships agent-ready skills and llms.txt documentation so AI coding assistants can dump, plan, and apply schema changes safely on your behalf.

Related Repositories in Software Engineering

View All in Software Engineering→
openclawopenclaw
388.4k

openclaw

Run a personal AI assistant across your devices and chat apps

Official📦 120 Skills
obraobra
280.0k

superpowers

Gives coding agents a disciplined workflow from idea to merged code

Community📦 15 Skills
facebookfacebook
248.4k

react

AI agent skills for building, testing, and porting React core

Official📦 14 Skills