DbSchema 10.1.0 Release Notes

Beta Updates

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