The Best Database Client & Diagram Designer for macOS

DbSchema for Mac

DbSchema for Mac

  -  248 MB  -  Trial
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.
Pricing

DbSchema Pro offers three licensing options tailored to different user needs:

Developer Perpetual License – A one-time purchase of $294 (plus taxes) grants lifetime access to all database features. The first year of maintenance and upgrades is free, while subsequent years require a $75/year renewal.

Developer Monthly Subscription – Available for $29.4/month (plus taxes), this option provides full access to all databases and includes maintenance and upgrades at no additional cost. However, it is not a perpetual license.

Teams Shared Floating License – Designed for team collaboration, this license costs $730 (plus taxes) as a one-time payment. It includes perpetual access for multiple users, but requires a Floating License Server. The first year of maintenance and upgrades is free, with an annual renewal cost of $175/year from the second year onward.

PROS
  • Intuitive Visual Database Design
  • Supports Multiple Databases
  • Offline Schema Editing
  • Interactive Data Explorer
  • Automated Documentation Generation
CONS
  • Expensive for Full Features
  • Occasional Performance Issues
  • Limited Collaboration Features
  • UI Can Feel Cluttered
Note: 15 days trial version (can be extended to 30 days).

Also Available: Download DbSchema for Windows

Why is this app published on FileHorse? (More info)

What's new in this version:

DbSchema 10.5.0
- This release introduces database tags synchronized with SQL Server extended properties, a redesigned network configuration with named proxy setups and real TLS certificate validation, per-driver JDBC URL parameters, AND/OR filter groups in the Query Builder, a schema change history for Git users, and a calmer licensing experience without startup dialogs.

The Architect edition:
- DbSchema is sold in three editions: Community (free), Pro and Architect. Architect was added in version 10.4.0 and sits above Pro. Its main feature is logical design — model entities and relationships independently of any database, then generate the physical schema for MySQL, PostgreSQL, MongoDB or any other supported engine, with naming and type dictionaries applied on the way. Architect also covers conceptual design, schema validation, and the AI Assistant with a local provider or your own API key. Everything else — physical design, schema synchronization and deployment, browse and query, data tools, documentation, and Git integration — stays in Pro.
- Existing Pro licenses were migrated to Architect at no cost. No key has to be re-generated, and a running subscription keeps its renewal price. Inside DbSchema, the active edition is shown in the toolbar status button and in the About dialog; the Compare Plans tab lists the three plans side by side. New installations start in a 15-day Architect trial.
- TLS certificates are now validated. DbSchema's own HTTP traffic — license activation and renewal, JDBC driver and file downloads, the AI Assistant, bug reports — previously accepted any server certificate. Connections that silently worked behind a TLS-inspecting corporate proxy may now fail with a certificate error. By default DbSchema trusts the Java CA list and the operating system trust store, which covers most corporate proxies; if a connection still fails, add your company CA in Edit → Settings → Network → SSL Certificates → Trust Custom Certificates. Certificates imported into the old trust-store settings are not carried over — re-add them on the new page.
- Proxy settings become named configurations. An existing manual proxy is migrated automatically into a named configuration. There is no separate HTTPS proxy type anymore — one proxy applies to all protocols. No proxy for entries now match precisely: example.com no longer bypasses notexample.com, .example.com covers the domain and its subdomains, and *.example.com matches subdomains only.
- Git users: check your global Git configuration. Older DbSchema versions wrote http.sslVerify = false into the global .gitconfig, which disabled TLS verification for every Git tool on the machine. DbSchema no longer writes this entry, but an existing one stays until you remove it: git config --global --unset http.sslVerify.

