DbSchema: Design, Document & Deploy Databases

DbSchema helps to design and document databases, share the design model in a team, deploy the schema on multiple databases. Integrated tools like data explorer, visual query editor, data generator, and database reports make DbSchema an everyday tool for everybody who interacts with databases.

DbSchema supports all relational and No-SQL databases, including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google, and more.

Download DbSchema Editions
DbSchema Database Designer

Visual Design and HTML5 Documentation

Using DbSchema you will interact with the database visually. There is no need to be an SQL expert to create new tables, columns, or foreign keys or to explore the data from multiple tables. Also, many other operations like writing queries, generating test data, or importing data into the database are done visually.

When talking about the database design, a crucial factor in the documentation. Using DbSchema you can organize the tables in multiple layouts and add comments to them. Then you can generate HTML5 or PDF documentation, with the interactive diagram image, where the comments can be read as mouse-over tooltips. As an example, in the image below you can hover tables and columns and read the comments.

Read More

Database Schema Documentation

Share the Schema Design in a Team & Schema Deployment

Using DbSchema you can design a model from scratch (with or without a database), from an existing database by reverse-engineering the schema or generate a model from an SQL file. The DbSchema model is independent of the database and will be saved to file, in XML format. This allows to:

  • Share the model file in a team using GIT
    The XML model file (.dbs) can be stored and shared using GIT. You can compare two model files using DbSchema or as text editors.
  • Compare two versions of the schema from two model files
    Comparing them you can see the differences and generate SQL scripts with the statements to migrate between the two versions.
  • Deploy the model on multiple databases
    Connecting to a different database won't change the DbSchema model. You will see the differences between the model and the database and apply the differences in the database.
  • Migrate from one version of the schema to another and generate SQL scripts
    Comparing two model files or the model file with a database you can generate the schema migration scripts.
  • Open the model without database connectivity
    You can open and edit the model, add new tables, columns, comments, etc. and deploy them later on any database.

DbSchema Model File

Video Presentation

Video

Key Features

About DbSchema Free and Pro

DbSchema has a Free and Pro edition. After downloading DbSchema, you can use the Pro features for two weeks for free, and continue with the Free edition. Many features like diagrams or SQL Editor are available in the free edition. If you decide, you can purchase a Pro license. The DbSchema Pro licenses are perpetual, so you can use DbSchema forever.

All Features Included

DbSchema Pro includes all features, like schema documentation, schema synchronization, data explorer, and more.

All Databases Included

With a license you can design all SQL, NoSQL, and Cloud databases

Money-Back Guarantee

Not happy with DbSchema? 30 days after your purchase you can claim your money back.

Technical Support

All users can benefit from full technical support.

What Customers Says