Question 1

How do I visualize my database schema online?

Accepted Answer

Export your schema as DDL (e.g. pg_dump --schema-only, mysqldump --no-data, or your IDE's 'Generate DDL'), paste it into the Schema Explorer or open the .sql file, and click Explore. An interactive ER diagram with all table relationships is drawn instantly in your browser.

Question 2

Is it safe to paste my database schema here?

Accepted Answer

Yes. The DDL is parsed entirely in your browser with JavaScript. Your schema is never uploaded to any server.

Question 3

Which databases are supported?

Accepted Answer

PostgreSQL, MySQL, MariaDB, Oracle, SQL Server, DB2 and SQLite - the parser understands the common CREATE TABLE, ALTER TABLE ADD CONSTRAINT and COMMENT ON syntax emitted by each engine's dump tools.

Question 4

Can I add comments to tables and columns?

Accepted Answer

Yes. Click any table or column in the diagram to annotate it. Annotations are kept in your browser and can be exported as COMMENT ON statements (PostgreSQL, Oracle, DB2), ALTER TABLE statements (MySQL), sp_addextendedproperty calls (SQL Server), or as a Markdown data dictionary.

Database Schema Explorer

Table DDL

Export schema documentation

Send Feedback