{"repo":"vmkteam/pgdesigner","free":true,"listed":false,"github":"https://github.com/vmkteam/pgdesigner","clone":"git clone https://github.com/vmkteam/pgdesigner.git","description":"Visual PostgreSQL schema designer — ERD, linting, diffing, test data generation","language":"Go","stars":19,"topics":["database","ddl","diff","erd","go","linting","postgresql","schema-designer","sql","vue"],"license":null,"category":"databases-storage","readme_excerpt":"PgDesigner Visual PostgreSQL schema designer with git-friendly .pgd XML format, diff/ALTER engine, and 66 lint rules. Ships as a single binary — no cloud, no account, no telemetry. Website · Live Demo · Docs · Changelog Why PgDesigner Most schema design tools are either database-agnostic (losing PG-specific features) or store schemas in binary formats that break git workflows. PgDesigner is built exclusively for PostgreSQL and solves both problems: - PG-specialized — full PostgreSQL 18 DDL: partitions, RLS, domains, triggers, GIN/GiST indexes, identity columns - Git-friendly format — .pgd XML that diffs cleanly in pull requests, no binary blobs - Diff/ALTER engine — compare two schema versions, generate migration SQL with hazard detection - 66 lint rules — naming conventions, missing indexes, FK integrity, type checks — with autofix - No cloud, no account — runs locally, your schemas stay on your machine Features Feature Description --------- ------------- ERD Canvas Interactive schema diagram for 120+ tables, auto-layout, dark/light theme Table Editor Columns, constraints, indexes, FK with inline editing DDL Generation Complete CREATE/ALTER SQL from schema model Diff Engine Semantic ALTER between two schemas with hazard warnings Lint & Autofix 66 rules: naming, types, FK, indexes, constraints Sample Data Generate realistic INSERT statements from schema Import pgModeler (.pdd), DbSchema (.dbs), Toad (.dm2), plain SQL, live PostgreSQL Reverse Engineering I","default_branch":null,"files":null,"tree":[],"storefront":"/r/vmkteam","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/vmkteam/pgdesigner/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."}