Database schema exploration often looks simple on paper: open a diagram, trace relationships, read column names, and move on. In practice, it’s chaotic. Schemas evolve faster than documentation. Diagrams become outdated. Foreign keys hide across dozens of tables. What should take minutes turns into hours of detective work.

PostSight was built to solve that problem properly.

Instead of relying on static ERDs, PostSight reads directly from a live PostgreSQL database or a raw SQL DDL file and generates an accurate Entity Relationship Diagram every time. The database is the source of truth, so the diagram never goes stale.

Under the hood, SQLAlchemy handles schema reflection and relationship extraction, while Graphviz renders clean, structured diagrams. A custom parser processes PostgreSQL DDL, extracting primary keys, foreign keys, constraints, and defaults, even in complex schemas with multi column relationships.

The output is designed for clarity. Primary keys are highlighted. Foreign keys are clearly connected. Data types and defaults appear under each column. Users can export to SVG, PNG, or PDF, adjust layout direction, and filter schemas to keep diagrams focused.

PostSight turns schema exploration from guesswork into a single command. When the database changes, the diagram updates with it.