DbSchema 10.0.0 Release Notes - Ai Assistant

Release notes • 10-Dec-2025
by DbSchema Team

Beta Updates

DbSchema 10.0.0

Ai Assistant

Ai Assistant

Start a conversation from the right-side 'Ai Assistant' window.

Ai Assistant Chat

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.

Ai Assistant Settings

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

Ai Attacht Table Structure

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

Ai Chat Question

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.

Ai Synchronization Dialog

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

DbSchema Docking Framework

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

DbSchema Database Design Tool

ER Diagrams & Visual Tools
Desktop app for
DbSchema ER Diagram Features Overview
Visual Design & Modeling
Visual Design & Schema Diagram

✓ Create and manage your database schema visually through a user-friendly graphical interface.

✓ Easily arrange tables, columns, and foreign keys to simplify complex database structures, ensuring clarity and accessibility.

GIT & Collaboration
Version Control & Collaboration

✓ Manage schema changes through version control with built-in Git integration, ensuring every update is tracked and backed up.

✓ Collaborate efficiently with your team to maintain data integrity and streamline your workflow for accurate, consistent results.

Data Explorer & Query Builder
Relational Data & Query Builder

✓ Seamlessly navigate and visually explore your database, inspecting tables and their relationships.

✓ Build complex SQL queries using an intuitive drag-and-drop interface, providing instant results for quick, actionable insights.

Interactive Documentation & Reporting
HTML5 Documentation & Reporting

✓ Generate HTML5 documentation that provides an interactive view of your database schema.

✓ Include comments for columns, use tags for better organization, and create visually reports.