What you see

The Schema Viewer is your structural map of the database. For every table you can see columns with their types, primary keys, indexes, and the foreign-key relationships that connect tables to each other.

Screenshot · Schema Viewer with the tree on the left and the diagram on the right.

Schema Viewer with the tree on the left and the diagram on the right.

Tree view

The left-hand tree mirrors the structure of your database: databases → schemas → tables → columns. Each column shows its type and is badged when it's a primary key, nullable, or indexed.

Click a table to expand its columns
Click a column to see full details (type, default, comment)
Right-click for context actions (open in editor, copy name)

Diagram view

The diagram view draws every table as a card and every foreign-key relationship as a labelled arrow. You can:

Pan and zoom around the canvas
Drag tables to rearrange the layout
Auto-arrange with the layout button
Fit-to-screen to see the whole schema at a glance

Working with large schemas

For databases with hundreds of tables, use the filter chip at the top of the diagram to limit which tables show. Start with the tables relevant to your current investigation and add neighbours as needed.

Search and jump

Use the search bar above the diagram to find any table or column. Selecting a result centres the canvas on the table and highlights the column. Great for “wait, what does orders.shipping_statusactually look like?”-style questions.

Where to go next

Want to share the diagram outside DB AI Magic? Head to Exporting Diagrams for every output format we support.