New Features:
Database Tags — synchronized with SQL Server:
- Tables, columns, indexes and foreign keys can carry tags — key/value pairs usable in documentation and automation scripts. New in this release, tags can be synchronized with SQL Server extended properties (also on Azure SQL and Synapse):
- In the Tag Manager (Design menu), create a tag with the same name as the extended property and check Sync with DB.
- Reverse engineering then imports the values of matching extended properties as tags.
- Tag differences appear in the synchronization dialog with a dedicated tag icon, and table and column tags are written back to the database as extended properties
- A tag value set in the model is preserved when the database side has none.
- Network Configuration — Proxy & SSL Trust:
- The network settings were redesigned, under Edit → Settings → Network:
- Proxy: reusable named proxy configurations. Auto-detect (system settings, optionally a PAC URL) is the default; Manual supports HTTP and SOCKS5 proxies with authentication and a No proxy for bypass list.
- SSL Certificates: choose exactly what DbSchema trusts — the Java CA list, the operating system trust store, and your own certificate files (PEM/DER); or Trust All Certificates for test environments.
- The AI Assistant now works through a proxy — including SOCKS — which was previously not possible at all.
- Driver and file downloads, license activation and renewal, and bug reports all honor the configured proxy and TLS trust.
- Bug reports (Help → Report a Bug, previously Technical Support) are now submitted through dbschema.com with hardened per-installation credentials, and the dialog stays open if the submission fails, so nothing typed is lost.
- Connection Dialog & JDBC URL Parameters:
- URL parameters are now defined per JDBC driver, not only per database: Db2 (JCC vs. AS/400), MariaDB (own connector vs. MySQL Connector/J), Hive (Apache vs. Cloudera) and SAP (jTDS vs. jConnect) each show the parameters their driver actually understands.
- The parameter catalogs of ~50 databases were reviewed: corrected defaults, better descriptions, and a link that opens the vendor's own documentation for the exact parameter.
- PostgreSQL SSL parameters were reworked: the SSL modes are explained, a Client Certificate group supports mutual TLS, and advanced options cover direct TLS (PostgreSQL 17+), SCRAM channel binding and more.
- Every parameter has an on/off toggle switch — switched off, it is left out of the URL entirely.
- A new Show URL action previews the exact JDBC URL used to connect, with the password masked.
- The dialog is reorganized into Connection, Advanced (SSH tunnel, URL parameters, driver properties, time zone) and Settings (read-only connection, schema mapping, highlight color, Java location) tabs.
- The SSH tunnel form gained a Test Tunnel button that tests the SSH connection on its own, before connecting to the database.

Query Builder — AND/OR Filter Groups:
- Select several filter conditions, right-click, and choose Group in AND / Group in OR. Groups can be nested, flipped between AND and OR, and ungrouped again.
- The generated SQL is correctly parenthesized, for example WHERE active = 1 AND ( age > 60 OR city = 'Rome' ). MongoDB queries use the equivalent nested $and / $or.

Git — Model History & Safer Push:
- Push now checks the remote first: if your branch is behind, DbSchema asks you to pull instead of failing with a cryptic error. Rejected pushes report the actual reason — for example a protected branch — and name the affected branch.
- A new Model History button shows every revision of the design model together with the schema changes each commit introduced — a one-click audit trail. The revision list can be filtered to model file commits only.

SQL Editor:
- Large files open noticeably faster and the editor uses a fraction of the memory it did before; the undo history no longer grows unbounded.
- New Bind Parameters setting (Edit → Settings → SQL Editor): switch it off to send @var literally to databases where it has a native meaning, instead of prompting for a value.
- Groovy code completion was removed from the SQL Editor. Groovy syntax checking and script execution are unchanged, and the installer got about 10 MB smaller.

Licensing — Fewer Interruptions:
- License reminders no longer pop up dialogs at startup. A Renewal tab opens instead — and only at milestones: 14, 7 and 1 day before the free-upgrades period ends, on the day itself, then once per month.
- The Renewal tab has a Refresh License button, and a renewal purchased while DbSchema was closed is picked up automatically instead of showing the license as expired.
- When the automatic 15-day trial ends, a dialog offers Purchase License, Extend Trial 2 Weeks or Use Community Edition
- The toolbar status button shows the actual edition — Architect, Pro, or their floating variants; during a trial, the welcome screen shows the remaining days.
- Registering with an on-premise Floating License Server saves the server address only after a seat was actually granted, and explains the failure otherwise.

Software Updates:
- Help → Software Updates → Settings chooses when DbSchema checks for updates (default: at every start) and can check immediately
- The update window no longer opens behind the main window, and the separate background updater no longer launches on its own schedule
- MSI installer: in-app updates now install through msiexec (enabling silent updates), the package installs per-user, and the redundant elevation prompt is gone

