DbSchema
dbschema.com
- Free plan
- Windows
- macOS
- Linux
What DbSchema is
DbSchema is a desktop tool for 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 build interactive schema diagrams, separate subsystems into diagrams, and generate schemas for supported database engines. Design work can begin without a database connection: the physical schema is saved locally as a .dbs file. Schema synchronization compares a model with a database and creates migration SQL for review before changes are applied. The SQL editor provides schema-aware autocomplete, while the visual query builder lets users arrange tables, joins, and filters and inspect the SQL before running it. DbSchema can publish interactive HTML5 schema documentation that opens in a browser without an installation or license. Connections run directly from the user's computer to the database and can use configured SSL and SSH tunnels. Community Edition is free; Pro Monthly costs $29.40 a month and Architect Monthly costs $47.04 a month, plus taxes. The shared installer needs no registration and includes a 15-day Architect trial, extendable by 15 days.
Who it suits
DbSchema suits database designers and administrators who need to model, query, document, or synchronize SQL and NoSQL databases. Its offline design mode also suits users who want to create a schema before connecting to a database.
Good to know, and what to watch
- Supports 70+ SQL and NoSQL databases through JDBC
- Can create physical schemas without database connectivity
- Migration SQL is available for review before applying
- Published HTML5 documentation opens without installation or license
- Community Edition is free
- Pro Monthly costs $29.40 a month plus taxes
- Architect Monthly costs $47.04 a month plus taxes
- Optional AI Assistant add-on costs $9 a month plus taxes
Plans
Every plan and pricePro
Architect
Community Edition
AI Assistant add-on
Free plan · 15-day trial
Getting started
- Download the shared DbSchema installer
- Install the Community, Pro, or Architect edition on Linux, macOS, or Windows
- Start the 15-day Architect trial, extendable by 15 days
- Connect directly to a database and let DbSchema download its JDBC driver
- Create or open a local .dbs design model
- Connect a GitHub, GitLab, Bitbucket, or self-hosted Git repository
Limits to check
Community Edition is free forever but excludes documentation, synchronization, and data tools. The Architect trial lasts 15 days and can be extended by another 15 days; paid perpetual plans include limited update coverage before optional renewals.
The Club's review
DbSchema is a desktop workspace for designing, querying, synchronizing and documenting SQL and NoSQL databases. It suits developers and database teams who want visual modeling alongside direct database access, especially when they work across different engines. Its breadth is a strength, but the free edition omits synchronization and data tools, so many day-to-day workflows require a paid plan.
Overview
DbSchema supports more than 70 SQL and NoSQL databases through JDBC and can fetch the driver a connection needs. Its diagrams can model a database before a live connection exists: the physical schema and design are saved locally in a .dbs file. When connected, the tool can compare a model with a database and prepare migration SQL for review before anyone applies the changes.
That local-first approach is useful for planning and for keeping database work on the user's computer. Connections go directly from DbSchema to the database, with SSL and SSH tunnels available when configured; they do not pass through a DbSchema server. Remembered credentials are stored locally. The optional AI Assistant sends questions and any attached tables or files to the selected AI provider, a separate data flow worth considering before using it with sensitive material.
DbSchema is made by Wise Coders, headquartered in Fürstenfeldbruck, Germany. The company describes the application as built with OpenJDK and JavaFX and states that it is ISO 27001 certified.
Key features
Model schemas visually
Interactive diagrams support schema design, with separate diagrams for different subsystems. DbSchema can also generate a physical schema for a supported engine, and supports reverse engineering, forward engineering and SQL export. This makes it relevant both when shaping a new database and when understanding an existing one. Offline modeling is a practical advantage, though saving and loading design files is a Pro feature rather than part of Community Edition.
Query and prepare changes
The SQL editor offers autocomplete informed by the schema. For users who prefer a visual starting point, the query builder arranges tables, joins and filters, then shows the SQL before execution. That preview makes the builder useful for learning or checking a query, while the editor serves people who prefer to write SQL directly. Schema synchronization can generate migration SQL for review, but it is also outside the free edition.
Document and collaborate
DbSchema can publish interactive HTML5 documentation that opens in a browser without an installation or license, making it practical to share a schema reference. Its Git workflow works with GitHub, GitLab, Bitbucket and self-hosted Git servers, giving teams familiar repository options for collaboration and version history. Documentation and synchronization are among the capabilities reserved for paid plans.
Support is available through the in-app function, GitHub, email, a support ticket or a booked call. The shared installer includes Community, Pro and Architect editions, requires no registration, and starts a 15-day Architect trial that can be extended once by 15 days.
Pricing
Community Edition is free, billed free forever for any use. It includes database connections, reverse engineering, interactive diagrams, table and column creation, and an SQL editor. It excludes documentation, synchronization and data tools. This is a meaningful free starting point for exploring or inspecting schemas, but not a complete free workflow for publishing documentation or managing changes.
Pro and Architect are named editions, but their prices are custom pricing. Pro adds design-file saving and loading and schema synchronization to Community. Architect adds logical and conceptual design to Pro, for teams that need to plan a model before selecting a database engine. The 15-day Architect trial offers a way to evaluate the top edition without registration.
The published subscription and perpetual options clarify the cost of the paid capabilities:
- Pro Monthly Subscription: $29.40 a month, billed monthly, plus taxes; cancel anytime. Includes all databases, documentation, visual querying and data browsing, schema synchronization and migration, and a data generator and importer. It fits users who need the full operational toolset but want monthly terms.
- Architect Monthly: $47.04 a month, plus taxes; cancel anytime, with the latest updates included. It adds logical and conceptual modeling before choosing an engine, plus physical schema generation for supported databases. This is the relevant monthly option for database planning across engines.
- Pro Perpetual: $294 one time, plus taxes. It includes the Pro capabilities, with the first year of maintenance and upgrades free; after that, maintenance and upgrades cost $75 a year. It suits buyers who prefer an upfront license and can accept a separate annual renewal for continued maintenance and upgrades.
- Architect Perpetual: $470.40 one time, plus taxes. It includes one year of updates, then renewal is optional at $120 a year, and adds logical and conceptual modeling and physical schema generation. It suits longer-term users who need Architect's planning features and are comfortable managing updates separately after year one.
The AI Assistant add-on costs $9 a month plus taxes and works with Community, Pro and Architect. It includes credits for ChatGPT, Claude and DeepSeek. Since this charge is separate, users should include it in the budget only if they plan to use the assistant.
Platforms
DbSchema is a desktop application for Linux, macOS and Windows. The shared installer avoids a registration step, while its local model files and direct connections suit people who want database design work on their own computer.
Who it's for
DbSchema is a strong fit for developers, database administrators and teams that need one desktop tool for visual schema work, SQL queries, change planning and documentation across multiple database engines. The Architect edition is the clearest fit for conceptual planning before an engine is chosen; Pro fits users who need synchronization and documentation without those planning features.
It is less compelling for someone who only needs occasional schema viewing and expects a free tool to include documentation or migration workflows. Community covers connections, reverse engineering and diagrams, but those particular capabilities require a paid edition. Teams that want a browser-based or command-line workflow may also prefer to compare other tools.
Pros and cons
- Broad engine coverage: JDBC support for more than 70 SQL and NoSQL databases, with driver download, reduces the friction of working across different systems.
- Useful offline modeling: Physical schemas can be designed without connectivity and stored locally, supporting planning before a database is ready.
- Changes can be reviewed: Synchronization produces migration SQL for review before application, adding a checkpoint to schema updates.
- Documentation is easy to share: Interactive HTML5 output opens in a browser without requiring readers to install or license DbSchema.
- Free edition has clear gaps: Community excludes documentation, synchronization and data tools, limiting its value for users who need a complete database workflow at no cost.
- Paid costs can stack: Monthly plans carry taxes, perpetual editions need paid maintenance or updates after the included year for continued coverage, and the AI Assistant adds a separate monthly charge.
- AI use changes where data goes: Questions and attached tables or files are sent to the chosen AI provider, which may not suit every data-handling policy.
Alternatives
For other options, browse Database Design Tools and Database Documentation Tools. Choose MySQL when a freemium, Linux, macOS, Windows, API or self-hosted option with a free Community Edition is the better fit. Consider dbForge Studio for PostgreSQL for a freemium tool whose Express plan includes context-aware completion, formatting, query history and visual data editing. Azimutt is another freemium option, with a free plan for schema and data exploration that caps users, databases per project and layouts, and does not keep long-term saves.
dbt Semantic Layer has a free Developer plan with one developer seat, 3,000 successful models per month and one project. For free documentation options, tbls is an MIT-licensed single-binary CLI, while dbdocs offers a free plan with one user, public sharing and password protection. DBX is a free, open-source alternative, and DBDock is a free, self-hosted open-source CLI.
Verdict
Choose DbSchema if you need a cross-platform desktop tool that brings visual modeling, direct database work, reviewable schema changes and shareable documentation together. Its strongest case is the breadth across database engines and the ability to design offline, then carry that model into connected work. Look elsewhere if documentation and synchronization must be free, or if a browser-based or command-line tool better matches how your team works.
The verdict
DbSchema brings schema modeling, querying, synchronization, and documentation into a desktop tool, with a free Community Edition and paid plans. Check which edition includes the capabilities you need, and note that the optional AI Assistant add-on has a separate monthly charge.
Questions people ask
Is DbSchema free?
Community Edition costs nothing and is billed free forever for any use. It includes database connections, reverse engineering, interactive diagrams, table and column creation, and an SQL editor.
What does the Architect trial include?
The shared installer includes a 15-day Architect trial, and the trial can be extended by another 15 days.
How much do subscriptions cost?
The Pro Monthly Subscription costs $29.40 a month plus taxes. Architect Monthly costs $47.04 a month plus taxes. The AI Assistant add-on costs $9 a month plus taxes.
Which operating systems are supported?
DbSchema runs as a desktop application on Linux, macOS, and Windows.
How are database connections secured?
Connections run directly from DbSchema on your computer to the database. Configured SSL and SSH tunnels can be used, and connections do not pass through a DbSchema server.
Can teams use version control?
Yes. Git workflows support repositories hosted on GitHub, GitLab, Bitbucket, or a self-hosted Git server.
What the maker publishes
- Company security
- The company page states that Wise Coders is ISO 27001 certified and describes DbSchema as a Java desktop application built with OpenJDK and JavaFX. source
- Connection security
- Connections run directly from DbSchema on the user's computer to the database, can use configured SSL and SSH tunnels, and do not pass through a DbSchema server. source
- Database support
- DbSchema supports 70+ SQL and NoSQL databases through JDBC and can automatically download the required JDBC driver. source
- Data handling
- DbSchema stores design models in a local .dbs file, saves remembered credentials locally, and sends AI questions and attached tables or files to the selected AI provider when the optional assistant is used. source
- Documentation
- DbSchema can publish interactive HTML5 schema documentation that opens in a browser without an installation or license. source
- Headquarters
- Fürstenfeldbruck, Germany source
- Integrations
- DbSchema's Git workflow supports repositories hosted on GitHub, GitLab, Bitbucket or a self-hosted Git server. source
- Modeling
- Users can design schemas in interactive diagrams, create separate diagrams for subsystems, and generate schemas for supported database engines. source
- Offline design
- DbSchema can generate a physical schema without database connectivity, and its model is saved as a local .dbs file. source
- Platforms
- The download page lists installers for Windows, macOS and Linux, including ARM-64 packages for Windows and Linux. source
- Purpose
- DbSchema is a database design and management tool for visualizing, designing, documenting and interacting with SQL and NoSQL databases. source
- Querying
- The SQL editor provides schema-aware autocomplete, while the visual query builder lets users arrange tables, joins and filters and inspect the SQL before it runs. source
- Schema changes
- Schema synchronization compares a model with a database and can generate migration SQL for review before applying changes. source
- Support
- Technical support is available through the in-app support function, GitHub, email, a support ticket, or a booked call. source
- Trial and download
- The shared installer includes Community, Pro and Architect editions, requires no registration, and offers a 15-day Architect trial that can be extended by 15 days. source
Checked against the maker's pages on 30 Sept 2026.