{"repo":"fmguerreiro/pgmold","free":true,"listed":false,"github":"https://github.com/fmguerreiro/pgmold","clone":"git clone https://github.com/fmguerreiro/pgmold.git","description":"PostgreSQL schema-as-code management tool","language":"Rust","stars":16,"topics":["cli","database","devops","migrations","postgresql","rust","schema"],"license":"MIT","category":"databases-storage","readme_excerpt":"pgmold PostgreSQL schema-as-code management tool. Define schemas in native PostgreSQL DDL, diff against live databases, plan migrations, and apply them safely. Features - Schema-as-Code : Define PostgreSQL schemas in native SQL DDL files - Introspection : Read schema from live PostgreSQL databases - Diffing : Compare schemas and generate migration plans - Safety : Lint rules prevent destructive operations without explicit flags - Drift Detection : Detect schema drift in CI/CD - Transactional Apply : All migrations run in a single transaction - Partitioned Tables : Full support for PARTITION BY and PARTITION OF syntax - JSON Output : Machine-readable output for all commands via --json / -j - Describe : Inspect available commands, object types, and providers with pgmold describe - Grant Management : GRANT / REVOKE sync enabled by default; --manage-ownership for ALTER OWNER - Environment Variable : Set connection string via PGMOLD DATABASE URL - PostgreSQL 13-17 : Tested against every major version (compatibility matrix) How pgmold Works Example: Your schema file says: Database currently has: pgmold generates only the delta: Installation For the latest version from source: Quick Start Usage Guides Multi-File Schemas Organize your schema across multiple files using directories or glob patterns: Example directory structure: Duplicate definitions across files produce an error with file locations. Filtering Objects Filter by name patterns or object types. Filter by name pattern: Fil","default_branch":null,"files":null,"tree":[],"storefront":"/r/fmguerreiro","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fmguerreiro/pgmold/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."}