Last updated: 2026-10-14

Changelog

Release history for Jam SQL Studio. Each release is also shown inside the app via the What's New dialog.

1.5.6 — 2026-10-10

• Feature Oracle — Manual and Smart transaction modes in the Query Editor: changes wait until you commit or roll back. Learn more →
• Improvement Oracle and MySQL — a COMMIT or ROLLBACK that has nothing to act on in Auto mode now shows a warning in Messages. Learn more →
• Fix Azure CLI sign-in — fixed “Azure CLI could not be found” on Macs where the Azure CLI is installed with Homebrew.
• Fix SQL Server on Windows — Schema Compare no longer cuts off very long stored procedures, views and functions, and long text, XML and binary values show in full.
• Improvement Azure Storage preview — search inside JSON, XML, Markdown and other text files. Learn more →

1.5.5 — 2026-10-09

• Improvement Query Editor — recognizes the new Fabric Warehouse T-SQL: ANY_VALUE, MEDIAN, QUANTILE, APPROX_MEDIAN, APPROX_QUANTILE, QUALIFY, GROUP BY ALL, ORDER BY ALL and FROM-first queries. Learn more →
• Improvement SQL Notebooks — Add Cell is now visible between cells and above the first cell. Learn more →
• Improvement Query Editor and SQL Notebooks — a setting to show the column names in INSERT … VALUES always, only while holding Ctrl+Alt, or never. Learn more →
• Improvement SQL Notebooks — the cell toolbar hides while you type and shrinks to a single button when text is under it. Learn more →

1.5.4 — 2026-10-06

• Feature Azure Storage — find by name, snapshots, versions and undelete, leases, copy and move across accounts, upload options, open in a desktop app, table import and copy, managed disks, and matching MCP tools for AI agents. Learn more → Azure Storage Explorer vs Jam SQL Studio →
• Feature Connections — Azure China, Azure US Government and custom Azure environments, including Azure Stack Hub, for SQL Server with Microsoft Entra ID, Azure Data Explorer, Azure Storage and Browse Azure. Learn more →
• Feature Settings → Network — proxy and certificate settings for Azure connections, the AI assistants and updates. Learn more →
• Fix Query Editor and Visual Query Editor — fixes for SQL Server MERGE statements, built-in functions inserted by autocomplete, and table lists, value suggestions and foreign-key joins in the Visual view.
• Improvement Windows — improved loading times at startup.
• Improvement MySQL — faster queries on remote servers.
• Improvement Autocomplete — column suggestions before FROM is typed.
• Improvement Query Editor — improved responsiveness with large scripts.
• Fix SQL Notebooks — fixed notebooks that could hang while opening; large notebooks open faster.

1.5.3 — 2026-10-02

Highlights: Azure Storage connections: Blob storage, Data Lake (ADLS Gen2), File Shares, Queues and Tables in the same app as your SQL databases.

• Feature Azure Storage — connect to a storage account, a SAS-scoped resource or the Azurite emulator to work with blobs, Data Lake (ADLS Gen2) directories and access control, SMB and NFS file shares, queues and Table entities, and to preview and edit files in a pane next to the list. Learn more → Azure Storage Explorer vs Jam SQL Studio →
• Feature Visual Query Editor — now on by default (still in Beta): switch a Query tab between SQL and Visual to read and edit the statement under the cursor as clause cards, or edit it in place from the gutter pencil. Learn more → Read the announcement →
• Feature Filters — “in list” and “not in list” operators in Table Explorer, the Visual Query Editor, Data Compare and MCP. Learn more →
• Improvement New Connection — the dialog opens on a list of engines you can filter, with Paste connection string, Browse Azure, Detect local databases and Import from another tool beside it. A pasted connection string shows what it will fill before you continue, and Import and Detect open on top of the dialog without losing what you typed. Learn more →
• Improvement Updates — the “Update ready” prompt can be closed, and the downloaded update installs the next time you quit the app. Learn more →
• Fix Query Editor — multi-statement DML reports the total rows affected. Learn more →

1.5.2 — 2026-09-24

• Fix Linux — the Arch Linux package installs on current Arch and Arch-based distributions, and the app starts on distributions back to Ubuntu 20.04 and Debian 11. Learn more →

1.5.1 — 2026-09-21

Highlights: Database pickers open with the list the Object Explorer already loaded, and say so plainly when a listing fails instead of offering guessed system database names.

• Feature Keyboard shortcuts — Cmd/Ctrl+Enter and Shift+Enter execute the selection or the statement under the cursor. Learn more →
• Feature Keyboard shortcuts — change, add, remove or reset shortcuts in Settings → Keyboard Shortcuts, and take them to another machine with Settings → Backup & Transfer. Learn more →
• Feature Keyboard shortcuts — pick the SSMS / Azure Data Studio, JetBrains DataGrip, DBeaver or VS Code mssql extension scheme in Settings → Keyboard Shortcuts to use that tool’s keys for executing, cancelling, formatting and showing results. Learn more →
• Improvement Database pickers — every database dropdown now opens with the list the Object Explorer already loaded, and explains the failure instead of offering guessed system database names when the list can’t be read. Learn more →
• Fix Query Editor — SQL Server PRINT and low-severity RAISERROR text, and PostgreSQL RAISE NOTICE / INFO / WARNING text, now appear in Messages instead of being dropped, and a script that prints alongside its results gets an Output view that keeps them in the order the server produced them. Learn more →
• Fix Query Editor — the suggestion popup no longer opens on its own in a freshly opened tab, or after a reconnect, database switch or IntelliSense refresh, when the schema finishes loading, and a list you opened before it loaded is refreshed in place. Learn more →
• Fix Performance and stability — typing in the SQL editor no longer lags while autocomplete prepares suggestions, most noticeably on MySQL and large schemas, and resuming a session whose connection is already open no longer freezes the window.

1.5.0 — 2026-09-19

Highlights: MetaInfo-driven autocomplete, a rebuilt Table Designer, and faster connects — get JSON-path / enum / loose-FK suggestions in the SQL editor, edit constraints, indexes, storage and partitioning from a single CREATE/ALTER TABLE buffer, and open connections without waiting on metadata.

