Repository navigation
Releases
Releases · Coprimal/Dblore
Dblore 0.10.2
Improved
- New home. Dblore now lives at github.com/Coprimal/Dblore and dblore.coprimal.dev; the old repository and website addresses redirect there. About (now credited to Coprimal), the welcome window, Settings > Plugins and the website link to the new repository, and plugins download from its releases. #4ec8de09
- Updates. Dblore checks for updates at
dblore.coprimal.dev/appcast.xml. Updates stay signed with the same key. #42a984ca
Upgrade notes
- Older versions. Dblore 0.10.1 and older keep finding updates at the old feed address, which now carries a copy of the new feed; install this version so Dblore reads the feed at its new address.
Dblore 0.10.1
Added
- Redis (plugin). Connect to Redis 6.0 or later once the Redis plugin is installed from Settings > Plugins (about 177 KB, downloaded on demand): host and port (6379), an optional ACL user, the password and a database index from 0 to 15, over TLS (Verify Full, optionally with a custom CA) or plain TCP to a host on the local network, directly or through an SSH tunnel. A Redis workspace has command tabs (
.redisfiles) that run commands in the database you pick, show each reply as Grid or Raw and Cancel a running command (a reply stops at 10,000 rows); a sidebar with db0 to db15, their key counts and their keys in folders split at:, filtered by a match pattern; and key tabs that show a key's type, TTL and size and its value (a string as Text, Hex or JSON, a hash, list, set, sorted set or stream in pages of 200). Edit strings, hash fields, list elements, sorted set scores and the TTL, add fields, elements, members and stream entries, remove fields, members and entries, rename or delete a key and create one with New Key; every edit is listed in History. Each command is checked before it is sent: Read-only allows reads only, Schema Protected blocks admin, destructive, script and unknown commands, destructive commands such asFLUSHALLalways ask first, and command tabs refuseSELECT,AUTH,MULTI, subscribe and blocking commands. Read-only is checked by Dblore and the plugin, not the server; for a guarantee on the server, use an ACL user without write commands. Import Connections reads Redis connections from TablePlus (no password; a TLS mode other than Disable or Verify Full becomes Verify Full and a database outside 0 to 15 becomes 0, each with a note) and from a Dblore connections file. Not in this version: notebooks, the schema visualizer, the AI assistant, result export, MCP and Shortcuts. #bc96e522 #bbef502d #8ac878c0 #82874413 #0ca22c38 #716e3d6b #667c56b3 #027b01fa #a16ccae8
Improved
- Settings > Developer. The "Show experimental engines" toggle is gone: every available engine is listed in the connection form's engine picker, a plugin engine once its plugin is installed. #62d03b32
Upgrade notes
- Older versions and Redis. A workspace that holds a Redis connection needs this version or later: Dblore 0.10.0 shows "This workspace uses a database engine this version of Dblore does not support. Update Dblore to connect." and keeps the connection unchanged when it saves the workspace; older versions cannot open it (see the 0.10.0 note on new engines).
Redis engine plugin 1.0.0
DbloreRedis.bundle 1.0.0, signed with Developer ID (86H6CNLN4C), notarized and stapled. DbloreRedis.zip sha256: 168df4440eab674e139418cefddc59ce69c5d33560856c2a13376d2ed35d1eba, bundle cdhash: 8987c5b418bc17218d5a6cf975420c6407b0b300
Dblore 0.10.0
Security
- 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 = 1ran asDELETE FROM t. #909c8609 - PostgreSQL schemas. Generate Rows (reads, preview and inserts), Shortcuts Add Row and the Join builder name the schema of a
publictable. 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 yoursearch_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.
/settingsfills 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 andCmd+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. AGOline 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 throughMERGE, or runsDELETEorUPDATEwithoutWHEREneeds the target's name typed before Approve or Run; on MCP so do MongoDBdrop()anddeleteMany({}). The name is checked again when you approve, and Return never approves. ADELETEorUPDATEwithoutWHEREwhose 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 refusesEXPLAIN ANALYZEof 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 r...
SQLServer engine plugin 1.0.0
DbloreSQLServer.bundle 1.0.0, signed with Developer ID (86H6CNLN4C), notarized and stapled. DbloreSQLServer.zip sha256: f71092cbc98a36e9fdb124f663c1cbef9578a7c9b1321dc233efaed2a47775eb, bundle cdhash: 5a0230a4932f73395cac63e0c810deed001d1e3b
ClickHouse engine plugin 1.0.0
DbloreClickHouse.bundle 1.0.0, signed with Developer ID (86H6CNLN4C), notarized and stapled. DbloreClickHouse.zip sha256: e0bac7245a8cd22cc1bd6481c5ee5f1c683a68a6d2c9deff7a13827972426bce, bundle cdhash: afd26b435018156da0dfe2413d3a5b03483a9984
Dblore 0.9.3
Security
- PostgreSQL restore. A restore runs the dump's DDL (CHECK constraints, defaults, view bodies, index expressions) with
search_path = pg_catalog, pg_tempand puts your value back afterwards. Before, a function or operator planted in a schema on your path could become part of the restored objects. Triggers and functions the restore fires run under that path too. #c5e00609 - PostgreSQL statements on your data. Edits, row locators, Data Rewind, the data viewer and its filters, foreign-key lookups, Find a Value in Every Table, the cascade preview, import and Copy Objects name PostgreSQL's built-in operators, functions and casts, and import and Copy Objects always name the schema,
publicincluded. Before, a function, operator, table or view created by another role in a schema on yoursearch_pathcould run in their place. #a46618fd #0c1b679b #08362ec8 #e0bdc5f4 #4d55c30b - Known limits. Filters, import keys and Copy Objects paging keep the extension's own operators on citext, PostGIS, hstore, ltree, cube and the isbn family, and that list matches the type name only, so a user type with one of those names keeps them too. A cast to a user type uses the name printed when the schema loaded. Outside the data viewer a domain is not resolved to its base type, so an import key on a domain over citext compares as case-sensitive text. The cascade preview undercounts child rows whose citext foreign key differs in case from the parent, and FK lookup does not find their parent. Copy Objects reads a table whose key has a user-type column by position, which is slower. Generate Rows and Shortcuts still name a
publictable without its schema. Keys of edits, row locators, Data Rewind, the cascade preview and FK lookup always use the built-in=, so a citext primary key compares as text (no index use) and a key on ltree, hstore or geometry is refused. A filter or import key on an extension type outside the list either errors or compares as the built-in type it casts to. In the data viewer, a domain over a listed type compares as text until the user types have loaded.
Added
- Restore mysqldump and mariadb-dump files. On MySQL/MariaDB connections, Restore SQL Dump reads mysqldump 8.x and mariadb-dump files: their header and footer settings, per-table character set lines,
LOCK TABLES,DISABLE KEYS,DROP TABLE IF EXISTSfor tables the file creates, and rows of numbers, text,_binary,0xandb''values.SET NAMES utf8andutf8mb3run asutf8mb4, and the session's settings are reset after every restore, also a failed or stopped one. Lines Dblore does not restore are refused before anything runs, naming the dump option to use: GTID lines (--set-gtid-purged=OFF), triggers and routines (--skip-triggers, no--routines),USEandCREATE DATABASE(no--databases), views (--ignore-tablefor each view) and other character sets (--default-character-set=utf8mb4). The file must be valid UTF-8, so binary columns written as raw bytes cannot be read. #3382299b - Line bookmarks. In a SQL editor tab,
Cmd+F2or a click in the line number gutter toggles a bookmark,F2andShift+F2jump to the next and previous one, wrapping around. Bookmarks follow edits and are saved with the workspace. #45e4c944 - Nested groups and favorite connections. A group name such as
Prod / EU / Webshows as nested groups on the welcome screen (up to three levels) and in the connect form's history menu, and the Group field offers the existing paths. Star a connection to list it under Favorites first; favorites are never trimmed from the 50-entry history and travel in the Dblore connections file. #3427ae03 - Running-work prompt. Quit (Cmd+Q, the menu, the Dock or logout), closing a workspace window and Disconnect list the running queries, imports, restores, dumps, copies, exports and schema compares first, with Stop and Cancel (a Parquet export is listed at Quit only). A restore says whether stopping rolls it back (PostgreSQL, SQLite, DuckDB) or keeps the statements already run (MySQL, MongoDB). #e1eb54a7 #b92fdb3e
- DuckDB data import. CSV, TSV and JSON import into DuckDB tables, new or existing, keyed updates included. It is refused in Protected mode or with a transaction open, since DuckDB has no savepoint. Row edits, Paste Rows and Generate Rows stay off on DuckDB. #4d55c30b
Fixed
- SQLite read-only toggle. The connect form shows the Read-only switch once a SQLite file is chosen. #4d55c30b
- Import schema. An import with the Schema field empty names the table's schema in its SQL, preview and history. #4d55c30b
- New commands with no workspace. New Tab, New Notebook, New SQL File and New Markdown Note open a window when no workspace is open. #4d55c30b
Upgrade notes
- PostgreSQL restores. A trigger or function that uses unqualified names and fires during a restore now fails (the error says why), so some restores that worked before need those names qualified.
- Quit asks when work runs. The running-work prompt shows whatever Confirm before quitting with Cmd+Q says, also for a Dock or logout quit; the setting still decides the plain "Quit Dblore?" when nothing runs.
- Group names. An existing group name that contains
/(such asCI/CD) now shows as nested groups and is saved asCI / CD; a fourth level and deeper merge into the third. - PostgreSQL edits on extension-type keys. Editing, staging or rewinding rows of a table whose key column is ltree, hstore or geometry now fails with an error instead of running, and the cascade and FK previews over such keys fail too.
- Favorites and MCP. Starring or unstarring a connection that MCP is using reconnects its pooled session on the agent's next request. Older builds ignore the favorite flag (
isFavoriteConnection) and the bookmarks saved in a workspace (lineBookmarks).
Dblore 0.9.2
Security
- Quotes followed by a combining accent. Names and values that contain a quote or backslash followed by a combining accent are now escaped correctly in every generated SQL statement, export, dump and Schema Compare script, on every engine. Before, such text could change the SQL Dblore wrote. Names of outside MCP servers and tools are escaped the same way in what Dblore sends to the AI provider. #85d8d0e7 #c46a6359 #7d12db58
- Read-only connections. They now also refuse MySQL
WITH … REPLACEstatements and DuckDB remote URLs written with combining accents. #c46a6359 - PostgreSQL catalog reads. Schema, structure and metadata reads no longer call functions or operators found through your
search_path; they always use the server's built-in ones. Before, a function planted by another role in a schema on your path (for examplepublicon PostgreSQL 14 and older) could run when Dblore loaded the schema. #0e42cfff #7d12db58 - Accent-encoded table names. Two tables whose names differ only in how an accent is encoded are no longer treated as the same table. #0e42cfff
Added
- Column masking. The Masking section of the connection form hides columns by name (
column,table.columnorschema.table.column) as Full, Last 4, Email or NULL in results, copies, exports, AI, MCP, Shortcuts and the command-line tool. Masked cells cannot be edited, the export sheet keeps them checked, and the Data Rewind preview shows mask text while Rewind restores the real values. Rules travel in the Dblore connections file. #a5dc68d3 #42a31a3c #1a8c7496 - Table Health. File > Table Health lists tables without a primary key and foreign keys without a covering index on PostgreSQL, MySQL/MariaDB and SQLite, plus unused indexes and tables with many dead rows on PostgreSQL and unused or redundant indexes from the MySQL
sysschema, filtered by Keys, Indexes or Bloat, with Show Table and Copy Report. #5bfef6c0 - MySQL table options. The structure editor sets a MySQL/MariaDB table's character set, collation and AUTO_INCREMENT, and Convert existing data rewrites the rows after a confirmation. #5628ae2d
- Edit PostgreSQL views. Cells of an auto-updatable PostgreSQL view whose key maps to the base table's primary key can be edited, staged and rewound like a table's, except a row the edit moved out of the view, which Rewind cannot capture. Row delete, Add Row and paste are refused on views. #884136bd #10f45539
- Result set tabs. Several result sets show as tabs such as "1 · 120 rows" or "2 · UPDATE 3", in the editor and in notebook cells; from seven results the rest go in More. #f835ea42
- Connection endpoints. Welcome and recent connection rows show
host:port@user, the file name for SQLite, and search matches it. #f835ea42 - Smarter completion and partitions. After
ON, autocomplete suggests the foreign-key join condition; table and column names also match in the middle (ordfindspurchase_orders). PostgreSQL partitions show under their parent table in the sidebar, and the filter opens the parent of a matching partition. #72fbf1bc
Fixed
- PostgreSQL errors and types. Errors start with their SQLSTATE (
ERROR 22012: division by zero), and a query on one quoted or schema-qualified table shows the column's full type (NUMERIC(10,2)). #1662b7f4 - Copy as INSERT and SQL INSERT export. They write the schema and table as two quoted names (
"public"."orders"), so the INSERT runs. #87be440e - Import. Text timestamps without a zone import as a timestamp without time zone ("Timestamp (no zone)"), keeping their wall clock. #87be440e #4202518f
- Restore. A MySQL file with its own
SET NAMESline is refused with that statement quoted. #1662b7f4 #9ee2df28 - Launch windows. A launch while the display sleeps shows a single Welcome window, and a file opened at launch in Restore mode keeps the restored workspaces together as tabs in their own window. #1662b7f4
Upgrade notes
- MCP and the command-line tool output changed. PostgreSQL errors start with
<severity> <sqlstate>:, for exampleERROR 22012: division by zeroorFATAL 28P01: …for a refused login, also when the connect fails. A read of one quoted or schema-qualified table returns the catalog type (NUMERIC(10,2)instead ofnumeric). - Masking is not access control. It matches column names, so an alias or a computed column in SQL written by you, the AI or an MCP agent gets past it. Filters, sorting and Find in every table still search the real values, and SQL dumps, backups, Copy Objects, Schema Compare and the Data Rewind store keep them. While a transaction is open, a table renamed by another session since this connection last read it is matched under its old name until the transaction ends.
- Mask rules and older builds. Connections with rules save a
maskRuleskey; an older build ignores it and drops the rules when it saves that connection again. Notebook files mark masked columns with"masked": true, which older builds ignore. - PostgreSQL
search_path. Statements Dblore builds over your data (cell edits, filters, foreign-key lookups, Data Rewind) and restored dumps still resolve operators through yoursearch_path; a fix follows. - Views. PostgreSQL auto-updatable views take cell updates only, never row deletes or inserts; views with INSTEAD OF triggers, without a mappable key or over something other than a table stay read-only. MySQL/MariaDB views stay read-only.
Dblore 0.9.1
Added
- Edit tables without a primary key. Edit, delete and duplicate rows in a table tab of a PostgreSQL or SQLite table that has no primary key. A row that changed since it was read is refused, never retargeted. MySQL/MariaDB still need a primary key. #356bcec7 #f8a3d028 #59292da3
- Ask on connect. A connection can ask for its password each time it connects; the password stays in memory for reconnects and is never saved. MCP, the command-line tool and Shortcuts refuse such connections. #72e60ef0 #cae3c058 #bfc9ac70
- Replace Pin. When an SSH host key changed, compare the old and new fingerprints and choose Replace Pin to trust the new key, then the same connect is retried. #f0587df3
- Timed write unlock. Unlock data writes on a Read-only connection for 1 or 5 minutes after the Safe Mode authentication. Schema changes stay blocked, and the unlock ends on expiry, Lock now or disconnect. #d614d535
- Stop a PostgreSQL statement and keep the connection. Stop now cancels the running statement on the server and keeps the session, its temp tables and its settings; an open transaction is rolled back. #23d7a8a8
- Index order. The structure editor shows and sets DESC (and NULLS FIRST or LAST on PostgreSQL) per index column. Compare Schemas reports order differences and Copy Objects keeps the order. #f91a8e36 #44f93065
Improved
- Exact numbers. PostgreSQL NUMERIC (including NaN and Infinity), MySQL DECIMAL and DuckDB DECIMAL are shown, sorted, edited and summed exactly, and exports write them without rounding. #b420385f #9cf3dab4 #e7980874 #8bfd6617 #49e6700b
- Timestamps. Columns without a time zone show their stored wall clock, and zoned ones show Mac local time with the offset, both with fractions, in the grid, filter, search, edits, copies, exports, charts and MCP. #3ca86939 #2078a39a #85edf2ae #51f0a69e #f53eefbc #32116dab
- Faster table tabs. Rows show before the table definition is read; editing waits until it is known. #4890ef5e
- Keepalive. Idle PostgreSQL, MySQL/MariaDB, direct MongoDB and SSH tunnel connections use TCP keepalive. #6d5071be
- Restore and import. A SQL restore splits MySQL scripts in linear time with lower peak memory, and shows reading and splitting progress; a file import shows parse progress. #95c5fbb2
- Settings. The Settings panel is wider (720 pt). #3a1a0011
Fixed
- Keychain read failures. Every connect path stops when the Keychain cannot read a saved password, instead of sending an empty one, and never deletes the stored password. #2510d297 #9c52770d #b37f29a5 #8ea61131
- PostgreSQL values. An empty text value shows as empty text instead of NULL,
realvalues show their shortest text (1.1, not1.100000023841858), and functions without arguments appear in the sidebar. #85802dbb - Locks and windows. A lock reseal refreshes open documents, the first DuckDB run waits for the connect loads, and window close, pending workspace routing and external file opens no longer misbehave. #d50f8169 #a2904864 #2244706b
Upgrade notes
- MCP, the command-line tool and Shortcuts output changed. Columns without a time zone (PostgreSQL
timestamp, MySQLDATETIME, DuckDBTIMESTAMP) are now the stored wall clock2026-10-15 12:00:00.123, no longer2026-10-15T12:00:00Z; zoned columns stay ISO 8601 UTC and now keep their fraction. NUMERIC and DECIMAL values are JSON numbers up to 15 significant digits (trailing zeros dropped,19.90becomes19.9), longer values and NaN or Infinity are strings; MySQL DECIMAL used to be a string. The same shapes apply to copy and to CSV, TSV, JSON and XLSX exports.dbloreprints plain digits (0.0000001, not1e-07). - New refusals. MCP,
dbloreand Shortcuts refuse a connection that asks for its password on connect, and one whose saved password the Keychain cannot read. - Notebook files stay readable by older builds. NUMERIC and DECIMAL cells carry
"decimal": true, timestamp columns without a zone carry"wallClock": true, and dates with a fraction add"micros". Older builds ignore these keys. - Saved connections. A connection that asks for its password adds
askPasswordOnConnectand its stored Keychain password is removed. An older build finds no password and fails to authenticate. The Dblore connections export file does not carry the flag. - Exports and import. XLSX writes integers of 10^15 or more and NaN or Infinity as text and NULL as an empty cell; Parquet keeps DOUBLE for decimal columns. Importing into a new table makes decimal columns
DECIMAL(65,30)on MySQL and TEXT on SQLite.
Dblore 0.9.0
Added
- Paste rows. Paste rows from the clipboard into a table tab with Cmd+V or Paste Rows: up to 10,000 rows staged as inserts in one Undo step, with a header row matched by column names. #6ebedb37
- SQL dump per object. Choose Structure, Data and Drop for each table in the SQL dump sheet. A restore drops only the objects the dump creates, never with CASCADE. #c422d58c #72dbeb10
- Copy Objects. Copy tables and their rows from a PostgreSQL, MySQL/MariaDB, SQLite or DuckDB connection to another saved PostgreSQL, MySQL/MariaDB or SQLite connection, with type warnings and an editable DDL preview. A failed or cancelled copy leaves nothing behind on PostgreSQL and SQLite; on MySQL/MariaDB Dblore drops the tables it created and names any it could not. #4d8b5a5a #53d8f307 #4f1261a0 #91934498
- PostgreSQL types editor. Create and change enums, domains and composite types, with a preview of the exact SQL. #dfb3a420
- Schema editing on the ER diagram. Rename tables and edit columns and foreign keys on the canvas, or drag a column onto another table to add a foreign key, then review the changes before Apply. #803fa58d
- Reload banner. A table tab shows a Reload banner when another tab changed its table. It never reloads over staged edits. #aedeb020
- Shortcuts actions. Open Connection, Run Query and Add Row for the Shortcuts app, off by default and only on the connections you allow in Settings > Shortcuts. #f89eccfc
- Command-line tool.
dblore connectionsanddblore queryread the connections the MCP server shares (read-only), as CSV, TSV, JSON, JSON Lines or a table. Pair once withdblore pair --port Nand the code shown in Settings > MCP, which also gives the line that installsdblore. #82750f6d #2f2f84cf - Apple Intelligence. Choose Apple Intelligence (macOS 26+) as the AI provider; prompts stay on this Mac. #f437176f
- HashiCorp Vault. A connection can take its login from Vault: a lease on every connect, renewed while connected and revoked on disconnect. Test Vault checks the setup from the connection form, and connection files carry the Vault settings without the token. #10e7d8a9 #dadebb56 #ee45d301
Improved
- Settings pages. Keyboard shortcuts have their own Keyboard page; the Shortcuts page is for the Shortcuts app. #e8d5116b
- Large catalogs. At 50,000 tables the schema load can be cancelled, the sidebar filter runs in the background, autocomplete, the command palette and AI context stay fast, and the diagram draws up to 300 tables you pick. #173cc2dd #2a5fe2a9 #7131f235 #0c51a7eb
- Formatter. Format SQL keeps MySQL
#comments and says when it leaves the text unchanged. #55953867
Fixed
- Saved connections. Saving a connection replaces only its own row, the connection string never shows the saved password, a locked row reads no SSH secret before unlock, and the form cannot weaken a saved row's protection without unlocking it. #21a2d4b7
- Cell values. Binary edits write bytes instead of base64 text, a plain DATE is accepted in the NULL editor, large values no longer slow the right sidebar, and editor results refresh after an inline edit. #55953867
- Documents and windows. The file conflict alert shows, window restoration keeps a single Welcome window, and the launch window keeps its size after its last tab leaves. #9725caa5
- DuckDB and local models. A DuckDB file query waits for the reconnect, nested text is quoted correctly, the local models list refreshes after an import, and inline suggestions no longer disappear on layout. #c1d7cc04
- MCP server. Idle and slow connections now time out. #40a654e2
Upgrade notes
- SQL dumps with Drop use format 2 (
-- Dblore SQL dump 2); older versions refuse to restore them. - A connection that uses Vault connects without a password in older versions and fails to log in.
- With Apple Intelligence as the AI provider, older versions drop the AI settings.
- History rows from Shortcuts or the command-line tool show as editor in older versions.