Last updated: 2026-07-15

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 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+, PostgreSQL 19+) — 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+ and PostgreSQL 19+ 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. One piece of dedicated tooling remains on the roadmap:

• IntelliSense — GRAPH_TABLE and MATCH-pattern completions, planned as part of the upcoming autocomplete overhaul

Frequently asked questions