• Improvement Results grids — a new Thousands separators setting (Settings → UI, or the right-click Number display submenu) renders numeric columns with locale separators, thin spaces or none. Learn more →
• Improvement Settings → UI — a new Interface scale control draws the whole app at 80–125%, and Windows now starts at 90%. Learn more →
• Feature Query Editor — Cmd/Ctrl+Shift+R, or Refresh on a database in the Object Explorer, re-reads the schema behind autocomplete so objects created by another client complete without a reconnect. Rollback transaction moved to Cmd/Ctrl+Shift+X. Learn more →
• Improvement Query Editor — a new Suggest while typing switch (Settings → Advanced → SQL autocomplete) keeps the suggestion popup closed until you press Ctrl+Space. Learn more →
• Improvement Query Editor — a new Enable IntelliSense switch (Settings → Advanced → SQL autocomplete) turns off autocomplete, hovers, signature help and live squiggles at once. Learn more →
• Feature Query Editor — inline type-mismatch warnings on comparisons such as WHERE total = 'free', plus hover-for-type on columns and function calls, both under Settings → Advanced → SQL autocomplete. Learn more →
• Feature Autocomplete — the SQL editor now suggests JSON paths, enum values and loose-FK joins from your MetaInfo declarations, and Schema Compare diffs JSON classifications.
• Feature Table Designer — constraints, indexes, storage and partitioning, and identity, generated and collated columns are now all edited from a single CREATE/ALTER TABLE buffer with a View SQL toggle. Learn more →
• Improvement Find References — now also finds hits inside stored procedures and triggers on MSSQL, PostgreSQL, MySQL and Oracle. Learn more →
• Improvement Peek References — Shift+F12 previews every referencing view, routine, trigger and constraint body inline, and the grouped list moved to a Find All References in Tab action. Learn more →
• Improvement Rename Symbol — F2 renames table aliases and CTE names in the buffer, and a table, view or column rename updates references in open query tabs on the same database. Learn more →
• Fix Query Editor — multi-statement scripts now execute correctly on every engine, including MySQL DELIMITER routines, SQLite triggers, Oracle PL/SQL blocks with RETURNING … INTO, and MSSQL GO batches.
• Improvement Autocomplete — the start of a WHERE, HAVING or ON clause now suggests columns and boolean functions instead of table names, routine completion is much faster on large scripts, and Enter accepts a suggestion only when it changes what you typed.
• Improvement Autocomplete — DDL, trigger, data-type, window, RETURNING and many other positions now offer exactly what fits, objects created earlier in the same script complete before a refresh, and after a GROUP BY only grouped columns, aggregates and aliases are offered. On large databases the schema loads in tiers so table names are ready within seconds, and the References index builds in the background without freezing the editor. Learn more →
• Improvement Autocomplete — within a tier, the table you are editing and your recently accepted completions float to the top, names already written in the current clause stop leading, and CREATE … name slots list schemas first. Learn more →
• Improvement SQL Server — IntelliSense and query execution now run fully in-house, and the bundled SQL Tools Service no longer launches on macOS or Linux.
• Fix Schema Compare, Table Designer and Database Blueprint — PostgreSQL extension-owned objects stay out of the diff, and table DDL with inline comments, trailing CREATE INDEX statements or attributes the designer cannot write back is read without dropping or corrupting columns. Learn more →
• Feature Query Editor — SQL/PGQ property graph support (beta) for Oracle 23ai+ and PostgreSQL 19, with GRAPH_TABLE syntax and schema-aware completions. Learn more →
• Fix Stability — fixed full-UI freezes after closing the crash report dialog and while saving a connection with a slow or locked macOS keychain.
• Fix Windows — SQL Server connections are more reliable: an interrupted SQL Tools Service install repairs itself, and a local instance with an auto-detected port connects over Shared Memory or Named Pipes.
• Feature Database Blueprint — a new Rebuild from .data.sql action on the missing-sidecar banner rebuilds data sidecars offline. Learn more →
• Feature Query Editor — live syntax-error squiggles for MySQL, Oracle, and SQLite. Learn more →
• Feature Settings → Beta Features — every beta feature is now a checkbox, so Database Blueprint, Cross-Engine Migration, Data Import, the PL/SQL Debugger, Agent Jobs and Package Explorer can be switched off. Learn more →
• Improvement Connecting is faster on every engine: validation is a single round trip and the Object Explorer loads the connection’s own database first. Learn more →
• Fix Find References and Rename — fixes for multi-database SQL Server and PostgreSQL connections, case-sensitive databases, and rewrites that lost schema qualifiers or aliases in dependent bodies. Learn more →
• Fix Oracle — tables with CLOB or NCLOB columns holding multibyte text open in Table Explorer again, and both grids show the whole value instead of a 4000-character preview. Learn more →
• Improvement SQL Notebooks — a Results / Text toggle above each cell’s output shows the rows as a plain text table with a Copy button. Learn more →

1.4.26 — 2026-09-06

