Changelog

Version 2.0.0

On-device AI assistant (new)

• New AI tab — a private, on-device chat assistant that runs entirely on your PC (nothing is sent to any server). Ask about your database, explain a query, or describe a table, with the current schema as context and streaming replies.
• Two downloadable models — Qwen2.5-Coder 1.5B (default) and Phi-4-mini — fetched on demand with an explicit, consent-first download prompt and a model picker.

Built-in local MariaDB server (new)

• New Local Server tool — download and run a portable MariaDB (11.4) locally, with start / stop / configure, all managed by the app.

SQL & browsing

• SQL console: syntax highlighting, run-only-the-selection (F5), a confirmation before destructive statements (DROP / TRUNCATE / DELETE-or-UPDATE without WHERE), a database picker, and query history.
• Browse: server-side WHERE filtering and click-to-sort columns.
• In-grid edits now save as a single transaction (all-or-nothing).

Fixes & polish

• Editing a connection no longer drops SSL settings; CSV export is hardened against spreadsheet formula injection; multi-statement scripts return every result set.
• Icons on all tabs.

Version 1.1.0

General

• Added an About box (ⓘ in the toolbar) showing the app logo, version and build number, and a link to backendside.com.
• Export now has two actions: Export (into the on-screen text box) and Export to file (streamed straight to disk with a progress bar — safe for very large tables, and you can keep working in other tabs while it runs).
• Import can run SQL from the editor or run a chosen .sql / .csv file directly, with a progress bar; large files aren't loaded into the editor.
• Long operations (exporting, importing) show a progress bar that blocks only that tab — the rest of the app stays usable, and you can Cancel.
• Added loading spinners while a table loads, a query runs, or the database tree refreshes.
• Toolbar buttons now enable / disable based on what's selected and whether you're connected.
• Right-click the navigation panel for a menu (create / connect / disconnect / edit / remove / refresh), with context-appropriate options.
• Empty tables now show a clear “This table has no rows” message instead of a blank grid.

Visual Designer

• New Designer tab — an entity-relationship (ER) diagram of a database.
• Each table is shown as a box listing its columns; foreign keys are drawn as lines connecting the related tables.
• Drag boxes to arrange the diagram; your layout is saved per database and restored next time.
• Pan the canvas and zoom in and out.
• Create a table directly from the Designer.
• Draw a relationship by dragging from the dot on one column onto another column — it creates the foreign key for you.
• Double-click a table's header to edit its columns.

Fixes

• Fixed an error when quickly switching between tables on the same connection.
• Fixed a crash that could happen when opening dialogs (such as adding a connection).
• The main window and the startup splash screen now open centred on screen.

Version 1.0.0

Connections

• Create, edit, and remove saved server connections.
• Test a connection before saving it.
• Connect to several servers at the same time and switch between them just by clicking in the navigation tree.
• Choose an encryption (SSL) mode per connection — Off, Preferred, Required, or certificate-verified — with an optional certificate file.
• Saved passwords are encrypted and kept on your own device.

Browsing data

• Navigation tree of Servers → Databases → Tables and Views, loaded on demand.
• Browse tab shows table rows in pages, with row counts and timing.
• Smooth scrolling through large tables.

Editing data

• Edit cells directly in the Browse grid and click Save to apply.
• Add new rows and delete selected rows.
• Tables without a primary key open in read-only mode to prevent accidental wrong-row changes.
• Insert tab provides a form generated from the table's columns, with a NULL option per field.

Designing tables

• Structure tab lists columns, indexes, and foreign keys, and shows the table's definition.
• Add, change, or drop columns.
• Add or drop indexes (including unique indexes).
• Create Table designer for defining multiple columns at once (name, type, nullable, primary key, auto-increment, default).
• Operations tab to rename, empty (truncate), or drop tables, and to create or drop databases.

Running SQL

• SQL tab with a code editor: line numbers, run with a button or F5, and a Stop button to cancel a long-running query.
• Results shown in a grid, with status messages and timings.
• Query history that remembers your recent statements — and keeps them between sessions. Pick any entry to load it back into the editor.

Exporting and importing

• Export a table to CSV, JSON, or SQL, or export a whole database as SQL, with an on-screen preview before saving.
• Import by running a SQL file (or pasted SQL).
• Import a CSV into a table, with a column-matching step so you can map spreadsheet columns to table columns (or skip ones you don't need). Large files are imported quickly and all-or-nothing, so a failure leaves your table unchanged.

Administration

• Privileges tab: list users, view their grants, and create or remove users.
• Grant and revoke privileges through a simple picker (choose the privileges and the scope — everything, a database, or a single table).
• Status tab: view server status values and settings (with a filter box), and see the live process list with the ability to end a connection.

Safety

• Destructive actions — dropping tables or databases, truncating, removing users, ending connections — always ask for confirmation first.

Coming next