Database Design Tool
for ER Diagrams, SQL and Documentation

DbSchema is a visual database designer for over 100 SQL and NoSQL databases. Draw the schema as an interactive ER diagram, reverse engineer a database you already run, write SQL against it, and turn the design into a migration script.

Runs on Windows, macOS and Linux. The free Community edition has no table limit and no expiry, and the same installer carries a 15-day Pro trial.

Free Download View Pricing

DbSchema database design tool showing an ER diagram

What DbSchema Does
From First Connection to Deployed Schema

Reverse Engineer an Existing Database

Point DbSchema at a cloud, remote or on-premise database, and it reads the catalog and draws the tables, columns and foreign keys as an interactive diagram. Inherited schemas become readable before you write a query against them.

Design the Schema Visually

Create tables, columns, indexes and relationships on the diagram, and DbSchema writes the DDL. Large models stay readable because one schema can carry several diagrams, each holding the tables one piece of work needs.

SQL Editor with Autocompletion

Write SQL against the connected database with autocompletion drawn from the live schema, and edit the results directly in the Result Pane. Available in the free Community edition.

Schema Synchronization

Compare the model against a live database and generate the migration SQL from the difference. A column added on the diagram becomes a reviewed script instead of a hand-written changeset.

Schema Documentation

Publish the schema as interactive HTML5 documentation that a colleague can open without installing anything, or export it to PDF and Markdown for a repository.

Visual Query Builder

Build a query by picking tables and following the foreign keys, and DbSchema writes the joins. Useful where the schema is unfamiliar and the join path is the hard part.

Relational Data Explorer

Open a row and walk outward along its foreign keys to the related records, so you read the data in the shape the schema describes rather than one table at a time.

Logical Design

Model entities with no engine chosen yet, then generate the physical schema for the database you target. Included in the Architect edition.

Random Data Generator

Fill a new schema with realistic test data that respects the foreign keys, so a design can be exercised before any real data exists.

DbSchema Community: A Free Database Design Tool
& Where Pro Starts

Most free design tools cap the number of tables or expire. The DbSchema Community edition does neither: it covers every supported engine, reverse-engineers a live schema, and runs SQL, at no cost and with no deadline. The table below draws the line so you know which side each capability sits on before you install anything.

DbSchema edition comparison, as listed on the pricing page.
Capability	Community	Pro	Architect
All supported databases	Yes	Yes	Yes
Connect and reverse engineer	Yes	Yes	Yes
Interactive ER diagrams	Yes	Yes	Yes
Create tables and columns	Yes	Yes	Yes
SQL editor	Yes	Yes	Yes
HTML5, PDF and Markdown documentation	No	Yes	Yes
Visual query builder	No	Yes	Yes
Design offline and save to file	No	Yes	Yes
Schema synchronization	No	Yes	Yes
Relational data browse	No	Yes	Yes
Data generator and data importer	No	Yes	Yes
Logical and conceptual design	No	No	Yes

The Pro features run for 15 days on the same installation, so the boundary costs nothing to try. Read the longer answer in what a free database design tool can actually do.

Download Free Compare Editions

Design the Schema in a Team
& Deploy It Anywhere

DbSchema Pro keeps the design in a single model file rather than in the server, so the schema travels the way the application code does: through a branch, a review and a merge.

Design Offline

Work on the model with no database connection open, on a laptop or a plane, and deploy it once you are back.

Git Integration

The model is one .dbs file, so it commits beside the code and a schema change gets reviewed in the pull request.

Migration Scripts

Generate the SQL that moves a database from its current state to the model, and read it before anything runs.

Deploy the same model on several engines

Deploy on Any Engine

One model deploys against development, staging and production, and across the engines a mixed estate runs.

Database schema synchronization between the model and the live database

DbSchema's Git Documentation

One DbSchema Model
for Every Database You Run

