We stand with Ukraine to help keep people safe. Join us
DbSchema free download for Mac

DbSchema

Version 9.0.0

Universal database tool for interacting with databases.

DbSchema overview

DbSchema is a complete database management tool for the most popular relational databases which helps you discover and get control of databases that have simply evolved over time rather than having been built according to some overall design or "master plan". And there seem to be no shortage of answers as to why this occurs. Sometimes DBA's are just far too busy with loads of other tasks. Sometimes developers are under the gun for deliverables so quickly that there's just not time. Or, this project started just a couple new tables and then ballooned into a monster. Whatever the reason, the situation exists far too often in the real world of information systems.

Let's put this into perspective. Would you build a new house without a foundation? For sure you're not going to do that. The database is the foundation of the software, and a good database design will reflect in the quality of the software.

DbSchema provides the highest performance, scalability, and reliability to meet the requirements of today's database applications. It provides a various powerful tools for viewing, editing and document your schema.

What’s new in version 9.0.0

Updated on Apr 12 2022

  • DbSchema supports logical design. The logical design is database-independent, with entities and sub-entities.
  • Sub-entities can be created by adding a field of type sub-entity to a table.
  • There are also supported different relation types.
  • The logical model can be converted to a physical model and synchronized with the database.
  • We continue to improve the logical design also in the upcoming releases.
  • In the previous versions, we reverse-engineer the schema by reading the metadata from system tables.
  • For most of the databases, we call methods from the JDBC driver, and only for a few of them did we execute direct queries on the system tables.
  • Now, we are using a DDL parser that can reverse engineer the schema from the CREATE TABLE DDL statement.
  • The DDL is generated using commands like ‘Show create table’, or using a dedicated procedure (SqlServer).
  • Besides text, the table, column, and foreign keys can use key/value comment tags.
  • The tags can be used in the automation scripts, and in the logical design for the entity or field’s physical name.
  • This allows us to reverse engineer all parameters, like collation, partition keys, etc., and more table-specific parameters - like temporal tables, etc.
  • This feature is available for all databases where we found a way to generate the table DDL.
  • MySql, MariaDb, Oracle, SqlServer, AzureSQL, Snowflake, Redshift, Vertica, Sqlite, Exasol, SAPHana, GoogleBigQuery, Databricks, Cassandra
  • We do diagrams and schema validation rules for MongoDB. Whenever a validation rule is defined, we reverse engineer the collection structure using it.
  • If not, we deduce the collection structure by introspecting a few documents.
  • Whenever you design a collection, the collection validation rule gets updated.
  • In version 9 we added a text pane in the result pane.
  • We renamed the virtual relation to relationship, and we refactored the menu.
  • We added more parameters for generating the HTML or PDF documentation.
  • Therefore we created a more flexible method in Java. Please have a look on the DbSchema API for details.
  • Feature: Result Pane error message as dialog
  • Feature: InfluxDB integrations
  • Feature: PDF documentation, add parameter for skipping tooltip comments. Improve look.
  • Feature: Add more options to the documentation dialog
  • Feature: Exasol support hashtype data type
  • Feature: Color picker editable hex value
  • Bug: Fixes and improvements in the DDL Parser
  • Bug: MongoDB load statement using the driver class loader. This solves issues with ObjectId.

Information

License

Shareware

Size

194.2 MB

Developer’s website

https://dbschema.com

Downloads

2407

App requirements

  • Intel 64
  • OS X 10.11.0 or later
Try our new feature and write a detailed review about DbSchema. All reviews will be posted soon.
Write your thoughts in our old-fashioned comment
MacUpdate Comment Policy. We strongly recommend leaving comments, however comments with abusive words, bullying, personal attacks of any type will be moderated.
0.0
(0 Reviews of )
There are no reviews yet
c-rafaelo
c-rafaelo
Jul 9 2020
8.2.12
5.0
Jul 9 2020
5.0
Version: 8.2.12
I use it for Snowflake and I can say that is one of the best design tools I have ever tried. I especially like the visual interface and that I can interact with the diagram. It has a great price also!
pruteanu
pruteanu
May 6 2020
8.2.10
0.0
May 6 2020
0.0
Version: 8.2.10
The mac damange issues are fixed, they required some Apple software notarization which are now in place. New features, databases and tools are now also available.
Chap-Harrison
Chap-Harrison
Sep 15 2012
6.1
0.0
Sep 15 2012
0.0
Version: 6.1
I downloaded the .DMG file, mounted it, dragged the Installer app to the Desktop, and launched it from there. Error message that the file is damaged. Tried the whole process twice.
Mitzanu
Mitzanu
Jul 1 2011
5.7
5.0
Jul 1 2011
5.0
Version: 5.7
Easy to use and one of the best tools out there.
$196.00
PaidOne-Time Purchase
Buy Now
How would you rate DbSchema?
Similar apps
DbVisualizer
Cross-platform database visualization and management tool.
Is this app is similar to DbVisualizer? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
Aqua Data Studio
Single interface for common relational databases.
Is this app is similar to Aqua Data Studio? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
RazorSQL
Manage multiple databases from a single application.
Is this app is similar to RazorSQL? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
DBeaver
Open Source universal database manager.
Is this app is similar to DBeaver? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
Universal Database
Keep records of any object type.
Is this app is similar to Universal Database? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes