Last updated: 2026-04-15

Changelog

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

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