DbSchema speaks to over 100 SQL and NoSQL engines through their JDBC drivers, which it downloads for you on the first connection. A team running PostgreSQL in one service and MongoDB in another designs both in the same tool.

See all supported databases JDBC drivers

Dedicated Solutions for Every Role

Who benefits from designing a schema in DbSchema?

Database Architects

Model the physical and logical schema, keep large designs readable across several diagrams, and generate the documentation that keeps a design aligned with the team that builds against it.

Structure the Design

Software Developers

Read an unfamiliar schema as a diagram, build the joins visually, and commit schema changes through Git so a review catches them before deployment does.

Design the Schema

Database Administrators

Compare environments, generate the migration script from the difference, and read it before it runs. Routine schema work stops depending on hand-written DDL.

Deploy with Confidence

Data Analysts

Connect, explore and query without memorizing the schema. The visual data explorer follows foreign keys, so related records are one click apart rather than one join away.

Explore & Visualize the Data

Students

Learn schema design against a real engine with the free Community edition, which has no table limit and no expiry. Universities and students also get the lowest price on Pro.

Learn Database Design

Managers

Understand an application by reading the shape of the data behind it. A generated diagram says what a system stores without anyone opening the code.

Understand the System

Frequently Asked Questions

A database design tool lets you model tables, columns, keys and relationships visually instead of writing DDL by hand. DbSchema also works in the other direction: it connects to a database you already run, reads the catalog, and draws the existing schema as an interactive ER diagram.

The Community edition is free for any use, with no table limit and no expiry. It connects to every database DbSchema supports, reverse-engineers the schema into interactive diagrams, creates tables and columns, and runs SQL in the editor. Saving the model to a file, documentation export, schema synchronization and the data tools start at Pro, which runs for 15 days from the same installer.

Over 100 SQL and NoSQL databases, including PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, MongoDB, Cassandra, Snowflake, DB2 and SAP HANA. One model can be deployed against any of them, so a team running several engines uses a single tool.

Yes, with DbSchema Pro. The model lives in a .dbs file rather than in the server, so you can design on a laptop with no connection and deploy later. The Community edition requires a live connection to work against.

DbSchema Pro compares the model against a live database and writes the migration SQL from the difference, so a column added on the diagram becomes a reviewed script rather than a hand-written changeset.

Yes. The same installer covers Windows, macOS and Linux, and the same model file opens on all three.

The DbSchema Pro model is a single .dbs file, so it commits to Git alongside the application code and follows the usual branch and review workflow. Schema changes are reviewed as part of a pull request rather than announced after the fact.

A diagram editor draws a picture that has no connection to the database. DbSchema reads the schema out of the live catalog and writes changes back to it, so the diagram stays an accurate view of the database rather than a drawing that ages.

Guides on database design

Download DbSchema for Free!

The universal installer supports both Community and Pro Editions.

Free Download

Cookie preferences

Database Design Toolfor ER Diagrams, SQL and Documentation

What DbSchema DoesFrom First Connection to Deployed Schema

Reverse Engineer an Existing Database

Design the Schema Visually

SQL Editor with Autocompletion

Schema Synchronization

Schema Documentation

Visual Query Builder

Relational Data Explorer

Logical Design

Random Data Generator

DbSchema Community: A Free Database Design Tool& Where Pro Starts

Design the Schema in a Team& Deploy It Anywhere

Design Offline

Git Integration

Migration Scripts

Deploy on Any Engine

One DbSchema Modelfor Every Database You Run

Video TutorialsLearn by Watching

Dedicated Solutions for Every Role

Database Architects

Software Developers

Database Administrators

Data Analysts

Students

Managers

Frequently Asked Questions

What is a database design tool?

Is DbSchema free?

Which databases does DbSchema support?

Can I design a database schema without connecting to a database?

Can DbSchema generate the SQL migration script?

Does DbSchema run on macOS and Linux?

Can a team share a database design?

How is DbSchema different from a diagram editor?