DbSchema is a desktop tool for visualizing, designing, documenting, and working with SQL and NoSQL databases. It supports more than 70 databases through JDBC and can download the needed driver. Users can create interactive schema diagrams, separate subsystem diagrams, and generate schemas for supported engines. Design can begin without a database connection: the physical schema is saved locally as a .dbs file. For connected databases, synchronization compares the model with the database and generates migration SQL for review before changes are applied. Its SQL editor offers schema-aware autocomplete, and a visual query builder lets users arrange tables, joins, and filters and inspect SQL before it runs. DbSchema can publish interactive HTML5 schema documentation that opens in a browser without an installation or license. Connections run from the user’s computer directly to the database, with optional SSL and SSH tunnels. Community Edition is free forever for any use. Pro Monthly costs 29.40 USD per month plus taxes; Architect Monthly costs 47.04 USD per month plus taxes.
Who it is for
DbSchema suits people who design or manage SQL and NoSQL databases on Linux, macOS, or Windows. Community Edition is available for free use, while Pro and Architect plans cover additional design and management capabilities.
What is good
- Supports more than 70 SQL and NoSQL databases.
- Design schemas offline and save them locally.
- Review generated migration SQL before applying changes.
- Publish browser-based interactive HTML5 documentation.
What to know first
- Community Edition excludes documentation, sync, and data tools.
- Pro Monthly costs 29.40 USD per month plus taxes.
- Architect Monthly costs 47.04 USD per month plus taxes.
Verdict
DbSchema brings database modeling, queries, documentation, and schema synchronization into a desktop application. The free edition omits several tools, so check which edition includes the capabilities you need.
DbSchema plans and pricing
All plansCompared on database design tools
- Free plan
- Yes
- Reverse engineering
- Yes
- Forward engineering
- Yes
- SQL export
- Yes
- Supported databases
- Access, Amazon Athena, Amazon Timestream, Apache Drill, Apache Druid, Apache Ignite, Apache Pinot, Apache Solr, Aurora MySQL, Aurora PostgreSQL, Azure Synapse, Azure SQL, Cache, Cassandra, ClickHouse, Cockroach, Couchbase, CrateDB, CSV Files, CTreeAce, CUBRID, DaffodilDb, Databricks, Dataverse, Db2, DBF/FoxPro/xBase, Derby, DocumentDB, Dremio, DuckDB, DynamoDB, Elasticsearch, EnterpriseDB, Exasol, Fabric Lakehouse, FileMaker, Firebird, Firebolt, FrontBase, Google AlloyDB
- Team collaboration
- Yes
- Version history
- Yes
- Deployment
- desktop
