DbSchema: Design, Document & Deploy Databases

DbSchema is a universal database designer, for out-of-the-box schema management, share the schema in a team and deploy it on multiple databases. Further visual data and query tools make it a daily tool for developers, database administrators, and decision-makers.

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

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.

HTML5 Documentation

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

DbSchema Model holds its own image of the schema, independent from the database. The model is saved to file as XML. The model facilitates:

  • 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