Other Improvements:
- Settings with an on/off state use toggle switches across the application
- The New Diagram tab was redesigned: start a new design on one side, reopen an existing diagram on the other
- View → Theme gained an Edit Custom CSS button — appearance tweaks that survive DbSchema updates
- Sharper toolbar icons and font rendering fixes (occasional wrong glyphs, missing italics)
- Tooltips no longer disappear after a few seconds, with several size and flicker issues fixed
- The toolbar Help menu now includes license registration, hotkeys, software updates and About

Fixed:
- Opening a model file could crash at startup because of a threading issue
- Inspectors no longer change the letter case of an existing table, column or index name just by opening it
- The data type combo in the Column Inspector could revert a filtered selection on Enter
- Dragging a column to create a foreign key works again on zoomed-out diagrams
- Settings load defensively now: one corrupted value no longer resets the settings after it, edited keyword lists are saved reliably, and an imported certificate file no longer overwrites an existing file with the same name
- Connection presets: Impala default port corrected to 21050; Hive, Informix, CouchBase and MarkLogic URL or driver class fixes; the misspelled "Truso" database is now Turso
- Download progress no longer jumps straight to 100% at the start of a download
- A dialog that fails to open reports the error instead of doing nothing; a broken custom naming pattern falls back to the default pattern instead of failing.
- No proxy for entries support port numbers and wildcards anywhere in the entry
- The registration dialog showed a raw message key (renewOutdatedBuild) to customers with an outdated build
- Removed a duplicated "Description" label from the comment section of all object inspectors
- Browse frame border color fixed in light and dark themes

Security:
- TLS certificates are validated on all application HTTP traffic — see the upgrade notes
- Bug report submission no longer embeds a shared credential in the application; tickets are submitted through dbschema.com with per-installation authentication.
- DbSchema no longer writes http.sslVerify=false into the global Git configuration — see the upgrade notes
- Updated the installer/updater framework (install4j 12.0.5) and the Kotlin toolchain (2.4.10)


DbSchema 10.4.1
- Change log not available for this version


DbSchema 10.4.0
PostgreSQL & JSON:
- JSONB reverse engineering is complete. JSON columns are analyzed and expanded into sub-columns in the model.
- JSON reverse engineering works for all users. It no longer requires the beta option.
- Query Builder supports JSONB columns when building queries
- The JSON editor highlights syntax errors as you type
- In Browse, JSON values can be shown in a compact popup view
- A Random JSON Generator helps create sample JSON data for testing
- PostgreSQL connection options are clearer and easier to read
- Physical columns can no longer be assigned virtual-only data types

Database Support:
- YugabyteDB is now supported as a built-in database type
- Snowflake adds a JDBC URL template for Azure AD authentication
- Snowflake sequence reverse engineering works correctly again
- MongoDB field creation no longer fails when adding new fields
- Mimer varchar() columns reverse engineer as character varying as expected
- DynamoDB driver updated to the latest AWS SDK

Connections & JDBC Drivers:
- JDBC drivers are no longer bundled in the installer. They download automatically when you connect or refresh a model
- The Connection Dialog is easier to use. URL selection, manual URLs, and pattern editing are improved
- The Driver Dialog is clearer when managing JDBC drivers
- Passwords are no longer shown in JDBC URLs for SQL Server and SAP HANA
- Old 32-bit driver files are removed automatically to prevent compatibility issues
- Native libraries now use 64-bit versions only
- Connection test errors show more helpful details when a ping fails
- Proxy and update-check messages are clearer

Diagrams & Logical Design:
- Logical design supertables support inheritance modeling. When converting to a physical database, choose single-table, class-table, or concrete-table inheritance
- Diagram rendering is faster, especially when scrolling large layouts
- HTML/SVG diagram export shows improved table header styling and foreign key visuals
- Schema names appear in tooltips when Diagram → Show Schema Name is enabled
- Columns can have a content type attribute for richer metadata
- A new validator checks that referenced columns exist in the model
- Creating a new layout no longer fails in certain cases
- Reverse engineering large tables with a column limit works correctly again

