Changelog

What's new in DearSQL.

v0.7.7

2026-11-14
  • - Windows: DearSQL installs with a setup program instead of an MSI. Updates now install in the background while you work and take effect when DearSQL restarts, with Restart Now or Later. Updating from 0.7.6 runs the setup once, keeping your install folder, shortcuts and settings.
  • - Typing with an input method (Chinese, Japanese, Korean, Vietnamese) composes right in the field on macOS, Windows and Linux, with the usual underline and candidate window.
  • - Colour emoji show in results, editors and the chat, and Korean text shows on every desktop. On macOS, Ctrl-Cmd-Space opens the emoji picker.
  • - A refreshed theme: primary buttons in the accent colour, rounded menus and popups, and light-theme popups on white with a border.
  • - SQL editor: Left and Right collapse a selection, typing after an undo clears redo, and the comment shortcut uses # in Redis.
  • - Windows: on a machine without a usable GPU DearSQL draws in software instead of failing to start, and a minimized window draws nothing.

v0.7.6

2026-11-11
  • - SSH tunnels run inside DearSQL instead of through the ssh program, so they work the same everywhere: password and passphrase-protected keys now work on Windows too, and many connections share one SSH session. ~/.ssh/config aliases and known_hosts still apply; jump hosts (ProxyJump) and ssh-agent are not supported.
  • - The title bar is drawn in the app's theme on macOS, Windows and Linux: the sidebar toggle, new connection, workspace picker and settings sit in one row beside the window buttons, and a double-click on the empty bar zooms the window (on macOS, or minimizes it, following your Dock settings).
  • - Alerts, prompts and the license dialog look the same on every platform, in the app's theme.
  • - An idle window no longer redraws frames that haven't changed, so DearSQL uses less CPU and battery while you read results (macOS and Windows).
  • - A new app icon: the orb on its own, without the dark square around it.
  • - `dearsql --mcp` sees connections saved after it started (with `dearsql connect` or in the app), so an agent can use them without restarting.

v0.7.5

