You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
NUL characters on SQLite and DuckDB. Text values that contain a NUL character are stored and read in full, and a statement that contains one is refused ("This statement contains a NUL character, which the database would cut off."). Before, both engines cut the text at the NUL, so DELETE FROM t<NUL> WHERE id = 1 ran as DELETE FROM t. #909c8609
PostgreSQL schemas. Generate Rows (reads, preview and inserts), Shortcuts Add Row and the Join builder name the schema of a public table. A new-table import with the Schema field empty uses the server's current schema and names it in the preview, the CREATE and every INSERT, and is refused when there is none. Before, these statements found the table through your search_path, where a table or view with the same name in an earlier schema could take its place. #0bdb6529
PostgreSQL extension types. Dblore reads each column's type from the catalog with the schema, and filters, import keys, Copy Objects paging, edits, row deletes, the cascade preview and FK lookup take their comparison from it: a real citext, PostGIS, hstore, ltree, cube or isbn-family column, or a domain over one, uses the extension's own operator named with the extension's schema; every other type, a user type that only shares one of those names included, uses the built-in one. Casts to a user type name its schema. This removes most of the v0.9.3 known limits: citext keys in edits compare case-insensitively, the cascade preview counts child rows whose citext foreign key differs in case, FK lookup finds their parent, and domains are resolved everywhere from the first load. Keys on ltree or hstore still fail (see Upgrade notes), geometry keys use the PostGIS operator but are untested, and Data Rewind keys still compare as text. #3cdb1e90#119957ec#7c0ec102
Keychain copies from older versions. Copies of saved secrets that Dblore 0.8.0 and older left in the login keychain are deleted once Dblore has checked the copy in the data protection keychain (the same secret, or a newer one), without a keychain dialog. A copy that would need a dialog is kept. #d901630d
Added
Change settings from the AI chat. Ask the chat to change Dblore's settings (theme, accent, editor, formatter, results, notifications and more). A change applies at once and shows a card with the old and new value and Undo; Undo reverts only while the setting still has the new value, otherwise the card says "Changed since; not undone". It works with no connection and on a connection whose AI access is off, since it reads no connection data, but not with on-device models. Security, AI provider and keys, MCP, Shortcuts, Safe Mode and session limits stay manual: the AI names the Settings tab to open instead, and History and Data Rewind can only be turned on from the chat. /settings fills the composer with a settings request, and the empty chat panel suggests examples. #a5d0f230#e3999132
Focus shortcuts. In a SQL editor tab, Cmd+Option+1 (Query > Focus SQL Editor) puts the cursor in the editor and Cmd+Option+2 (Focus Results) moves it to the results grid. Both are listed in Settings > Keyboard. #34381c9d
Data viewer refresh after an import. After a data import, other data viewer tabs on the tables it wrote and with no staged changes read their rows again: the active one at once, hidden ones when you next show them. A tab with staged changes keeps them and the Reload banner. An import held in a Review transaction does this at Commit and nothing at Rollback; other writes still show the Reload banner. #ee942749
Structure editor and object source stay current. The structure editor and the read-only object source tabs read their definition again when the window becomes active, after a schema refresh and when a Review transaction ends (at most once every 5 seconds; paused while a Review transaction is pending, not by a transaction you opened yourself). A clean editor updates in place; an editor with staged changes keeps them and shows "This table changed on the server since it was loaded. Reload drops your staged changes." with Reload. #dfe543ff
Column source tooltip. Hover a result column header to see schema.table.column, plus "Masked by a connection rule" when a masking rule hides it. It works for query columns read from a base table on PostgreSQL, SQLite and MySQL/MariaDB (not views) and on data viewer pages; expression columns, DuckDB and MongoDB show none. #98ee58c3
SQL Server (plugin). Connect to SQL Server from the connection form once the SQL Server plugin is installed from Settings > Plugins (about 2.3 MB, downloaded on demand). It connects with TLS (Verify Full checks the certificate and host name) or through an SSH tunnel, lists schemas, tables, views, procedures and functions, pages and filters tables in the data viewer, edits rows of a table with a primary key (in Confirm or Review style, with Commit and Roll Back), follows foreign keys and stops a running statement with Stop while keeping the connection. A Read-only connection is checked by Dblore; for a guarantee on the server, connect with a login that only has db_datareader. Not in this version: the structure editor, SQL dump, import, Explain, Data Rewind, Find a Value in Every Table, Table Health, Generate Rows, Schema Compare, Copy Objects, MCP and Shortcuts. A GO line is refused ("GO batch separators are not supported; run each batch on its own"); the editor splits statements at ;, so a T-SQL variable does not reach the next statement; a procedure that returns several result sets shows only the last one in the grid. #9e922349#02b38a9f#efb0c1f4#fd8d8796
ClickHouse (plugin). Connect to ClickHouse over HTTPS (port 8443) or HTTP (8123) once the ClickHouse plugin is installed, directly or through an SSH tunnel. Databases show as schemas; browse, query, page and filter tables, Stop a running query and Explain as text. A Read-only connection is enforced by the server (readonly=2). Not in this version: grid edits, transactions, the structure editor, SQL dump, import, Data Rewind, Find a Value in Every Table, Table Health, Generate Rows, Schema Compare, Copy Objects, MCP and Shortcuts. #1e55b5ea#7f222e49#a8199c48#b4b1588b
Presets for wire-compatible databases. The connection form's engine picker lists CockroachDB, Redshift and YugabyteDB under PostgreSQL, and TiDB and SingleStore under MySQL. A preset uses that driver, sets the default port, and a PostgreSQL preset leaves out session settings and catalog reads the engine does not have (Redshift keeps only the statement timeout; Redshift and CockroachDB skip sequences, user types and functions). Redshift and SingleStore are untested. #acbefcaf
Improved
Consent step for MCP and AI writes. An MCP write request or an AI proposal that drops or truncates, replaces a table, schema or sequence (CREATE OR REPLACE), drops a column, deletes rows through MERGE, or runs DELETE or UPDATE without WHERE needs the target's name typed before Approve or Run; on MCP so do MongoDB drop() and deleteMany({}). The name is checked again when you approve, and Return never approves. A DELETE or UPDATE without WHERE whose single target table cannot be read (multi-table forms, WITH … DELETE, DELETE … USING) is refused before any approval: "Name the table in a single-table statement, or add a WHERE." The AI Run also refuses EXPLAIN ANALYZE of a write. #0fd6c1c7
Hidden characters in MCP and AI writes. The AI Run checks hidden characters with the MCP rule, and the AI card now marks an allowed invisible character inside a string as [U+XXXX], as the MCP panel does, so what you approve looks like what runs. #909c8609
Restore SQL dumps of any size. Restore SQL Dump no longer has a 64 MiB file limit: it reads the file twice in chunks, first to check every statement, then to run them, so memory no longer grows with the file. A statement can be up to 64 MiB. A statement that changed after the check is never sent: PostgreSQL, SQLite and DuckDB roll the restore back, MySQL keeps the statements before it ("The file changed after it was checked…"). In Protected mode the pending list shows one line per kind, such as RESTORE "860 data statements". #479e0876#64b9fd1b
Import CSV, TSV and NDJSON files of any size. Importing one CSV, TSV or NDJSON file into a new or existing table has no file size or row limit: Dblore checks the file in a first read and sends it in blocks of 1,000 rows in a second, and a block that changed after the check is refused before it is sent. A CSV or TSV field stays limited to 8 Mi characters, and one record (a CSV row or an NDJSON line) to 64 MiB. Keyed imports, JSON array files and multi-file imports keep their 256 MB and 100,000-row limits. On DuckDB, decimal columns of a new table take their digits from the whole file. #0dadee02
Long text in the data viewer. On PostgreSQL (UTF8 databases), MySQL/MariaDB and SQLite, a page reads long text, JSON and XML values as their first 16,384 characters, as it already did for binary values, and shows them with "…". The whole value is loaded when you open it in the Cell Value viewer or Row Detail, edit it, copy it or duplicate its row. Primary key, sort and masked columns, extension types, DuckDB and MongoDB are still read whole. #e16b6920#6b92a569
Long values in editor and notebook results. A value is cut at 1 MiB (1,048,576 characters) and a result stops once it holds 256 MiB of values. A cut value shows with "…", the result says "N values were cut at 1 MiB.", and saved notebooks keep the mark. Open the table in the data viewer or export all rows to read it whole. MongoDB results are not cut. #2bfdc4b1#507a08d4#6e4fc249
Export all rows. When an editor or notebook result stopped at the row cap or the 256 MiB limit, or has cut values, the export sheet offers "All rows" beside "Shown rows (N)": it runs the query again in a read-only transaction on a separate connection (on DuckDB, in the tab's own session) and writes every row whole as CSV, JSON or SQL INSERT, with progress and Cancel (an existing file stays unchanged on Cancel). Mask rules apply as in the grid. It needs one read statement without :name parameters, on PostgreSQL, MySQL/MariaDB, SQLite or DuckDB, and is refused while the tab has an open transaction, pending changes or temporary tables; the sheet says why when it is not offered. #49f90a5f
Workspaces with an engine this version does not know. Opening a workspace whose connection uses a database engine this build does not know shows "This workspace uses a database engine this version of Dblore does not support. Update Dblore to connect." and saving it keeps that connection unchanged. The Recent list and the locked-workspace list read each entry on its own, so one unreadable entry no longer empties the list. #91b91297
Fixed
Stop and a running restore. In the quit, close and disconnect prompt, Stop now waits for a running SQL restore's own cancel warning. Answering "Keep running" cancels the quit, close or disconnect instead of cutting the restore. #98ee58c3
Empty tables in the data viewer. Opening a table with no rows on PostgreSQL or SQLite no longer shows "The page did not come back with the columns it asked for. Reload the table." #03278fa8
Command palette over dialogs.Cmd+K no longer opens the command palette over Settings or the connection form; the menu item is disabled there. #03278fa8
Expand all. "Expand all" in the sidebar no longer freezes on schemas with thousands of tables. #03278fa8
Upgrade notes
Custom settings command. A saved custom slash command named settings is renamed settings-2, since /settings is now built in.
AI Run and hidden characters. The AI Run now also refuses control characters (NUL included), no-break and other special spaces outside string literals, and private-use or unassigned characters. Zero-width joiners and non-joiners and soft hyphens inside a SQL string literal (emoji such as '👩💻') now run. A MongoDB proposal with an emoji variation selector or a no-break space inside a string (such as {mood: "❤️"}) is now refused.
NUL in SQLite and DuckDB statements. A statement that contains a NUL character is now refused, from the editor, notebooks and the AI Run, instead of running the part before it.
PostgreSQL ltree and hstore keys. Edits on citext keys now use citext's own comparison. Edits, the cascade preview and FK lookup on an ltree or hstore key still fail with an error, because Dblore reads those values in a form the server does not take back; no wrong row is changed.
Saved secrets and older versions. Once this version has removed the login keychain copies, Dblore 0.8.0 or older finds no saved passwords or keys (0.8.1 and later still do). On a new Mac set up with Migration Assistant or a full restore, saved secrets may be missing and must be entered again: AI keys, MCP tokens, SSH credentials and known hosts, client certificates, Safe Mode passwords and outside MCP server tokens never leave this Mac, connection passwords may not move either, and the connections export carries no secrets.
Cut values in editor results. Copying, exporting the shown rows, pinning, duplicating or editing a selection that holds a value cut at 1 MiB is refused ("Copy refused: 1 value in this selection was cut at 1 MiB, so it cannot be copied whole."). Use the data viewer or the All rows export for the whole value.
MySQL imports into a new table. A CSV, TSV or NDJSON import into a new MySQL/MariaDB table creates the table first, which commits, then sends the rows. If the rows fail, the import is cancelled or the file changed, the new table stays, empty; Safe Mode says so. On PostgreSQL, SQLite and DuckDB the new table is rolled back with the rows.
Notebooks with cut values. An older Dblore treats a cut value in a saved notebook as whole, and saving the notebook there drops the mark.
Older versions and the new engines. A workspace, Recent list or locked-workspace list that holds a SQL Server or ClickHouse connection needs this version or later: an older Dblore cannot open such a workspace and shows an empty Recent list or locked-workspace list, and may then save that list without the entries it could not read. An older Dblore connects a preset connection as plain PostgreSQL or MySQL and drops its preset when it saves the connection again.
Engine plugins. SQL Server and ClickHouse need their plugin, downloaded on demand from Settings > Plugins and checked (SHA-256, Team ID, signature) before it loads. The SQL Server plugin includes FreeTDS, under the GNU LGPL 2.1, and OpenSSL, under the Apache License 2.0; Settings > Plugins links both licenses, the plugin source and the exact FreeTDS source it is built from.