Data Editing & Query Tools:
- Grid Editor is renamed to Bulk Editor to better reflect its purpose
- Bulk Editor cell editing works reliably again
- Query Editor received multiple fixes and stability improvements
- Query filters and result-pane JSON editing work more smoothly
- Auto-completion in combo boxes works correctly again
- In Browse, comment-related display issues are fixed

Schema Import & Synchronization:
- Schema import from file loads into the public schema when none is specified. Foreign keys are imported as well
- The synchronization dialog behaves more predictably
- Foreign key action editing no longer crashes when viewing FK actions

Editors & Model Tools:
- Column Editor allows hierarchical columns to share names with their parent columns
- Constraint Editor loads previously defined options correctly
- Tooltips display correctly in several dialogs
- Paths starting with ~ expand to the home directory as expected
- DDL script splitting recognizes DDL statements more accurately

Welcome Screen, Updates & Appearance:
- The Welcome screen has a refreshed look and clearer navigation
- DbSchema checks for updates at startup and can install them from the welcome screen
- Multiple theme improvements across light, dark, and architect themes
- The Quick Tour and in-app messages are updated
- About → Help shows build information for easier support requests

Licensing & Registration:
- Pro features stay visible in menus. If your license does not include them, a clear Unavailable dialog explains how to upgrade
- License date parsing and subscription checks are fixed
- Registration and activation URL handling work correctly again
- The start-trial button text is clearer
- Sending feedback from the app is improved

Command Line & Scripting:
- DbSchema CLI runs Groovy scripts even when no database connection is active
- Groovy scripts can read and set column length again
- Groovy script exit codes are more consistent after execution

Fixed:
- Fixed null-pointer error when editing foreign key actions
- Fixed Snowflake sequence reverse engineering
- Fixed MongoDB field creation
- Fixed Mimer varchar() reverse engineering
- Fixed Bulk Editor cell editing
- Fixed auto-completion in combo boxes
- Fixed constraint editor not loading saved options
- Fixed registration dialog issues
- Fixed comment display in Browse and related views


DbSchema 10.3.0
PostgreSQL & JSON:
- JSONB reverse engineering is complete. JSON columns are analyzed and expanded into sub-columns in the model.
- JSON reverse engineering works for all users. It no longer requires the beta option.
- Query Builder supports JSONB columns when building queries
- The JSON editor highlights syntax errors as you type
- In Browse, JSON values can be shown in a compact popup view
- A Random JSON Generator helps create sample JSON data for testing
- PostgreSQL connection options are clearer and easier to read
- Physical columns can no longer be assigned virtual-only data types

Database Support:
- YugabyteDB is now supported as a built-in database type
- Snowflake adds a JDBC URL template for Azure AD authentication
- Snowflake sequence reverse engineering works correctly again
- MongoDB field creation no longer fails when adding new fields
- Mimer varchar() columns reverse engineer as character varying as expected
- DynamoDB driver updated to the latest AWS SDK

Connections & JDBC Drivers:
- JDBC drivers are no longer bundled in the installer. They download automatically when you connect or refresh a model.
- The Connection Dialog is easier to use. URL selection, manual URLs, and pattern editing are improved.
- The Driver Dialog is clearer when managing JDBC drivers
- Passwords are no longer shown in JDBC URLs for SQL Server and SAP HANA
- Old 32-bit driver files are removed automatically to prevent compatibility issues
- Native libraries now use 64-bit versions only
- Connection test errors show more helpful details when a ping fails
- Proxy and update-check messages are clearer

Diagrams & Logical Design:
- Logical design supertables support inheritance modeling. When converting to a physical database, choose single-table, class-table, or concrete-table inheritance.
- Diagram rendering is faster, especially when scrolling large layouts
- HTML/SVG diagram export shows improved table header styling and foreign key visuals
- Schema names appear in tooltips when Diagram → Show Schema Name is enabled
- Columns can have a content type attribute for richer metadata
- A new validator checks that referenced columns exist in the model
- Creating a new layout no longer fails in certain cases
- Reverse engineering large tables with a column limit works correctly again

Data Editing & Query Tools:
- Grid Editor is renamed to Bulk Editor to better reflect its purpose
- Bulk Editor cell editing works reliably again
- Query Editor received multiple fixes and stability improvements
- Query filters and result-pane JSON editing work more smoothly
- Auto-completion in combo boxes works correctly again
- In Browse, comment-related display issues are fixed

Schema Import & Synchronization:
- Schema import from file loads into the public schema when none is specified. Foreign keys are imported as well.
- The synchronization dialog behaves more predictably
- Foreign key action editing no longer crashes when viewing FK actions

Editors & Model Tools:
- Column Editor allows hierarchical columns to share names with their parent columns
- Constraint Editor loads previously defined options correctly
- Tooltips display correctly in several dialogs
- Paths starting with ~ expand to the home directory as expected
- DDL script splitting recognizes DDL statements more accurately

Welcome Screen, Updates & Appearance:
- The Welcome screen has a refreshed look and clearer navigation
- DbSchema checks for updates at startup and can install them from the welcome screen
- Multiple theme improvements across light, dark, and architect themes
- The Quick Tour and in-app messages are updated
- About → Help shows build information for easier support requests

Licensing & Registration:
- Pro features stay visible in menus. If your license does not include them, a clear Unavailable dialog explains how to upgrade.
- License date parsing and subscription checks are fixed
- Registration and activation URL handling work correctly again
- The start-trial button text is clearer
- Sending feedback from the app is improved

Command Line & Scripting:
- DbSchema CLI runs Groovy scripts even when no database connection is active
- Groovy scripts can read and set column length again
- Groovy script exit codes are more consistent after execution

Fixed:
- Fixed null-pointer error when editing foreign key actions
- Fixed Snowflake sequence reverse engineering
- Fixed MongoDB field creation
- Fixed Mimer varchar() reverse engineering
- Fixed Bulk Editor cell editing
- Fixed auto-completion in combo boxes
- Fixed constraint editor not loading saved options
- Fixed registration dialog issues
- Fixed comment display in Browse and related views


DbSchema 10.2.1
- Improve Git Dialog. Remove stage buttons - leaven only commit
- Virtual checkbox ticked and disabled when schema is virtual
- Fixes in DDL parser: ALTER TABLE ... ALTER COLUMN ... TYPE + support interval to seconds
- Postgres NULLS WITH DISTINCT
- Improve AI Assistant
- Data Editor: Save cell on focus lost
- Redshift IAM authentication
- Fixes in automation scripts
- Bug fixes: translations


DbSchema 10.2.0
- Improve Git Dialog. Remove stage buttons - leaven only commit.
- Virtual checkbox ticked and disabled when schema is virtual
- Fixes in DDL parser: ALTER TABLE ... ALTER COLUMN ... TYPE + support interval to seconds
- Postgres NULLS WITH DISTINCT
- Improve AI Assistant
- Data Editor: Save cell on focus lost
- Redshift IAM authentication
- Fixes in automation scripts
- Bug fixes: translations


DbSchema 10.1.4
Improved Git Client Dialog:
- The Git dialog has been simplified. It now shows only a list of files to commit, without a staging area. You can perform a diff on each file individually, which provides more flexibility when handling renames. You can also mark a file as a reference and later compare it against another file from a different commit.

Git Dialog:
Improvements in AI Assistant:
- The AI Assistant can now connect via a DbSchema account subscription, or through different providers (Claude, ChatGPT, Gemini, etc.) using your own API key, or a locally installed Ollama

Ai Assistant:
Quick Tour with Animated Samples:
- The Help / Quick Tour is now more interactive, featuring animated samples to guide you through the key features

Quick Tour:
New JDBC Drivers:
- We have released several new JDBC drivers, including support for MongoDB, Cassandra, ScyllaDb, Influx

Other Features:
- Naming Dictionary - convert letterCases to underscore
- Introduce View menu and move Appearance as Theme under View
- Offline Editor save comment on pressing Enter on text area, new lines with Ctrl+Enter. This makes it consistent with browse behaviour.
- Use DBMS specific code to escape comment quotes
- New DbSchema kit for ARM processors (Windows, Linux)