2026-11-09
  • - Grok (xAI's Grok Build) joins the coding agents in the chat.
  • - `dearsql upgrade` installs the latest release from the terminal, over the copy you run it from.
  • - Claude Code, Gemini CLI and Codex now run on Bun (yours, or one DearSQL sets up the first time), so an older Node from a version manager no longer makes them quit right after starting. When an agent does quit, the chat shows its last output.
  • - Agent sign-in: Codex moves to the maintained codex-acp package (the old one picked a model ChatGPT accounts can't use), and Claude Code's Log in with Claude opens a Terminal running claude /login, with Continue in the chat.
  • - Gemini's Log in with Google opens your browser even when DearSQL was started from an SSH session.
  • - The model you pick for an agent is remembered for its next chats, so Codex no longer starts on a model from its own config that your account can't use.

v0.7.4

2026-11-08
  • - Compare Schema With: pick two databases of the same kind (dev and production, or two schemas) and get a script that would make the first match the second. Nothing runs until you click Run.
  • - Review Indexes: a database's unindexed foreign keys and redundant indexes, with the statements to fix them, opened as a script.
  • - Profile: a table's nulls, distinct values, min and max and most common values per column, in the inspector's new Profile tab or as a query from the table's menu (Profile Columns).
  • - ScyllaDB connections, on the Cassandra backend: keyspaces, tables, CQL editor and completion.
  • - Cassandra and ScyllaDB: TLS + Verify Host checks each node's certificate, TLS + Verify CA refuses to connect without a CA file instead of skipping the check, and table DDL comes from the server's own DESCRIBE.
  • - Coding agents: profile_table and diff_schema, over MCP and as dearsql commands.
  • - Query plans: Explain in the SQL editor shows the plan as a tree on PostgreSQL, MySQL and SQLite, and flags likely problems: full scans a filter mostly throws away, tables scanned once per join row, big or spilled sorts. Analyze adds real row counts and per-step timings, with slow steps and bad estimates highlighted.
  • - Charts: query results and tables can be drawn as bar, line, area, scatter or pie charts, with grouping by the X column.
  • - JSON view: results and tables switch between the grid and the rows as JSON.
  • - Delete preview: saving deletes shows the rows foreign keys reach in other tables, deleted by a cascade, set to NULL, or blocking the delete.
  • - Open Quickly: press ⌘P (Ctrl+P) to jump to any loaded table or view by name.
  • - SQL editor: query parameters. Write :name in a query and DearSQL asks for the values before running.
  • - SQL editor: a play icon next to each statement runs just that statement; hovering it outlines what will run.
  • - S3 browser: a Type column, multi-select (click, Shift, Cmd, or drag across rows), and Copy, Cut, Paste and Delete on the selection, also across buckets of a connection.
  • - Coding agents: new tools explain_query (the plan with its warnings), review_indexes (foreign keys with no index, indexes another one covers) and explain_finding, two MCP prompts (diagnose-slow-query, review-schema), and S3 tools (list_objects, read_object, copy, delete, upload, download), in the assistant chat, over MCP and as dearsql commands.
  • - Claude Code plugin: `/plugin install dearsql --marketplace dunkbing/dearsql` registers the tools and a skill that teaches the workflow; Codex can use the same skill.
  • - SQLite: foreign keys are enforced by default, so ON DELETE CASCADE and blocked deletes work as declared (SQLite itself leaves them off).
  • - SQL editor: syntax checking uses the database's own parser on PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, DuckDB, CockroachDB and TiDB, so valid queries such as ::casts, RETURNING and ON CONFLICT are no longer flagged. Other engines are no longer checked.
  • - SQL editor: syntax errors are underlined where the database stopped reading, with the message on hover.
  • - SQL editor: Opt+Backspace deletes a word and Cmd+Backspace the rest of the line (Ctrl+Backspace and Ctrl+Shift+Backspace on Linux and Windows).
  • - SQL editor: typing in long scripts is faster, and an idle editor no longer re-highlights its whole text every frame.
  • - SQL editor: selected text is easier to see, and errors such as a write on a read-only connection show in the results again.
  • - Sidebar: schemas with around 1,000 tables and views open in a quarter of a second and scroll smoothly.
  • - A frame-rate counter in the bottom-right corner, with Settings → Performance to hide it, turn off VSync (macOS, Windows) and pick a frame rate limit.
  • - Assistant: agents found on your PATH start when DearSQL is opened from the Dock or Finder.
  • - Assistant: the chat input lines up with the conversation instead of running edge to edge.
  • - Assistant: a reopened chat shows your messages as you typed them, without the schema DearSQL attached, and Chat History has New on its menu.
  • - PostgreSQL: index columns show in key order, not table order.
  • - SQL Server: a failed query shows the server's error instead of "General SQL Server error: Check messages from the SQL Server".

v0.7.3

2026-11-08
  • - CSV files open in a spreadsheet-style editor: edit cells, paste blocks from a spreadsheet, insert and delete rows, undo, and save back in the file's own format. Filter rows with a SQL condition.
  • - S3-compatible object storage: browse buckets on Amazon S3, Cloudflare R2, MinIO, Wasabi and other S3 services, with upload, download, delete and share links.
  • - New connection types: TiDB and CockroachDB.
  • - Command line: dearsql connect with a URL or file saves the connection, so it shows up in the app too.
  • - Assistant chat: select and copy any message text, tables and Mermaid diagrams render, and SQL code blocks are highlighted with a copy icon.
  • - 18 themes to pick from in Settings: One, Ayu, Gruvbox, VS Code, Catppuccin, Solarized and GitHub in dark and light, plus Tokyo Night, Nord and Dracula.
  • - Ctrl+Tab lists just your tabs and matches the other menus; menus and dropdowns are roomier.

v0.7.2

2026-11-07
  • - Command line: your agent's database tools run as plain commands too (dearsql search, describe, query and more), and dearsql --tui has a new look.
  • - Uses noticeably less memory, and the download is smaller.
  • - Saved passwords are encrypted with a key kept in a file in ~/.dearsql, so the Keychain no longer asks for access. Switch back in Settings → Security; installs already on the Keychain stay on it.
  • - New font (JetBrains Mono), clearer table headers and centred row numbers.
  • - Cassandra: fixed a crash when disconnecting while the keyspace list was loading.

v0.7.1

2026-11-04
  • - SQL Server (macOS, Windows): the Encrypt option now really encrypts the connection, so Azure SQL connects.
  • - Linux: the AppImage now runs on Ubuntu 22.04 and other systems with glibc 2.35.

v0.7.0

2026-11-04
  • - AI: the agent can change data and add connections after you approve it in the chat; production connections always ask.
  • - dearsql --mcp: connect by URL or file, --allow-writes to let agents run changes, and dearsql --version.
  • - PostgreSQL: much faster table list on large schemas.
  • - PostgreSQL: real type names for enums, domains, extension types and arrays.
  • - SQLite: BLOBs and values with NUL bytes load intact.
  • - Clearer buttons in dialogs; custom background shaders removed; smaller downloads.
  • - macOS: sharp app icon at small sizes.

v0.6.0

2026-10-11
  • - Command line: dearsql --tui terminal client, --mcp server for agents, and --lsp for editors.
  • - Schema-aware SQL completion: aliases, CTEs, dialect keywords and column types.
  • - Table DDL: Copy DDL, Export → DDL, and a DDL tab in the table inspector.
  • - AI: assistant chats per connection with chat history; rebuilt agent database tools.
  • - Colour and tag connections, and group the sidebar by tag.
  • - Export and CSV import run in the background with progress and cancel.
  • - PostgreSQL: stream large results instead of loading them whole.
  • - Linux: ARM64 (aarch64) AppImage.
  • - Fix UI freezes when closing tabs or disconnecting during slow queries.

v0.5.0

2026-09-26
  • - Add DuckDB backend, with CSV file support.
  • - AI: sidebar tab driving Claude Code, Gemini CLI, Codex, Cursor and Antigravity over ACP, with model selection.
  • - Follow foreign keys to the referenced row.
  • - Add read-only connections.
  • - Export to Markdown and HTML.
  • - Windows: enable Snap Layouts for the title bar.

v0.4.14

2026-08-24
  • - MySQL: import and export a whole database as a SQL dump.
  • - Add multi-row deletion and select all.
  • - Encrypt saved credentials with a per-install OS keystore secret.
  • - UI polish: tab bar, buttons, controls, dialogs, and smaller scrollbar.
  • - Fix light-mode table buttons.

v0.4.13

2026-08-10
  • - Add query timing waterfall for PostgreSQL and MySQL.
  • - SSH: support private key passphrase and surface SSH errors.
  • - MySQL: connect without a default schema when no database is given.
  • - Show last shader error.
  • - Fix database drop by deferring it out of the render loop.

v0.4.12

2026-06-15
  • - Fix save/load shader.

v0.4.11

2026-06-14
  • - Add custom shader.

v0.4.10

2026-05-21
  • - Replace platform-specific connection dialogs with a unified ImGui dialog.
  • - MSSQL: display SQL Server PRINT messages in query results.
  • - Add connection URL parsing.

v0.4.9

2026-05-20
  • - Add table cell context menu.
  • - Add duplicate/delete row buttons.
  • - Add cell copy/paste shortcuts and selected-cell border.
  • - Add total row count badge.
  • - Fix: bundle modern type2-runtime in AppImage.

v0.4.8

2026-05-12
  • - Show table size in sidebar for PostgreSQL and SQLite.
  • - Fix sidebar: keep scrollbar from shifting layout.

v0.4.7

2026-05-06
  • - Fix CJK (Chinese/Japanese/Korean) rendering in sidebar.
  • - Fix MySQL: force TCP protocol and correct sslmode verify semantics.
  • - Fix CSV: async file load and tighter toolbar.
  • - Show full error messages.

v0.4.6

2026-05-03
  • - Cassandra support.
  • - Sequence viewers for PostgreSQL and SQLite.
  • - Schema filter badge in the sidebar for PostgreSQL and MSSQL.
  • - Diagram UI improvements.
  • - Table view: horizontal scroll now tracks correctly during arrow-key cell navigation.
  • - Table view: bool-cell click reliability.

v0.4.5

2026-04-24
  • - Add Postgres backup and restore options.

v0.4.4

2026-04-22
  • - Add table cells selection.

v0.4.3

2026-04-14
  • - Refine UI.
  • - Bug fixes.

v0.4.2

2026-04-12
  • - Add auto-increment support to table editor.
  • - Optimize GTK cursor updates on Linux.
  • - Add date/time picker for table cell editing.
  • - Fix menu popover styles.

v0.4.1

2026-04-08
  • - Render boolean cells as checkboxes instead of t/f strings.
  • - Show 1 line for table cell only.
  • - Fix auto-complete input: anchor popup to input, not end-icon button.
  • - Fix text editor: correct line numbers and click hit-test when scrolled.
  • - Fix text editor: jump to line edge on up/down at first/last line.

v0.4.0

2026-04-07
  • - Fix filter auto-complete.
  • - Fix Japanese/Chinese fonts.
  • - Display routines/functions node.
  • - Add routine viewer tab.
  • - Show/hide db from the list.
  • - Improve save dialog: SQL editor, editable SQL, cmd+s shortcut.

v0.3.7

2026-04-03
  • - Make tables selectable.
  • - Update app colorscheme.
  • - Bug fixes.

v0.3.6

2026-03-31
  • - Bug fixes.

v0.3.5

2026-03-25
  • - Bug fixes.

v0.3.3

2026-03-22
  • - Fixed saving scripts.

v0.3.2

2026-03-21
  • - Added SQL query save.
  • - Fixed app unresponsive after idle mode on macOS and Windows.

v0.3.1

2026-03-19
  • - Added data importer.
  • - Replaced table edit dialog with inline tab.
  • - Added Windows support.
  • - Improved Linux idle mode when inactive and unfocused.

v0.3.0

2026-03-15
  • - Added CSV editor.
  • - Added file open support and close tabs on connection removal.
  • - Switched to libmariadb.
  • - Fixed connection pool reconnect handling.

v0.2.3

2026-03-13
  • - Added Oracle database support.
  • - Added table export to JSON and CSV.
  • - Added editor font size setting.
  • - Added Oracle client install status and improved macOS client install flow.
  • - Fixed Linux build issues and other stability improvements.

v0.2.2

2026-03-10
  • - Added Redshift support.
  • - Added MongoDB query editor and AI assistant.
  • - Added connection rename option with native input dialog.
  • - Added MSSQL database selector in SQL editor.
  • - Added system database visibility option.
  • - Fixed PostgreSQL deferred schema loading.

v0.2.1

2026-03-08
  • - Added Redis commands runner and pub/sub.
  • - Added MSSQL support.
  • - Bug fixes and improvements.

v0.2.0

2026-03-02
  • - Added native alert dialog.
  • - Fixed MySQL crash.
  • - Fixed tab flash and improved light theme contrast.
  • - Disabled form fields while connecting.

v0.1.12

2026-02-27
  • - Added one-click SQL formatting.
  • - Added shortcuts: Ctrl+Enter run, Ctrl+/ comment, Ctrl+F/Ctrl+H find and replace.
  • - Improved autocomplete with type indicators.
  • - Synced editor colors with app theme.
  • - Fixed AI chat input affecting the SQL editor.

v0.1.11

2026-02-27
  • - Replaced the old input with a custom SQL editor.
  • - Added tree-sitter SQL syntax highlighting.
  • - Added autocomplete for SQL keywords and database objects.
  • - Added line numbers, cursor and selection improvements, keyboard and mouse navigation.
  • - Added undo/redo and full clipboard support.

v0.1.9

2026-02-22
  • - Added AI chat panel.
  • - Added database/schema selection dropdowns to SQL editor tab.
  • - Fixed refresh crash.