Last updated: 2026-09-26

Next Up

Here's what we're working on for the next release of Jam SQL Studio.

Recently Shipped

These features have landed in recent releases:

• Spatial / PostGIS — geometry and geography columns render on interactive maps across PostgreSQL/PostGIS, MySQL, SQL Server, Oracle and SQLite: a peek map in the grid, a Query Editor Map view, a Table Explorer map pane with spatial filters, and a layered Spatial Explorer workspace. See the Spatial guide
• Azure Storage — connect to storage accounts, a SAS-scoped resource or the Azurite emulator, upload, download and delete blobs as background transfers, preview and edit files in a pane next to the list, edit blob properties and generate SAS credentials, work with queue messages, and browse and edit Table entities. See the Azure Storage guide
• Azure Data Explorer (Kusto / KQL) — connect to ADX clusters and App Insights/Log Analytics proxies, run KQL with IntelliSense, browse tables read-only, and chart | render results. See the Kusto / KQL guide
• Oracle Support — Full Oracle Database support with IntelliSense, Table Explorer, Schema Compare, Data Compare, and all existing tools
• Command Palette — Quick access to all app actions via a searchable command palette (Ctrl+Shift+P / Cmd+Shift+P)
• Multi-Engine DBA Tools — Session Browser, Performance Dashboard, Tablespace Manager (Oracle), and Filegroup Manager (SQL Server) for monitoring and managing databases across Oracle, SQL Server, PostgreSQL, and MySQL
• SQL Notebooks — Jupyter-style notebooks combining executable SQL and JavaScript cells with Markdown documentation, saved as standard .ipynb files
• AI Chat — Built-in AI chat panel powered by your locally installed Claude CLI with full MCP database access, streaming responses, and multi-turn conversations
• MySQL & MariaDB Support — First-class support for MySQL 5.7+/8.x and MariaDB 10.x/11.x with IntelliSense, Table Explorer, Schema Compare, Data Compare, and all existing tools
• Script Management — Scripts panel with recent/pinned scripts, mounted folders, and quick open
• Transaction Management — Manual transactions with commit/rollback, auto-commit toggle, visual indicators, and safety warnings
• Property Graphs in Object Explorer (Oracle 23ai+) — browse SQL property graphs, script CREATE/DROP, and scaffold GRAPH_TABLE queries

Property Graphs (SQL/PGQ)

SQL/PGQ — the SQL:2023 property graph extension — works in Jam SQL Studio as pass-through SQL, and on Oracle 23ai+ the Object Explorer lists property graphs per schema under a Property Graphs node, with Script as CREATE / DROP and a GRAPH_TABLE starter query pre-filled with labels and sample properties from the graph's definition — see the Scripting guide. GRAPH_TABLE and MATCH-pattern IntelliSense has shipped for Oracle 23ai+ — see the SQL/PGQ Property Graph Intellisense section of the Query Editor guide. PostgreSQL connections get the same node and completions, but only the PostgreSQL 19 beta 1–3 builds could create property graphs: PostgreSQL 19 Beta 4 reverted SQL/PGQ on September 24, 2026, so PostgreSQL 19 will be released without it.

One piece of dedicated tooling remains on the roadmap:

• Graph visualization — rendering GRAPH_TABLE results as an interactive node/edge diagram

Frequently asked questions