Fixed:
- Column Editor pressing tab until the data type is selected will show an empty data type combo
- On MacOS mouse-over diagram may hide other applications if they are on top
- MacOS Drag title bar
- Offline Editor Add Column button is always active
- Choose .db file in Connection Dialog didn't work on MacOS
- Crash in opening a file with Query Column pointing to missing column
- Editing virtual foreign keys is duplicating the columns
- SqlServer - cannot drop a column if it has a default value. The default constraint should be dropped first.
- Organize user.home/.DbSchema into config/ and data/. Groovy scripts are moved under data/scripts


DbSchema 10.1.3
- Change log not available for this version


DbSchema 10.1.1
- Change log not available for this version


DbSchema 10.1.0
Class Renaming:
We did few renaming in DbSchema API:
- com.wisecoders.dbs to com.wisecoders.dbschema
- Layout to Diagram

call documentation writers as:
- new MarkdownWriter(expose).generate()
- new PdfDocumentationWriter(expose).generate()
- new HTML5Writer(expose).generate()
- Our target it to make DbSchema more fit for AI. In the next release we will let AI write automation scripts for you.
- Menu Reorganization
- The Git dialog is now under tools. The 'New Model' menu item shows a dialog with 3 options.

Customer Area on Website:
- The license management is possible via the dbschema.com Support / Customer Area. There you can associate the licenses directly to end-users ( commercial with quantity > 1 or floating licenses ), using end-users email. The registered users may log-in into account from DbSchema Help / Registration Dialog using their account.

Improved AI Assistant:
- The AI assistant can now use multiple models, via a DbSchema subscription or using own API Key

Diagram Groups:
- Diagram Groups allow organizing diagrams into Groups ( similar with folders ). This is useful for large schemes, with many tables.

Various Bug Fixes:
- Improvements in Logical Design
- MySql GENERATE ALWAYS AS
- Filtering uses wrong column on right-click column header in Data Editor
- Fixes on Dialog Title Bar
- Postgres improve DDL generator procedure. Instead of using information_schema use pg_catalog


DbSchema 10.0.3
- Change log not available for this version


DbSchema 10.0.2
- Change log not available for this version


DbSchema 10.0.1
Ai Assistant:
- Start a conversation from the right-side 'Ai Assistant' window
- Connect to an Ai provider ( OpenAi, Anthropic Claude, Google, DeepSeek ) using your own ApiKey. First, you will have to enter your Api Key, and choose a model.

Write a question and optionally choose to send attach the current diagram structure:
- the table structure for all diagram tables
- the table structure for the selected tables in diagram
- a custom selection

Use Docking Framework:
- Now we use for diagrams and tools ( SQL Editor, Data Explorer, Query Builder ) a docking manager. The docking framework allow moving panes around the window. The frames can be minimized, like the 'Ai Assistant'.

Other Features:
- Naming Dictionary - convert letterCases to underscore
- Introduce View menu and move Appearance as Theme under View
- Offline Editor save comment on pressing Enter on text area, new lines with Ctrl+Enter. This makes it consistent with browse behaviour.
- Use DBMS specific code to escape comment quotes
- New DbSchema kit for ARM processors (Windows, Linux)

Fixed:
- Column Editor pressing tab until the data type is selected will show an empty data type combo
- On MacOS mouse-over diagram may hide other applications if they are on top
- MacOS Drag title bar
- Offline Editor Add Column button is always active
- Choose .db file in Connection Dialog didn't work on MacOS
- Crash in opening a file with Query Column pointing to missing column
- Editing virtual foreign keys is duplicating the columns
- SqlServer - cannot drop a column if it has a default value. The default constraint should be dropped first.
- Organize user.home/.DbSchema into config/ and data/. Groovy scripts are moved under data/scripts


DbSchema 10.0.0
- Change log not available for this version


DbSchema 9.9.4
- Migration: Move from apache.commons.csv to fastcsv. This may affect some Automation Scripts

