DbSchema for Mac

What's new in this version:

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