Beta Updates

DbSchema Release Notes

DbSchema 10.4.0

Release date: 16.07.2026 — changes since version 10.3.0 (26.06.2026).

This release introduces Architect, a new license edition, starts new installations in an automatic 15-day trial, and adds a major upgrade to the database management plugins. The Architect edition is for the logical and conceptual design.

Old Pro licenses are migrated automatically to Architect. The old subscription are also keeping their old renewal price.

---

Upgrade notes — please read

Three changes in this release alter existing behaviour. Please review them before updating.

• On-premise Floating License Server must be updated first. DbSchema 10.4.1 requires the licensed edition from the license server. Connecting to an older on-premise Floating License Server now fails with: "This DbSchema version requires a newer version of the Floating License Server. Please install the latest version of the License Server and try again." Pull the latest dbschema/dbschema-license-server Docker image before rolling out 10.4.1 to your users.
• Own-key AI now requires an Architect license. Using your own AI provider key (OpenAI, Anthropic, Gemini, Ollama, and all other providers) now requires the Architect edition. The DbSchema AI subscription remains available to everyone, including Community users, and a trial subscription can be requested from inside the application.
• Logical / conceptual design now requires an Architect license. The menu entries remain visible; using them with a non-Architect license opens an upgrade dialog and the project is not opened.

Existing paying customers are not affected: your current license key is automatically recognised as Architect, keeping every feature at your current price, with no new key to install.

---

New Features

Architect — a new license edition

• New Architect edition sits above Pro. It unlocks logical / conceptual database design and own-key AI. Everything else — physical design, schema synchronisation and deployment, browse and query, data tools, documentation, and Git integration — remains available in Pro.
• Existing licenses are grandfathered to Architect for free, at the current price, with no key re-generation: license keys without an edition field are recognised as Architect.
• The active edition is now displayed in the About dialog and the license information — for example "Licensed, Architect edition" or "Trial, Architect edition (expires at … UTC)".
• Pro license holders get an "Upgrade to Architect" action in the Help menu, in the About dialog, and in the upgrade dialog. Each opens the upgrade page for the running license.
• Trial licenses and floating licenses are Architect.
• The floating license server (both the DbSchema account service and the on-premise server) now returns the licensed edition, so a floating seat is gated by the edition it actually leased.

New installations start in an automatic 15-day trial

• A fresh installation now starts directly in a 15-day Architect trial with access to all features — nothing needs to be activated or registered. When the trial expires, DbSchema moves to the Community edition.

New "Compare Plans" tab

• A new Compare Plans tab replaces the old Trial tab. It shows three side-by-side plans — Community, Pro and Architect — each with its feature list.
• A banner shows the current plan and, during the trial, the remaining days ("Architect Trial — N days left").
• The tab adapts to the current license state and is never shown to licensed or floating-license users.

Database management plugins

The management dashboard plugins (available for ~30 database engines) received a substantial upgrade:

• Running Queries: automatic refresh with a selectable interval and countdown, Cancel query and Terminate session actions with a confirmation dialog showing the exact SQL, a "blocked by" badge, and a details panel with the full query, Copy, and "open in SQL editor".
• Database Locks: a blocking-chain tree showing which session blocks which, with "blocking N" / "waiting" badges and a Terminate blocker action.
• Space Usage: a treemap of schema › table › data / indexes, and a growth chart with forecast whose history is now kept across restarts.
• Slow plugin queries no longer freeze the application — plugin queries now run asynchronously, with timeouts and cancellation.
• Plugin settings (refresh interval, growth history) are stored per database and connection, and survive restarts.
• For plugin authors: multi-file plugins via <script src> / <link>, a shared plugin-lib.js / plugin-lib.css (dialogs, toasts, drawers, auto-refresh, formatters), bundled ECharts, app.openSqlEditor(sql) and app.copyToClipboard(), and plugin console output routed to the application log.

Import / Export connections

• The Connection Manager dialog gained Import and Export buttons. Connections are exported to a standard connections.xml file, either all of them or only those of the current database. Passwords are never exported.
• Importing merges into the existing connections: identical connections are skipped, name conflicts are imported under a new name, and a notification reports how many were imported, renamed and skipped.

