Explore your schema

Inspect table structure

Open a table’s structure view to inspect columns, indexes and foreign keys. Supported engines also provide dialogs for changing columns and managing indexes or relationships.

Review the generated DDL before applying a schema change. Support varies by engine; ClickHouse schema editing is limited.

Explore the ERD

1. Open the ERD for the schema you want to inspect. Select another schema if the connection offers multiple choices.
2. Pan, zoom and move tables to follow relationships. Use the minimap or reset controls to regain your position.
3. Export the diagram as SVG or PNG when you need to share a view of the schema.

Compare structures and data

Schema comparison helps identify differences between supported database structures. It compares tables, not views. Review the difference before planning any migration.

Data comparison and result-set comparison help inspect changes in values. A difference report is not an automatic guarantee that two databases are interchangeable.