Feature:
- Add Layout specific background color
- Sync Settings in Model / Settings/ Dbms Specific
- Ignore sequence differences with 'START WITH 1 INCREMENT BY 1'
- Fix SQL Editor editing issues
- Increase SQL Editor Find speed
- Add licensing info in Welcome Dialog
- Browse show gray NULL text on empty cells
- Browse CTRL-C copy selected cells
- Postgres browse insert timestamp convert from String using ::timestamp
- Snowflake load tables from CATALOG.INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.TABLES too
- SqlServer load tables from catalog.sys.schemas and sys.schemas too
- MongoDB add mongodb+srv JDBC patterns

Fixed:
- Issue with Synch Options difference
- Avoid duplicates in HTML5 documentation TOC


DbSchema 9.9.3
- Change log not available for this version


DbSchema 9.9.2
- Change log not available for this version


DbSchema 9.9.1
- Change log not available for this version


DbSchema 9.8.3
- Postgres & MySql reverse engineer JSONB fields and show them in the diagram. The structure is deduced by checking a small number of documents. The query builder can build queries over the fields inside the JSONB document.
- Add native Title bar, which can use the dark theme
- Remove usage of Desktop.getDesktop() in the codebase, which was triggering a message in the Installer 'DbSchema wants to access your Desktop'

Fixed:
- Error on merging Fks when missing in the database model
- Concurrency issues in Paint Manager
- Postgres reverse engineer views
- Fix in Query Builder
- Reverse engineer in Oracle
- SQL Editor editing issues
- Google Big Query parse id columns


DbSchema 9.8.2
- Change log not available for this version


DbSchema 9.8.1
- This release is focused on bug fixes and minor improvements, ensuring a smoother experience for users


DbSchema 9.8.0
- Change log not available for this version


DbSchema 9.7.5
- Fix: SqlServer DDL library for Windows integrated authentication


DbSchema 9.7.4
Feature:
- Continue upgrade from Java to Kotlin
- Dataverse reverse engineer foreign keys and indexes

Fixed:
- Various bug fixes
- MongoDb data loader from file
- MongoDb diagram arrangement
- MongoDb dropping virtual fks when synchronizing the schema with the database
- Using Show FK Action in diagram caused Fks to disappear
- License server running in Docker container, when no font is available


DbSchema 9.7.3
Update JDBC Drivers Dialog:
- The JDBC Driver Upgrades dialog makes it easy to update DbSchema’s JDBC drivers directly from the dbschema.com repository
- You can also roll back to a previous driver version if needed
- The dialog opens automatically whenever new driver versions are released, and you can manually access it at any time via Connection > Manage JDBC Drivers > Check for Updates

Migrate from Java to Kotlin Part I:
- At DbSchema, we invest significant effort in keeping our codebase clean, modern, and aligned with the latest technologies
- Kotlin, one of the most powerful and expressive programming languages today, plays a key role in this process. Its safety, conciseness, and strong support for functional programming allow us to build a more reliable, maintainable, and future-ready application.
- By continuously improving our foundation, we ensure that DbSchema remains fast, stable, and a pleasure to use — today and for the future

New Theme "Moonlight":
- Feature: Postgres reverse engineer GENERATED ALWAYS columns
- Bug: Various bug fixes


DbSchema 9.7.2
- Change log not available for this version


DbSchema 9.7.1
- Change log not available for this version



DbSchema 9.7.0
- New Welcome pane
- Add settings for SSL Key Store to Model / Settings / Connectivity. Enable by default -Djavax.net.ssl.trustStoreType=Windows-ROOT
- Sqlite read date and timestamp values from database as strings. This is fixing an error with date format.
- SyncSettings skip formatting the PRE and POST scripts, in order to avoid errors with ${…} variables.
- Select Local, Remote or Cloud database in the DbSchema welcome panel.
- MongoDb: Improve menu with options for inserting document, create validator or design collection (virtual validator)
- New icon for virtual tables
- Access: add foreign key on delete/update actions
- Exasol: reverse engineer distribution/partition keys
- Improve Quick Tour
- Databricks: add catalog to JDBC URL
- Add search functionality in the layouts and comment tags
- Bug related to table selection during reverse engineer
- Bug : Edit cell in SQL Editor result pane
- Bug: Snowflake NUMERIC(38,0) imported as INTEGER
- Feature: Support for QuestDB
- Feature: Support for Dataverse