{"repo":"pgplex/pgschema","free":true,"listed":false,"github":"https://github.com/pgplex/pgschema","clone":"git clone https://github.com/pgplex/pgschema.git","description":"Terraform-style, declarative Postgres schema migration. Agent friendly.","language":"Go","stars":1003,"topics":["gitops","postgres","postgresql","schema","schema-migration","schema-migrations","terraform","schema-change","cicd","ddl"],"license":"Apache-2.0","category":"deployment-docker-iac","readme_excerpt":"[!NOTE] pgplex: The Postgres Toolchain for Humans and Agents - pgconsole · pgschema · pgtui · pgparser Brought to you by Bytebase, open-source database governance platform. pgschema is a CLI tool that brings Terraform-style declarative schema migration to PostgreSQL. Instead of writing migration files by hand, you declare the desired schema state and pgschema generates the migration plan automatically. - Dump : Extract the current database schema as SQL files - Plan : Diff your edited schema against the live database, generate migration DDL - Apply : Execute with concurrent change detection, transaction-adaptive execution, and lock timeout control See more details in the introduction blog post. Watch in action: Why pgschema State-based, not migration-file-based Tools like Flyway and Liquibase require you to write and number migration files manually. pgschema works like Terraform: you declare what the schema should look like , and it figures out the SQL to get there. No migration history table, no manual sequencing. Deep Postgres support pgschema is Postgres-only, which means it handles Postgres-specific objects that generic tools skip: row-level security policies, partitioned tables, partial indexes, constraint triggers, identity columns, domain types, default privileges, and column-level grants. See the full list below. No shadow database required Most state-based tools spin up a temporary \"shadow\" database to validate migrations. pgschema uses an embedded Postgres instance ","default_branch":null,"files":null,"tree":[],"storefront":"/r/pgplex","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pgplex/pgschema/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}