DbSchema works with 70+ SQL and NoSQL databases. Connect locally, in the cloud, or on remote servers - all through JDBC drivers.
Visually model tables and keys, reverse from any database, and generate SQL to deploy or sync.
✓ Design tables and relationships visually.
✓ Keep even complex schemas easy to understand.
✓ Start with a high-level model, deploy anywhere.
✓ Stay flexible across any database engine.
✓ Turn SQL scripts into diagrams instantly.
✓ Edit visually, then export back to your database.
Built for massive databases, secure by default, and made for teams. Scale to 10k+ tables, connect via SSL/SSH, and collaborate with Git.
➤ Built to handle massive databases, even with 10.000+ tables.
➤ Navigate complex models without slowdown.
➤ SSL/TLS & SSH Tunnel for secure connections.
➤ Keep your data local - nothing leaves your machine.
➤ Review schema diffs and work in branches with Git.
➤ Share HTML/PDF docs so everyone reads the same model.
Compare schema changes visually, generate interactive documentation, and keep everything versioned with built-in Git.
➤ Generate HTML5docs with diagrams and schema details.
➤ Open in any browser and share easily with your team.
➤ Commit and push schema changes directly from DbSchema.
➤ Collaborate in branches and keep your model in sync.
➤ Run it inside your network (on-prem/VM).
➤ One license, many installs - one active user at a time.
Browse and edit data with multi-level master-detail views, write queries in a smart SQL editor, or build them visually with drag-and-drop.
➤ Browse/edit tables with instant filters and sorting.
➤ Follow relationships via multi-level master-detail.
➤ Write & run SQL with autocomplete and syntax highlighting.
➤ Edit data inline and export results to CSV, Excel, or JSON.
➤ Build queries visually - drag tables, columns, and conditions.
➤ Preview the generated SQL and run it instantly to see results.
Optionally review differences and choose to update the model, commit to the database, or generate scripts.
➤ See model vs. database differences.
➤ Apply changes to the model or commit to the database.
➤ Move updates from dev to test to prod.
➤ Check before applying and keep a rollback.
➤ Move your schema across engines (MySQL → Oracle).
➤ DbSchema creates specific SQL-review diffs and deploy.
Turn on advanced tools only when you need them - generate realistic test data, automate workflows, and manage/monitor your databases without leaving DbSchema.
➤ Populate tables with sample data for development or demos.
➤ Use patterns, regex, and custom lists; save generators.
➤ Run Groovy scripts to automate repeatable jobs.
➤ Generate docs, import/export data, or schedule nightly tasks.
➤ Monitor disk usage, sessions, locks, and user activity.
➤ Optimize roles and resources to improve performance.