Connection troubleshooting — corporate SSL proxies

• Connection failure advices now explain corporate SSL-inspecting proxies (Zscaler, Netskope and similar), which re-sign the database certificate with a company CA that Java does not trust — a frequent cause of PKIX path building failed / "unable to find valid certification path" errors. The advice suggests enabling Edit → Settings → Trust Store → Use Windows Trust Store, importing the CA with keytool, or using driver-specific URL parameters.
• A new advice covers certificate hostname mismatch ("No subject alternative names matching", "Hostname X not verified"), including the SSH-tunnel and proxy-rewrite cases.
• Database-specific guidance was added for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Db2, MongoDB, Snowflake, Redshift, Cassandra, ScyllaDB, Databricks, Elasticsearch, InfluxDB, Salesforce, SAP HANA, DynamoDB and Exasol, and is inherited by derived databases (Aurora, Neon, Supabase, TiDB, SingleStore, Synapse, Fabric, Azure SQL, CosmosDB and others).

Other

• DuckDB: user-defined data types (CREATE TYPE) are now supported.
• The Spreadsheet editor now opens as a tab instead of a dialog.
• The Quick Tour opening page was rewritten as an overview of Interactive Diagrams, Design Model, Team Collaboration, Data & Query Tools and the Data Generator.
• The About dialog is now resizable.
• Switching to offline mode without a license now shows an actionable dialog with Purchase License and Skip buttons, explaining what a license adds.
• In the Sync Refresh dialog, Review Differences is now the default action.
• Improvements in translations
• Improvements in AI editor

---

Bugfixes

• Browse — the Filter acted on the previously selected column instead of the one under the cursor when right-clicking. This was most visible on Linux, where the context menu opens before the selection updates. Right-clicking a column header now resolves the correct column as well.
• MariaDB downloaded the MySQL JDBC driver instead of its own.
• Db2 Express could not load the schema list (SQLCODE=-2439) on instances whose catalog routines are out of sync with the installed Db2 level. Schemas are now read directly from SYSCAT.SCHEMATA.
• Google Cloud Spanner connections failed because of an outdated transitive Guava dependency.
• PostgreSQL — numeric and decimal were swapped. numeric is now the primary type name, so generated DDL and reverse-engineered columns match what PostgreSQL itself reports.
• MongoDB — generating the collection validator failed when column type options or enumerations were written MongoDB-style with single quotes or unquoted field names. Invalid values now produce an error naming the column and showing the expected format.
• Printing large diagrams on very large paper sizes (for example Arch-E) failed with an out-of-memory error.
• The automatic updater did not close DbSchema before replacing application files. DbSchema is now closed cleanly — saving work and closing database connections — before the update proceeds.
• Fixed a crash ("Cannot coerce value to an empty range") when showing a tooltip near a screen edge.
• The New Design Model dialog opened behind the Connection Inspector window.
• SQL Editor — the ... browse button stayed disabled after ticking the Open File checkbox.
• SQL Editor — Automation Script files are now recognised by extension; HTML, CSS, YAML and text files are shown as plain text instead of being highlighted as SQL, which could hang the editor. Groovy files are no longer highlighted with the JSON lexer.
• HTML documentation — links are no longer underlined, except on hover.
• Shortened over-long tooltips in the Column, Constraint, Foreign Key, Index, Schema, Sequence, Table and View inspectors.
• Entering a wrong AI trial validation code left no way to re-enter it. The dialog now re-prompts with the previous code, reusing the same request so the emailed code stays valid.
• Fixed a flickering AI editor toolbar on macOS when resizing the panel.
• The AI provider dropdown displayed "null Key" in empty rows.
• Two plugin editors reloading at the same time could clash; the plugin loading spinner did not animate.
• Ollama fixes (via the updated AI library).

---

Security

• Updated Apache HttpClient (5.6 → 5.6.2) and Jackson (2.21.2 → 2.22.0) to versions that include security fixes.
• Updated the installer/updater framework (install4j 12.0.5) and the build toolchain (Gradle 9.6.1).

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