## Changelog

What's new in DearSQL.

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.