DbSchema turns any of 100+ SQL and NoSQL databases into ER diagrams and documentation your whole team can browse — then lets you design, query, and deploy schema changes from the same model.
Trusted by teams at
The schema lives in the database, the documentation is a wiki page from two years ago, and the only person who really understands the model is the one who built it. Every new table, every migration, and every new joiner costs more than it should.
DbSchema gives the team one model they can all see: versioned, documented, and reviewable.
From the first diagram to the production migration, without switching tools.
Connect to a cloud, remote, or on-premise database and get the complete ER diagram — tables, keys, and relationships — without writing a query.
Publish interactive HTML5 documentation with diagrams, comments, and hover details. It opens in any browser, so analysts, managers, and new joiners never have to ask you.
Compare your model against development, test, and production, review every difference, and apply only what you approved.
Split large systems into focused diagrams, group what belongs together, and see only the tables that matter to the task at hand.
Start database-agnostic, then generate the physical schema for PostgreSQL, MySQL, MongoDB, or any supported engine with your naming and type rules applied.
Diff two model versions or two environments and get the migration script, in the target database's own SQL dialect.
Browse related records through foreign keys — real or virtual — and edit rows inline, in context, instead of one table at a time.
Drag tables, joins, filters, and grouping into place, then read the generated SQL before you run it.
Autocomplete that knows your tables, script execution, and results you can edit inline and export to CSV, Excel, or JSON.
Generate realistic test data with reusable patterns and rules, so development and QA work against something that looks real.
Script documentation, schema sync, imports, and exports in Groovy, then schedule them to run on their own.
Track sessions, locks, users, and resource usage from the same workspace you design in.
Ask for the query in plain English, paste one in and ask what it does, or ask what index would make it faster. The Assistant reads your own design model, so the answers are about your tables, not generic examples.
See What the AI Assistant Can Do
Your schema lives in a design model file, not only in the server. That one difference is what lets you work offline, review changes like code, and decide exactly what reaches production.
Model and change the schema on a plane, in a meeting, or before the database exists.
Branch, diff, and pull-request the schema in Git, in the same workflow as the rest of your project.
Read the exact statements a change will run before anything touches the database.
Move the same reviewed change through development, test, and production, one approval at a time.
Watch more video tutorials
Six roles, one model. Everyone reads the same schema, and nobody has to ask who owns the answer.
Find the table you need in a schema you didn't write, and get the join right the first time.
Model logically once, generate the physical schema for every engine you support, and keep naming consistent.
Follow relationships across tables and build the query visually, without asking anyone for the schema.
Compare production with what was approved, and read every statement before it runs.
Open the HTML documentation in a browser and see exactly what data the application stores.
Learn what a real schema looks like by exploring one: relationships, keys, and all.
No signup. Free Community Edition and a 15-day Architect trial in the same installer.
Jump straight to the workflow that matches what you need today.
No signup. Free Community Edition. 15-day Architect trial in the same installer.