DbSchema for Mac

October, 11th 2024 - 381 MB - Trial

Latest Version

DbSchema 9.6.3 LATEST
Review by

Daniel Leblanc
Operating System

Mac OS X 10.11 or later
User Rating

Click to vote
Author / Product

Wise Coders Solutions / External Link
Filename

DbSchema_macos_9_6_3.dmg

DbSchema for Mac is a diagram-oriented database macOS software compatible with all relational and many No-SQL databases, like MySql, Cassandra, PostgreSQL, MongoDB schema visualization, Redshift, SqlServer, Azure, Oracle, Teradata and more.

Using Db Schema for macOS you can design the schema with or without database, save the design as project file, deploy schema on multiple databases and share the design in a team. Build-in tools allows to visually explore the database data, build and execute queries, generate random data, build forms applications or reports and more. It can be evaluated 15 days for free, no registration required. It can work on all operating systems.

Db Schema for Mac is build for large schemas and complex databases. Build meaningful relations between tables and document the schema. Discover DbSchema layouts, virtual foreign keys, Relational Data Browse, interactive PDF documentation and many other features.

Features and Highlights

Import database schemas

Load JDBC driver
Connect to any JDBC compatible database. Several DBMS have already been tested, but more will be added later.
Currently tested DBMS include: Oracle, MySQL, PostgreSQL, DB2 for Windows/Linux, Cache, DaffodilDB, FrontBase, HSQLDB, Informix, JavaDB/Derby, Microsoft SQL Server, Mimer, Pervasive, PointBase, Sybase SQL Anywhere, Sybase ASE.
Schema import includes: tables, views, foreign keys, procedures, triggers, sequences and comments.

Edit database schema

It uses an abstraction level between internal database schema representation and any particular database.
Edit tables, columns, indexes, foreign keys, procedures, triggers, sequences and comments.
Edit your schemas Graphically using Layouts, including: tables, views, foreign keys, etc...
Create and use multiple Layouts inside a project.
Drag, pan and zoom Layouts using simple mouse movements.
Supports Drag&Drop from project tree to graphical Layout.
Highlight Foreign Keys for a given table, which trigger on delete events.
Generate SQL statements directly from schema graphical Layout.
Generate schema scripts to any particular database.
Change schema data types from one database to another.
Edit schema offline support.

Browse database data

Browse data from multiple tables simultaneously.
Set filters over browse data.
Order browse data on one or more columns.
Unlimited browse depth.
Paginates browse data.
Single or multiple record views.
Insert, update, and delete records.
View Large Objects (LOBs) fields as image, Html, text or using an external application.
Saves browse sessions in project file, which can later be browsed again.

Edit and execute SQL

Edit SQL statements.
Syntax highlight covering database keywords, functions, table and view names.
Auto-completion of table, view and column names.
Quick Click&Show tables or columns in SQL pane and show them in Layout.
Execute SQL statements individually or as scripts.
Paginate and order SQL results, after query execution.
Keep multiple SQL result panes, and refresh query results.
Explain the SQL execution plan.
Saves SQL scripts working sessions in the project file, which can later be continued.

Schema Synchronization

Synchronize project schema with another project or database.
List schema differences.
Select which differences to keep, either on a local or remote schema.
Generate Merge SQL scripts based on schema differences.
Upload differences on to database, with automatic step by step execution.
Synchronize schemas offline, which empowers teamwork.

Scripts and documentation

Generates SQL schema creation scripts for any database.
Document tables, columns, foreign keys, indexes, etc... by adding Comments
Generates schema specification as an HTML document.
Print schema Layouts with precise control on actual print size, using the Zoom print feature.
Generates schema Layout image files, in a few formats (PNG [raster] or SVG [vectorial])
Provides a Database Template System, which allows to create, edit and maintain database templates
Several Database Templates are already supplied, but new ones can be learned as well, by connecting to the target database.

Note: 15 days trial version (can be extended to 30 days).

Also Available: Download DbSchema for Windows

Download DbSchema for Mac Latest Version

What's new in this version:

We are adding database-specific management applications under the Tools menu, for:
- Disk usage
- Active Sessions and Locking
- Long Transactions
- User and Roles Management
- The management applications are open-source and can be found in the Tools / Automation Scripts / Applications Dialog
- Add docker image Makefile and Dockerfile to create a DbSchema docker image in the Manage / Java Plugins / Docker
- For those who are willing to run DbSchema in a Docker container, we included the required files under the Tools / Automation Scripts

Add Synchronization Priority:
- Open the Schema / Synchronization Settings Dialog and set a custom priority for each table, view, procedure, function or trigger
- In the dialog you can see the default priority. Setting a custom priority will influence the order of the created objects.
- For example, you may need a custom procedure to be created first, or immediately after a table

More Features and Bug Fixes:
- Feature: Press Arrow keys scroll diagram
- Feature: MongoDB do not show sub-collections if the number exceeds a configurable limit of 30 per node
- Feature: Upgrade GoogleBigQuery JDBC driver
- Feature: Add a Model Validator as Java Groovy
- Feature: Project Structure, show the tables under layout node with the schema name.
- Feature: Support for Greenplum database
- Bug: Improve MongoDB diagram arranger speed
- Bug: Fix issue in Naming Dictionary
- Bug: Infinite recursive call in Synchronization Dialog
- Bug: Issue in SqlServer rename table and columns
- Bug: Improvements in the Floating License Server