Documentation

Schema Diagrams

Schema diagrams visualize your database tables and their relationships as an interactive node graph.

Opening diagrams

Click the diagram icon in the schema sidebar to generate a diagram of your database schema. Tables appear as nodes and foreign keys appear as edges.

Table nodes

Each node displays:

  • Table name at the top
  • Columns with their data types
  • Primary key indicator (key icon)
  • Foreign key indicator (link icon)

Tables with many columns show the first 12 columns with a count of remaining columns.

Foreign key relationships

Foreign key constraints render as directed edges between table nodes, with labels showing the referenced column. Click a table node to highlight its connections.

Pan and zoom

Drag the canvas to pan. Scroll to zoom in and out. Use the control buttons to zoom to fit or reset the view.

Layout direction

Toggle between vertical (top-to-bottom) and horizontal (left-to-right) layout. The diagram auto-arranges nodes to minimize edge crossings.

Rearranging

Drag individual table nodes to rearrange them manually. Click Reset to return to the auto-arranged layout.

Exporting as PNG

Click the download button to export the diagram as a PNG image.

Supported engines

Schema diagrams work with PostgreSQL, MySQL/MariaDB, and SQLite — any engine that supports foreign key introspection.