• Feature Deadlock Analyzer — open or paste a SQL Server deadlock report (.xdl / XML), or read the deadlocks retained in a connection’s system_health session, and inspect the victim, processes, lock modes and owner/waiter graph. Reports are parsed locally and never uploaded. Learn more →
• Feature SQL Server — a new read-only Query Store workspace (right-click a database › Query Store…) compares two periods with execution-weighted averages, ranks candidate regressions and opens their plans in plan compare. Learn more →
• Fix Query Editor — very large scripts no longer crash the app, and scrolling with the inline Execute / Peek bar no longer freezes it. Learn more →
• Fix SQL Server — the first results page is no longer cut short, and connections via SQL Tools Service no longer re-send failed batches or fail with “invalid OwnerUri” after a service restart.
• Improvement AI Integrations — connected agents can now declare a column as JSON alongside enum, loose-FK and reference-table declarations, still gated by Allow AI to declare MetaInfo. Learn more →
• Feature Settings → UI → Appearance — a new Editor colors dialog offers five syntax-highlighting schemes plus a Custom one, with live previews, and applies the choice to every open SQL editor. Learn more →
• Improvement Connections — a failed connect now offers a one-click next step, Update user & password… for a failed sign-in or Edit connection… for an unreachable server. Learn more →
• Fix Oracle — a cancelled or abandoned query no longer poisons its connection, so the next query cannot fail with ORA-01013, and a busy connection pool no longer freezes the app.
• Improvement Query Editor and Table Explorer — pressing Stop again while it shows Stopping… forces the stop, which makes Stop work on an Oracle statement waiting behind another session’s lock. Learn more →
• Fix Connections — reconnecting ends an open transaction visibly instead of silently switching to auto-commit, Test Connection and Load databases use saved SSH secrets, and deleting a connection mid-connect can no longer let it reappear. Learn more →
• Improvement Connections — disconnecting, reconnecting, deleting or re-dialling a connection now cancels its running queries first on every engine, and releases notebook and transaction sessions held on it. Learn more →
• Improvement Connections — Reconnect is now in the right-click menu of every connection, not just SQL Server, and rebuilds the connection after a network change, VPN reconnect, laptop sleep or expired sign-in. Learn more →
• Fix Schema Compare — fixed a crash in the side-by-side DDL diff that also affected every other diff view in the app. Learn more →
• Fix Clone Table — each data-copy batch now runs in its own transaction on its own connection, so a rejected batch leaves no rows behind and two clones running at once never mix their rows. Learn more →
• Fix SQL Notebooks — on SQL Server, cells now auto-commit like on the other engines (created tables are visible elsewhere, COMMIT works, #temp tables survive), and a cell with several statements shows every result set as its own tab. Learn more →
• Improvement Pro trial — signing in from Settings, the start page or the trial dialog now offers the 14-day trial once when the account has no Pro subscription.

1.4.25 — 2026-08-29

• Feature Foreign-key columns can show the referenced row’s name next to the key — 3 · Pending instead of 3 — in grids, filters, and cell editing, while SQL, copy, and export keep the raw key. Declare one column as a lookup enum, mark the whole reference table once, or resolve names on demand for tables too big to cache; AI agents get the same metadata over MCP and can propose declarations behind a new approval setting, badged AI-created. Learn more → Read the announcement →
• Improvement Query Editor — error tips now offer a one-click next step: “Switch database…” opens the database selector when an object isn’t found in the current database, and “Find the blocking session” opens the Session Browser when a query is waiting on a lock. Learn more →
• Improvement Query Editor — the toolbar Execute button turns into “Selection” when a runnable statement is selected, whether the inline Execute / Peek bar is on or off. Learn more →
• Fix Pro trial — starting a trial no longer gets lost when sign-in finishes in the browser after the dialog was closed or the app restarted; the trial offer reappears once you’re signed in.
• Improvement Connections — Oracle connection errors now offer one-click fixes: an expired password (ORA-28001) can be reset right from the error notice, and an unknown service name (ORA-12514) offers to check which common service names the listener knows and retry with your pick. Learn more →
• Fix Table Explorer — the grid no longer flickers on load. Learn more →
• Fix Query Editor — the statement under the cursor is now recognised when it ends in a row-limiting clause (Oracle’s FETCH FIRST … ROWS ONLY, OFFSET … ROWS) or IS NULL, so its highlight and run button appear without selecting the whole statement first. Learn more →
• Improvement AI Integrations — connected agents can now read the schema comparison you have open: each Schema Compare tab’s current result is listed on the MCP compare snapshot, so an agent can fetch the differences or generate the sync script without re-running the comparison. Learn more →
• Fix Schema Compare — generated sync scripts now create and update views, procedures and functions after the table changes, so a new procedure or view that reads a column the same script adds no longer fails with “Invalid column name”. Learn more →
• Feature AI Integrations — connected agents can now export a results grid to CSV, Excel, JSON, Markdown or SQL INSERT for you, including the streaming “Export All to CSV” for huge result sets; the agent never picks the path, you choose the destination in the usual save dialog. Learn more →
• Fix jam-sql CLI — query now prints the table and CSV output it advertises; --output table and --output csv had been falling back to a raw JSON dump, and --max-rows / --timeout were being ignored. Learn more →
• Fix Query Editor — huge “Export All to CSV” runs on SQL Server no longer hit request timeouts: the file is now written server-side by SQL Tools Service (falling back automatically to the previous method if that fails), and a row that still can’t be read after retries is skipped with a warning and listed in a “Skipped rows” tab beside the results — a preview and a one-click jump for each missing row — instead of failing the whole export. Learn more →

1.4.24 — 2026-08-27

• Improvement Sessions — a new “Always start a new session” option (on the startup dialog and in Settings → Sessions) skips the resume prompt at launch and lands on the Start Page; previous sessions stay available from the toolbar Sessions button. Learn more →
• Improvement Query Editor — Oracle autocomplete now knows the 23ai/26ai SQL surface: QUALIFY, VECTOR_DISTANCE and the vector functions, DATEADD / DATEDIFF, and CREATE ASSERTION, each hint naming the Oracle version that accepts it. What's new in Oracle 26ai →
• Fix Query Editor — a huge CSV export no longer fails when the server times out on very large cells; it retries with smaller batches, and an incomplete export can be resumed. Learn more →

1.4.23 — 2026-08-26

• Feature Schema Compare — new “Ignore object owner” option (SQL Server): definitions differing only by the [dbo]. header qualifier no longer report as modified, offered right in the results when detected. Learn more →
• Feature Connections — Jam now spots saved connections from VS Code, SSMS, Azure Data Studio, DBeaver, MySQL Workbench, TablePlus, and ODBC, and offers one-click import from the start page and the New Connection dialog. Learn more →
• Feature Connections — import your Oracle connections straight from SQL Developer’s saved store or a connections.json export, service name / SID mapping included. Learn more →
• Feature Table Designer — SQL Server 2025's native JSON and VECTOR(n) column types are now available when designing tables. Learn more → What's new in SQL Server 2025 →
• Improvement Connections — failed connections now explain what went wrong and offer one-click fixes (e.g. retry trusting the server certificate), and query errors gained inline tips for common causes. Learn more →
• Fix SQL Server — queries no longer hang after laptop sleep or a dropped connection; stale pooled connections are detected and replaced within seconds.

1.4.22 — 2026-08-24

• Improvement Results grids — scrolling, cell selection, and column resizing are dramatically faster on large and wide result sets, in both the Query Editor and Table Explorer.
• Fix Schema Compare — Azure SQL targets are now correctly detected as supporting CREATE OR ALTER; no more false “predates 2016 SP1” notes or DROP+CREATE downgrades. Learn more →
• Feature Schema Compare — new “Ignore column collation” option, also offered right in the (now much shorter) collation banner; with it on, scripts never change a column’s collation. Learn more →
• Improvement Data Compare — a sampled comparison now says how many rows were not checked instead of claiming “no differences”, with a one-click full comparison. Learn more →
• Fix Command Palette — connecting from the palette shows connecting/connected/error feedback, and the pencil on a connection opens its edit dialog directly.
• Fix Table Explorer — pagination controls no longer shift while a page loads.

1.4.21 — 2026-08-22

• Feature SQL Server user-defined types are now first-class — they appear in the Object Explorer under Programmability → Types with Open definition and Script as CREATE / DROP, Schema Compare compares and scripts them in dependency order, and Database Blueprint emits and compares them. Learn more →
• Improvement Schema Compare — SQL Server comparisons read table metadata in a handful of set-based queries per side instead of six per table (5–15x faster on large databases, with per-side timing reported), and nvarchar/nchar lengths are now shown in characters rather than bytes. Learn more →
• Fix Fixes — copy actions work again on Linux, estimated execution plans on MySQL 8.3+ / 9.x render the full operator tree, and connecting to a SQL Server instance with many databases no longer stalls the Object Explorer.

1.4.20 — 2026-08-21

• Fix Query Editor — a multi-million-row “Export All to CSV” on SQL Server no longer fails with “Request timeout for query/subset” when the server takes a slow moment; slow batches now wait far longer and retry, and if an export still fails the rows already written are kept on disk instead of being deleted. Learn more →
• Improvement Query Editor — the CSV export progress toast now shows an estimated time remaining, says “still working” instead of freezing during a slow batch, adds a Show in folder button when done, and long exports show their progress on the dock / taskbar icon. Learn more →
• Fix Copying — copy actions no longer fail silently when the window loses focus mid-copy (e.g. alt-tabbing right after copying); all copies now go through the native clipboard.

1.4.19 — 2026-08-20

• Fix Schema Compare — the transaction-wrapped sync script failed instantly with Msg 3997 when executed inside Jam SQL Studio on SQL Server; the wrap now works in-app exactly as it already did in SSMS and sqlcmd. Learn more →
• Improvement Database Blueprint — the Git panel now lists every changed file (modified / new / deleted / conflicted); click one to preview it before committing. Learn more →

1.4.18 — 2026-08-13

• Feature Schema and data compare improvements — depth presets with saved defaults, shareable settings files, single-transaction sync scripts, member-level selection, Recently compared with pinning, Apply as INSERT, ~20x faster SQL Server comparisons, and a long run of script-correctness and disclosure fixes. Learn more → · Blog post →
• Feature Database Blueprint — “Apply schema to linked DBs…” compares the folder against every linked database in one pass and reports what each one’s script would add, change, or remove; nothing is executed for you. Learn more →
• Feature “Find usages” searches SQL definition text for a column or term across all five engines (a lead, not proof — it also matches comments and dynamic SQL), cross-checked on SQL Server and PostgreSQL against what the database catalog itself recorded; large or table-object dependency graphs also default to a readable tree view, and filtering the graph now hides non-matching nodes instead of just dimming them. Learn more →
• Feature Settings → Backup & Transfer — export and import your app settings and, separately, your saved connections to move your setup to another machine or share it with a teammate; exported connection secrets are passphrase-encrypted and never written in plain text. Learn more →
• Feature Toolbar — customize which buttons live on the primary toolbar versus the More ▾ menu, from Settings → UI → Toolbar. Learn more →
• Improvement Dependency Viewer — open a definition straight from the dependency list via a hover button or the right-click menu, and PostgreSQL lists now include the views and materialized views that read a table, which were silently missing. Learn more →
• Fix Database Blueprint — Apply schema no longer drops an object you excluded (single link, batch, or an AI agent over MCP), a linked database records its baseline instead of reporting drift its own refresh created, and a batch apply compares only what the blueprint covers. Learn more →
• Fix Connections — cancelling a connect or a connection test really stops it, and SSH host-key pins moved to ~/.ssh/jam_known_hosts (existing pins move on upgrade) so ssh-keygen works on your own known_hosts again. Learn more →
• Fix Engine fixes — Clone Table with data works on MySQL and Oracle, a PostgreSQL connection is usable straight after a script fails inside a transaction, and Oracle PL/SQL breakpoints can be set again. Learn more →
• Fix Query Editor and app UI — the execute confirmation reads only what the engine will run, so a comment no longer triggers a destructive warning; a menu opened right after results stays open; More-menu items stay enabled with several connections; execution plans survive a narrow window; and quitting no longer loops error dialogs. Learn more →

1.4.17 — 2026-07-24

• Improvement Spatial Explorer — layer label columns now render on the map, a zoom-to-fit control restores the all-layers view, and the Add Layer dialog and layer cards got usability fixes. Learn more →
• Improvement Export — the completion notice can reveal the exported file in your file manager, and Excel now leads the export menus.
• Fix Schema Compare — adding a missing column no longer generates computed-column syntax (AS (NULL)) instead of the real data type on SQL Server connections.
• Improvement Connections — a new “Limit connection to selected database” option scopes Object Explorer, database pickers, and AI schema export to a single database, and compare/migration dialogs now default to the connection’s saved database. Learn more →
• Improvement Connections — Detect local db’s now finds native SQL Server instances (SQLEXPRESS, LocalDB) on Windows alongside Docker containers. Learn more →
• Improvement AI Workspace — asks for confirmation (with target database and an explanation of what gets exported) before setting up, and the setup overlay gains a Cancel button.

1.4.16 — 2026-07-19

• Fix SQL Server — local instances reached through SQL Tools Service no longer report “No databases found” when loading databases or browsing the Object Explorer.
• Feature Data Import — a new wizard imports CSV, TSV, Excel, and JSON/NDJSON files into a new or existing table across all five engines, with column mapping and type control, fixed-value columns, row filters, a generate-script option, and optional post-import metadata suggestions. Learn more →
• Improvement Connections — smoother adding and editing: reliable Test Connection and Load databases, a clear notice when databases can’t be listed, and no ~30-second stall on local SQL Server instances.

1.4.15 — 2026-07-09

• Feature Azure Data Explorer (KQL) — connect to ADX clusters and App Insights/Log Analytics, run KQL with IntelliSense in the editor and SQL Notebooks, browse tables read-only with enum, JSON-path and loose-foreign-key filter chips, and chart | render results. Learn more →
• Feature Connections — Browse Azure picks ADX clusters, App Insights, Log Analytics, Azure SQL and PostgreSQL flexible servers straight from your Azure account (Add Connection + Import). Learn more →
• Feature Object Explorer — Oracle 23ai SQL/PGQ property graphs appear under a Property Graphs node with Script as CREATE / DROP and a GRAPH_TABLE starter-query template. Learn more →
• Feature PostgreSQL 19 (beta) support — SQL/PGQ property graphs, REPACK maintenance scripts, partition MERGE/SPLIT, autovacuum scores, EXPLAIN IO statistics, case-insensitive JSON filters, and more. Read the blog post →
• Fix SQL Notebooks — fixed Oracle connections failing to run any cell (“execute is not a function”); notebooks now fully support Oracle with pinned sessions.
• Feature Object Explorer — pin Table Explorer views, queries, and notebooks to the connection tree and reopen them with a double-click. Learn more →
• Feature Spatial / PostGIS — map geometry & geography columns across PostgreSQL, MySQL, SQL Server, Oracle and SQLite with peek maps, a Query Editor Map view, a Table Explorer map pane with bounding-box, distance and draw-an-area spatial filters, a Spatial Explorer workspace, and curved-geometry rendering (basemap on by default). Learn more →
• Fix Schema Compare — generated sync scripts no longer append a semicolon to SQL Server procedure, function, and view definitions, so a re-compare after applying no longer reports the same objects as modified.

1.4.14 — 2026-07-04

• Feature Connections — paste a connection string (ADO.NET, URL, JDBC, EZConnect, libpq, SQLite path) into the New Connection dialog or the command palette to prefill the form. Learn more →
• Feature Connections — import your saved connections in one click from other database tools (Azure Data Studio, VS Code, SSMS, DBeaver, DataGrip, TablePlus, MySQL Workbench, Navicat, pgAdmin) and standard config files (tnsnames.ora, pg_service.conf, .my.cnf, ODBC), via the new Import… menu, the command palette, or the start page. Learn more →
• Feature Connections — detect local Postgres, MySQL/MariaDB, SQL Server, and Oracle databases running in Docker and add them in one click, with credentials read straight from the container environment. Learn more →
• Fix Notebook — Markdown headings in the cell preview now render at their proper heading size instead of appearing as plain body text.
• Fix Schema Compare — script generation and formatting fixes.
  Show more info…

  • Select all now selects only the objects visible under the active filter.
  • Generated scripts include computed column definitions.
  • Re-comparing after applying a generated script no longer flags procedures and views as modified (trailing semicolon).
  • SQL formatting keeps the required parentheses around CREATE FUNCTION parameters.
• Improvement Query tabs — a script that scripts an object (e.g. CREATE OR ALTER PROCEDURE) is now titled after the object, like GetUsers(Create/Alter), even when a leading USE/GO preamble precedes it.
• Fix Crashes — brief network interruptions (Wi-Fi switch, sleep/wake, VPN) no longer show a crash dialog, and a repeating crash can no longer spam dialogs.
• Feature Table Explorer — JSON path suggestions in the filter chip's peek popover now match the grid's active filters (with a whole-column escape), so polymorphic JSON columns suggest the right variant's properties. Learn more →

1.4.13 — 2026-06-16

• Improvement Database Blueprint — Sync Data now round-trips Unicode text, very large integers, and MySQL date/backslash values losslessly, and Refresh from DB keeps the data sidecar files of still-selected tables. Failure reporting is clearer throughout: the git panel blocks committing with unresolved merge conflicts, drift-scan and git-status errors surface properly, and disabled buttons explain why.
• Fix Fixed crashes when viewing a Blueprint file diff after reconnecting, switching between Schema Compare object diffs, re-running a query tab twice in quick succession, exporting results that contain an invalid date, rapidly switching between query tabs (a rare editor render crash), and a phantom “Query timeout” crash dialog that could appear seconds after a SQL Server connection failure.

1.4.12 — 2026-06-13

• Improvement Improved timeout handling for SQL Server queries and connections.
• Feature Schema Compare — limited support for comparing two databases on different engines.
  Show more info…

  Point Schema Compare at a source and target on different engines (for example SQL Server vs PostgreSQL) and it compares tables in full on a canonical type model — columns, types, nullability, keys, constraints, and indexes — plus a name-presence inventory of views, procedures, functions, and triggers so you can see what is missing on each side. Object bodies (T-SQL vs PL/pgSQL) are never auto-translated, and sequences are not compared across engines.

  Read the docs Read the blog post
• Feature Cross-engine migration — copy a table’s full schema and data to a connection of any engine (e.g. SQL Server → PostgreSQL).
  Show more info…

  New Migrate Table and Migrate all tables to Connection… actions copy a table’s full schema — types, identity, defaults, CHECK/UNIQUE, foreign keys (with ON DELETE/UPDATE), filtered + covering indexes, computed columns, and user-defined alias types — plus its data to a connection of any engine. The migration runs in its own workspace tab with live per-table progress, streams data in chunks so large tables never load into memory, and can be cancelled mid-run with a prompt to drop or keep partially-copied tables. A Preview scripts the migration and shows the exact row count it will copy (a 50-row sample, with a banner noting the rest is streamed chunk by chunk), and a “needs manual follow-up” checklist flags anything engine-specific.

  Read the docs Read the blog post
• Fix Schema Compare (SQL Server) — the generated synchronization script now includes ALTER COLUMN statements for datetime2/datetimeoffset/time precision changes that the overview flagged as “length changed” but the script previously dropped.

1.4.11 — 2026-06-03

• Fix SSH issue resolved.

1.4.10 — 2026-05-25

• Feature SSH Tunneling — connect through a bastion without manual port forwarding.
  For PostgreSQL, MySQL, Oracle, and SQL Server databases sitting behind a firewall, check Connect via SSH tunnel in the connection dialog and fill in the SSH host, port, user, and auth method. Supports SSH agent, private-key (with optional keychain-saved passphrase), and password auth (also keychain-saveable). Start typing a Host alias from ~/.ssh/config to auto-fill host, user, port, and key file. Test Connection is stepwise — it reports the SSH leg and the database leg separately so you can tell exactly which side needs attention.

  Read the docs
• Feature Object Explorer — pin databases, schemas, folders, and objects.
  Pin databases, schema containers, folders (Tables / Views / Stored Procedures / Functions), and individual objects to a list above Databases under each connection. Hover any pinnable row and click the outline pin on the right; the icon becomes a filled pin that stays visible. Pinned rows from the same database are grouped into subtle tinted areas with a tiny db-name header (a pinned database with no same-DB siblings renders standalone; single-accessible-DB connections hide the header). Pinned rows are expandable shortcuts — click the chevron and they drill into the same children as the canonical tree. Drag a pinned row by the grip handle on the left to reorder; dropping a pin from one database into the middle of another database's pins simply splits the grouping in place — the pin keeps its database. When pins exist, Databases no longer auto-expands on connect, and the sidebar search excludes the pinned shortcuts so a pinned row never shows up twice. Removed-or-missing targets show lightly greyed when disconnected and strongly greyed with a "no longer present in the database" tooltip when the parent listing has loaded without them.

  Read the docs
• Feature Database Blueprint (beta) — schema + data as a folder of .sql files.
  Materialize a database's full schema and reference data as a folder of .sql files kept in two-way sync with one or more linked databases — with Refresh from DB, three-way merge, Apply folder to DB, captured row data, per-link MetaInfo, and a built-in Git panel. Supported on MSSQL, PostgreSQL, MySQL, Oracle, and SQLite; Pro is required for databases with more than 200 objects.

  Read the docs Read the blog post
• Improvement Data Compare — clearer empty/error states and reliability fixes.
  A bundle of clarity and correctness improvements:

  • A comparison with no differences shows an explicit “Source and target data has no differences” message instead of an empty grid.
  • A failed comparison (missing column, inaccessible table, dropped connection) now shows the error in the results area instead of silently returning to the empty “select tables” state.
  • Switching the compared table re-detects the value/key column mappings, so you no longer get blank Value Columns or an “Invalid column name” failure.
  • Collation-independent merge-join ordering eliminates phantom inserts/deletes on binary collations (e.g. PostgreSQL COLLATE "C").
  • Oracle row-count estimation reads both upper- and lowercase cnt aliases, so the Personal-mode row-count cap is no longer silently bypassed.

  Read the docs
• Feature Table Explorer — foreign-key navigation breadcrumb.
  Drill through foreign keys without leaving the tab:

  • Foreign-key clicks drill into the referenced row in the same tab via a clickable breadcrumb tree; Cmd-click (Ctrl-click on Windows / Linux) or the … menu still opens a new tab.
  • Loose foreign keys are first-class hops, navigable identically to declared FKs — including the peek popover and mini-grid icon column.
  • Pure m2m join tables auto-collapse from the breadcrumb (e.g. orders → order_items → products renders as orders › products); right-click a chip and pick Show join tables to override per-table.
  • Cmd+← Cmd+→ Cmd+↑ Cmd+↓ (Ctrl on Windows / Linux) traverse the breadcrumb tree.

  Read the docs Read the blog post
• Feature Table Explorer — Single-Row Details View.
  A new full-workspace view shows row cells (categorized into Identity / Profile / Foreign keys / State / Timestamps / Counters / Metadata) and related (inbound-FK) data side-by-side, with lazy-loaded Related Data sections.
• Feature Cell edit — enum + FK pickers.
  Editing a cell in a declared/native enum column now shows a values peek with live filtering (free text always works as a fallback). Editing a cell in a real or loose foreign-key column offers a Search row in … link that opens the same row picker used by filters; polymorphic loose FKs list one entry per matching declaration. Both pickers work in the Query Editor results grid and in Table Explorer.
• Feature MCP & CLI — add connections from agents.
  AI agents can now add new database connections via the new connections_add MCP tool and jam-sql connection add CLI command. Off by default; enable in Settings → AI Integrations → Allow AI to add new connections (Deny / Confirm each / Allow). The tool test-connects before saving and encrypts the password at rest.

  Read the docs Read the blog post
• Fix Schema Compare — loud failure on per-object fetch errors.
  If a per-object metadata or definition fetch errors mid-comparison (e.g. a stale connection after macOS sleep), Schema Compare now surfaces a clear error naming the failing object instead of silently dropping it from the snapshot. Previously the missing object would be flagged "only in source" on every retry-free run, and the generated CREATE script would fail with MSSQL error 2714 ("There is already an object named … in the database").
• Fix Destructive-query confirmation — two tiers, routine bodies ignored.
  CREATE/ALTER PROCEDURE, FUNCTION, TRIGGER, and PACKAGE/TYPE bodies no longer false-trigger the dialog when their bodies happen to contain DELETE, TRUNCATE, or DROP keywords (the routine wrapper is inert at submission). A top-level DROP PROCEDURE/FUNCTION/TRIGGER/VIEW now shows a milder, distinctly-worded confirmation — the strong "permanent data destruction" warning is reserved for actual data destruction (DROP TABLE, TRUNCATE, DELETE/UPDATE without WHERE). Applies to MSSQL, PostgreSQL, MySQL, Oracle, and SQLite.

  Read the blog post
• Improvement Query Editor — long-running queries no longer feel stuck.
  The default query timeout is raised from 15 s to 5 min (set Settings > Advanced > Query timeout to 0 for no client-side limit); existing installs with the legacy 15 s default are auto-migrated to 5 min on next launch. After 8 seconds the execution-time timer in the status bar turns amber and pulses, and the “Executing query…” indicator above the results grid changes to “Executing query… taking longer” with a one-click Stop — nothing shifts in the toolbar. Multi-batch CREATE OR ALTER and schema-compare apply scripts on SQL Server now execute batch-by-batch through the direct driver so they aren't throttled by SSTS notification overhead.
• Fix Licensing — sign-ins stay signed in, with an honest “Verify Now”.
  Fixed a regression where signing in no longer kept you signed in: the auth request stopped requesting offline_access, so no refresh token was issued and your Pro session asked for re-authentication about an hour after every sign-in. “Verify Now” on the offline-license banner no longer silently does nothing when your session has lapsed — it reports the outcome and, when the session can’t be refreshed, prompts you to sign in again. A stale Pro session now surfaces a clear re-logon banner (sessions otherwise stay sticky — no routine logouts), and proactive token renewal runs in the main process so sessions survive sleep/wake.
• Feature Object Explorer — schema-node context menu.
  Schema nodes now have Script New (Table / View / Stored Procedure / Function templates scoped to the schema) and Script Schema As (CREATE / DROP SCHEMA on SQL Server and PostgreSQL, plus Script all objects to script every table, view, procedure, and function in the schema).

1.4.9 — 2026-05-21

Highlights: JSON & enum column support and filtered loose foreign keys — declare columns as JSON or enum, peek JSON shape, loose FKs on JSON paths, plus source/target filter scoping for polymorphic and soft-delete-aware references

• Feature Filtered loose foreign keys. Loose FKs now support optional source and target filters. A source filter scopes when the FK applies (e.g. polymorphic associations: commentable_id → posts.id only when commentable_type = 'Post'). A target filter narrows valid target rows (e.g. soft-delete-aware: deleted_at IS NULL). A new peek pane in the editor shows live counts and a 5-row sample so you can validate filters by eye.
• Feature JSON column support. From the Table Explorer filter chip, a new json operator works on native JSON columns and on long-text columns you declare as JSON, with property predicates (=, !=, contains, >, ≥, <, ≤, existence, validity), JSONPath wildcards ($.items[*].qty), and any/all aggregate sub-operators. An eye-icon button next to the JSONPath input peeks the JSON shape — a popover listing every property path observed for that column. Loose foreign keys can also be declared on JSON property paths so a value inside a JSON document behaves like a real FK. Right-click a declared column to open a JSON details dialog with the inferred property paths, a Refresh from DB re-sample, an optional inference filter, and a Remove JSON declaration action — the same Refresh + Filter affordance also appears in the MetaInfo manager, Settings → Meta Info, and the Declare as JSON confirmation.
• Feature Enum column support. Declare a column as an enum and its filter chip becomes a values dropdown — sourced from native enum types, CHECK constraints, or sampled distinct values, on all 5 engines. Header glyphs and an Enum values details dialog manage declarations, which round-trip through MetaInfo export/import. Learn more →
• Feature Filter Wizard — Peek matching rows. A new eye-icon button in every FilterWizard header (Table Explorer, JSON details, Declare-as-JSON) runs the current filters as a SELECT * with a 50-row cap against the underlying table and shows the matching rows in an inline popover. Useful for sanity-checking a filter before sampling JSON structure or exporting filtered data.
• Feature Table Explorer filters — multiple filters on the same column. You can now stack two or more filters on a single column (e.g. created_at ≥ … AND created_at < …, or two different json property = predicates on the same JSON column), which previously was blocked by a “one filter per column” rule.
• Improvement Schema Compare — formatting and clearer diff UI. Routine/view/trigger DDL is now formatted before comparison so indentation- or keyword-case-only drift no longer shows as Modified (toggle Format SQL during comparison, or flip per-diff with the Formatted / Raw pill). The diff reads Source-on-left with connection/database labels, a direction toggle generates the sync script either way (Source → Target / Target → Source) without re-running, and the Script Preview dialog has a split-button Open & Execute action.
• Improvement Results grid — more consistent copy. Ctrl+C on a multi-cell selection now copies both plain text and a formatted HTML table, so pasting into Teams, Outlook, or Word renders a real table. A new Copy as HTML option is also available in the copy-to-clipboard menu (both Query Editor and Table Explorer).
• Improvement JSON column ergonomics. Header glyphs now show three distinct, clickable states — a blue {} for columns with a JSON declaration, a gray {} for undeclared native JSON columns, and a gray {}? for long-text columns whose rows look like JSON; clicking the blue glyph opens the JSON details inspector, either gray glyph opens the declare dialog, and a Declare as JSON CTA appears atop the Expanded Value dialog when a cell parses as JSON. Native json / jsonb columns can now carry a declaration too — it attaches path/loose-FK metadata without changing SQL emission. On SQL Server, filters that rely on OPENJSON (wildcard paths, any_* / all_* / is empty) now detect database COMPATIBILITY_LEVEL < 130, warn inline with a Recheck link, keep scalar predicates working via JSON_VALUE / ISJSON, and suggest ALTER DATABASE [<db>] SET COMPATIBILITY_LEVEL = 130; when an OPENJSON error surfaces.
• Improvement Table Explorer — drag-and-drop column reordering. Drag a column header to rearrange columns in the grid; the new order is saved per tab and restored on the next app launch.

1.4.8 — 2026-05-10

• Improvement Schema Compare — improved diff UI. Table diffs now surface dependent-object changes (indexes, foreign keys, triggers) and detect column, table-option, and partition differences.
• Fix Schema Compare — schema filter. The schema filter in the setup dialog now correctly narrows comparisons by schema.
• Improvement Connection and database listing. Clearer error messages when something goes wrong, with an option to send a redacted diagnostic report.

1.4.7 — 2026-05-06

• Improvement Better diagnostics when listing databases fails — click Show details to see the real cause, and optionally send a redacted diagnostic report.

1.4.6 — 2026-05-04

Highlights: Schema Compare overview, recently compared shortcuts, and stability fixes

• Feature Schema Compare overview. A new high-level summary of a comparison run — total counts of added, removed, and changed objects grouped by category, with object-level cards you can drill into without leaving the overview.
• Improvement Schema Compare — Recently compared. The setup dialog now remembers source/target databases from previous comparisons and surfaces them at the bottom of the dialog. Pick the most recent run with one click; expand to see older comparisons, with a search box (visible when there are two or more) that filters by connection or database name. Each entry can be removed individually.
• Fix Schema Compare — stability. Stability fixes for the comparison run, including better error reporting when a comparison fails to start.

1.4.5 — 2026-05-01

Highlights: Loose foreign keys — declare cross-table relationships even when the database has no FK constraint

• Feature Microsoft Entra ID (Interactive Browser). New MSSQL auth mode that opens your default browser for a standard OAuth sign-in.
  
  Use it when your tenant blocks the Device Code flow, or to skip entering a user code. Cached sign-in and Tenant ID override apply to both Entra modes.
• Feature Loose foreign keys. Declare cross-table relationships even when the database has no FK constraint.
  
  Pick lookup on any column in Table Explorer or Data Profiling filters; the picker pre-fills an inferred target. Once confirmed, the column behaves like a real FK.
• Feature Loose-FK cell links. Result grids render loose-FK values as clickable links — teal text with a dashed underline and a chain icon, visually distinct from real FKs.
  
  Click opens the row-preview popover with a “Clear loose relation” action. Works in Query Editor results and Table Explorer.
• Feature Schema Overview & Dependency Viewer. Declared loose relationships render as dashed blue edges with a “Loose” badge on connected nodes, so user-declared references stay visually distinct from enforced ones.
• Feature Row Details — loose inbound. The Related-data tab now lists inbound loose-FK rows alongside real-FK inbound, each marked with a “Loose” badge so you can navigate declared parents and children from the same panel.
• Feature MetaInfo manager dialog. Open from the Link2 icon in the Table Explorer toolbar or by right-clicking a database in the Object Explorer (“Manage meta info…”). List/remove declarations, or Export/Import the whole MetaInfo file as JSON to share across machines.
  
  MetaInfo is the foundation for future per-database metadata (table descriptions, AI context, tags).

1.4.4 — 2026-04-30

Highlights: Data profiling, foreign-key lookup picker, and a tidier query editor

• Feature Data Profiling workspace. Inspect any column or table without writing SQL. Right-click a column or table in the Object Explorer and choose Profile data to open a dedicated tab with summary stats, histograms, and top values.
• Feature Foreign-key lookup picker in Table Explorer. Filter FK columns without typing IDs — pick a row from the parent table via a searchable dialog with per-column filters and unbounded FK drill-down.
• Improvement Table Explorer. Streaming row loads, page sizes up to 10,000, parallel data + COUNT queries, “Add to filter” on cell right-click, and a redesigned pagination strip with inline progress.
• Improvement Inline toolbar is now optional. The floating Execute / Peek bar above the cursor statement is off by default. Selection-runnable SQL is surfaced through the toolbar Execute button (which relabels to “Selection”), and the cursor statement gets two small gutter icon buttons next to the line numbers. Re-enable the floating bar from Settings → UI if you prefer the old behaviour.

1.4.3 — 2026-04-24

Highlights: Vertical tabs and a collapsible results pane

• Feature Vertical tabs. Optional vertical layout for the Workspace tab bar — toggle via the new dropdown on the tab bar or Settings → UI. Orientation and column width persist across sessions.
• Feature Collapse the Results pane. Hide the Results / Messages / Plan / Chart pane to give the editor full height. Use the chevron on the right side of the results tab bar (next to the zoom controls), Cmd/Ctrl+J, or “Toggle Results Pane” in the Command Palette. Each query tab remembers its own collapsed state.
• Improvement Inline toolbar — shows on any selection. The floating Execute / Peek buttons now appear for arbitrary text selections, not just detected statements.
• Improvement External file-change detection. Open query files are now watched on disk — when a file is modified outside Jam SQL Studio, the editor picks up the change and offers to reload.

1.4.2 — 2026-04-21

Highlights: Inline Query Toolbar and Object Explorer schema grouping

• Feature Inline Query Toolbar. Floating Execute and Peek buttons appear next to the statement under the cursor and on text selections, with smart placement that avoids overlapping code. Toggle via the Query Editor options menu ("Inline toolbar on cursor").
• Feature Object Explorer — Group by schema. When a database has multiple schemas, schemas now appear as top-level folders in the sidebar with Tables, Views, and Programmability nested inside each one. Kicks in automatically for databases with more than 1 schema and more than 15 objects; switch between Auto / Always / Never in Settings → UI → Object Explorer.
• Improvement Query Editor — Configurable tab size. Pick 2, 4, or 8 spaces in Settings → UI → Editor; applies to the Tab key in all query tabs.
• Fix Status bar — query execution time now refreshes and settles correctly in the status bar when a query finishes.
• Fix IntelliSense / auto-complete — assorted fixes for SQL completion accuracy and stability.

1.4.1 — 2026-04-15

Highlights: Large query results — stream millions of rows without hitting the wall

• Feature Large query results — the 50K row cap is gone; stream millions of rows with windowed virtualization, a live population progress bar, and cancel support
• Feature Streaming CSV export — send multi-million row result sets straight to disk with progress tracking
• Improvement Server-side sort and filter on windowed results, full-fidelity clipboard copy, and pin-as-clone for large result tabs
• Fix Chart rendering fix

1.4.0 — 2026-04-05

Highlights: Oracle PL/SQL Debugger, SQL Server Agent Jobs Manager, and Query Editor power features

• Feature Oracle PL/SQL Debugger — step-through debugging for procedures, functions, packages, triggers, and anonymous blocks with breakpoints, variable inspection, call stack, watch expressions, and AI Chat integration (first full PL/SQL debugger on macOS and Linux)
• Feature SQL Server Agent Jobs Manager — browse, run, stop, create, and edit jobs with dashboard, step editor, schedule builder, plus Operators, Alerts, Proxies, and Error Logs management
• Improvement Column Profiling — null %, distinct count, min/max, avg in results grid headers
• Improvement Peek Results — preview SELECT results in a floating panel
• Improvement FK navigation in query results — click foreign key values to jump to referenced rows
• Improvement Connection Color Theming — color-code connections to distinguish prod/staging at a glance
• Improvement Column Inlay Hints — ghost column names in INSERT VALUES and SELECT * expansion
• Improvement Client-Side Result Filtering — filter row for instant search without re-executing
• Improvement Copy/Export as INSERT — engine-aware INSERT statements for MSSQL, MySQL, Oracle, PostgreSQL
• Improvement Quick WHERE Builder — right-click a cell to append it as a WHERE condition
• Improvement Pin Results — pin result sets so they survive subsequent query runs
• Improvement Smart Query History Search — full-text search with filters (Ctrl/Cmd+Shift+Y)
• Improvement Function Parameter Hints — signature help for function/procedure calls across all engines
• Improvement Package Explorer (Oracle) — browse, search, pin, and edit PL/SQL packages across schemas
• Improvement Cell aggregate bar, zoom controls, and column pinning in the results grid
• Improvement F5 shortcut executes the current query; Oracle packages searchable in command palette

1.3.2 — 2026-03-19

AI Agent Skill Support — one command to connect any AI agent

• Feature AI Agent Skill — run jam-sql add-skill to teach Claude Code, Cursor, Copilot, Codex, Windsurf, and 20+ other AI agents how to use Jam SQL Studio
• Feature CLI pairing — jam-sql pair securely connects the CLI to the running app via challenge-response (no manual token copying)
• Feature CLI auto-install — the app bundles the jam-sql CLI and installs it to PATH on every launch, always in sync with the app version
• Feature App launch from CLI — jam-sql launch starts Jam SQL Studio if not running; jam-sql pair offers to launch automatically
• Feature App status endpoint — CLI detects blocking dialogs (sessions, trial) and guides the user to dismiss them
• Improvement MCP discovery file written on every app start (even when MCP is disabled) so the CLI always knows the app is running

1.3.1 — 2026-03-18

• Fix Fixed SQL Tools Service download failing behind corporate proxies and firewalls (curl error 35) by adding TLS revocation check bypass and Electron net module fallback

1.3.0 — 2026-03-15

Highlights: Oracle Database Support, Command Palette, Multi-Engine DBA Tools

• Feature Oracle Database support — connect to Oracle databases with full Object Explorer, autocomplete, scripting, editable query results, and Security Manager
• Feature Command Palette — quickly search database objects, switch connections, and navigate workspaces with keyboard shortcuts (Ctrl/Cmd+P)
• Feature Session Browser — monitor active sessions, view locks and wait events, and kill runaway queries across Oracle, SQL Server, PostgreSQL, and MySQL
• Feature Performance Dashboard — real-time performance counters, top SQL, wait statistics, memory usage, and error logs for all four engines
• Feature Tablespace Manager — Oracle tablespace usage visualization, datafile details, I/O statistics, and undo monitoring
• Feature Filegroup Manager — SQL Server filegroup layout, database file details, I/O statistics, and ALTER DATABASE script generation

1.2.3 — 2026-03-02

• Fix Fixed Codex CLI finding issues

1.2.2 — 2026-02-26

Highlights: Table sub-objects in Object Explorer, connection & performance fixes

• Feature Object Explorer now shows Keys, Indexes, Constraints, Statistics, and Triggers under each table with Script as DDL support
• Improvement Switching connections preserves the active database when a database with the same name exists on the new server
• Fix Fixed query editor excessive CPU usage when no results are present

1.2.1 — 2026-02-23

Highlights: Codex CLI integration, Charts in Notebooks

• Feature Codex CLI integration for AI Chat
• Feature Charts in SQL Notebooks — visualize query results with interactive charts
• Improvement Charting enhancements across Query Editor and Notebooks
• Improvement Copy object name from context menu in Object Explorer
• Fix PostgreSQL autocomplete fix
• Fix MS SQL IntelliSense restore fix

1.2.0 — 2026-02-12

Highlights: SQL Notebooks, AI Chat

• Feature SQL Notebooks — interactive notebooks with SQL cells, Markdown documentation, and inline results
  • Import .ipynb files from Azure Data Studio and Polyglot Notebooks
  • Jupyter-style keyboard shortcuts, drag-and-drop cell reordering, and Run All
• Feature AI Chat — conversational AI sidebar powered by Claude Code with full database context
  • Available in Query Editor and SQL Notebooks — ask questions, generate queries, and explore your schema
  • Type @ to reference tables, views, and procedures directly in your conversations

1.1.1 — 2026-02-11

• Fix Fixed drag & drop of SQL files not working (file path not readable)

1.1.0 — 2026-02-10

Highlights: MySQL support, Editable Query Results, Transaction Management, Clone Database

• Feature MySQL support — connect to MySQL databases with full autocomplete, schema overview, and browser mode
• Feature Editable Query Results — edit result values directly in the query editor grid
• Feature Transaction Management — explicit transaction control (BEGIN, COMMIT, ROLLBACK) in the query editor
• Feature Script Management — manage and organize SQL scripts
• Feature Clone Database — clone an existing database with schema and data
• Feature File Drag & Drop — drag and drop SQL files to open them
• Improvement PostgreSQL and MySQL multiple resultset handling
• Improvement New connections appear at the top of the list
• Fix Query editor performance improvements
• Fix Fixed join results displaying incorrectly when columns share the same name
• Fix Table Explorer and Expanded Value Dialog icon fixes

1.0.8 — 2026-02-06

Highlights: What's New dialog and Expanded Value Dialog

• Feature What's New dialog — see recent changes after each update
• Feature Expanded Value Dialog — view and edit JSON columns with formatted syntax highlighting or multi-line plain text