DbSchema 10.3.0 Release Notes

Beta Updates

DbSchema Release Notes

Version 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.

Bug Fixes

• 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.

Version 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,

Version 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.

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.

Quick Tour with Animated Samples

The Help / Quick Tour is now more interactive, featuring animated samples to guide you through the key features.

New JDBC Drivers

We have released several new JDBC drivers, including support for MongoDB, Cassandra, ScyllaDb, Influx.

Version 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.0

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

Press the 'Send' button on the bottom-right:

If the Ai answer contains a code block with 'CREATE TABLE' statement, you can choose to merge this into the actual design model. The schema changes won't be applied into the database.

Apply them into the database with one more synchronization, between the design model and the database.

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)

Bug Fixes

• 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