What is DbSchema?

DbSchema is a visual database designer and management tool that supports any SQL or NoSQL database. Design schemas on interactive ER diagrams, browse and edit data, write queries, generate documentation, and collaborate with your team — all from a single desktop application.

DbSchema application interface

Who is DbSchema For?

  • Database administrators who need to visualise, document, and manage schemas across environments.
  • Developers who want to design and evolve a database schema alongside their application code.
  • Data analysts who need to explore data and build queries without writing SQL by hand.
  • Teams who want to version-control their database schema using Git.

The Design Model

At the core of DbSchema is the design model — a local .dbs file (XML format) that stores your schema structure, diagrams, and saved editors. This means you can work offline, share the file via Git, and open it without a live database connection.

When you connect to a database, DbSchema reads the schema into the model. You can then make changes in the model and synchronize them back to the database at any time. Connecting to a different database does not change the model — it stays as your authoritative source of truth.

Reopen a DbSchema design model from file

Key Feature Areas

Connect to Any Database

DbSchema supports 70+ SQL and NoSQL databases via JDBC. Drivers are downloaded automatically — no manual setup required. Includes SSH tunnelling and proxy support. See Connect to Database.

Visual Schema Design

Create and edit tables, columns, indexes, and foreign keys directly on interactive diagrams. Double-click any table to open the editor. Changes are reflected immediately on the diagram. See Diagrams.

Schema Synchronization

Refresh your model from the database, review differences, and deploy changes across dev, test, and production environments without writing migration scripts by hand. See Synchronize with Database.

Team Collaboration via Git

Save your .dbs model to a Git repository to track schema changes, work in branches, and merge updates as a team. The model file is plain XML — fully diff-friendly. See Git Integration.

Query & Browse Data

Use the SQL Editor, visual Query Builder, or Relational Data Explorer to explore and edit your data without writing complex SQL by hand. See SQL Editor.

Generate Documentation

Export your schema as interactive HTML5 documentation — with diagrams, table comments, and column descriptions included as tooltips. See Schema Documentation.

Where to Start

  1. Install DbSchema and activate your license
  2. Open DbSchema — the Welcome Screen guides you to connect or start a new project
  3. Follow the Quick Tutorial for a hands-on walkthrough of all main features