About Jam SQL Studio

Jam SQL Studio is a desktop SQL IDE that lets developers, DBAs and data engineers write queries, edit data, compare schemas and run DBA tasks on SQL Server, PostgreSQL, MySQL, Oracle and SQLite, and query Azure Data Explorer in KQL, from one app on macOS, Windows and Linux.

It is made by an independent, self-funded software studio in Poland. The Personal tier is free for non-commercial use; Pro costs $9.99 per month or $99 per year and adds a commercial-use license, removes the size caps on bulk operations and adds AI Workspace sync.

What Jam SQL Studio does

Query editor with IntelliSense

The editor completes table, column, function and keyword names in each engine's own dialect (T-SQL, PostgreSQL, MySQL, Oracle SQL and PL/SQL, SQLite and KQL) and marks syntax errors as you type. Results open in a grid you can sort, filter, copy in several formats and export. See the Query Editor docs.

Table Explorer and data editing

Table Explorer opens a table or view as a filterable, sortable grid. You can edit cells, add rows and delete rows in place, then save the changes to the database; editing needs a primary key on the table.

Execution plans

Graphical execution plans for SQL Server, PostgreSQL, MySQL and Oracle show each operator's cost, row estimates and warnings, and two plans can be compared side by side. SQLite has no graphical plan.

Schema compare, data compare and migration

Schema Compare finds the differences between two databases and generates a sync script; Data Compare does the same for rows. Cross-engine migration copies tables and data between engines, for example from SQL Server to PostgreSQL, and translates column types. On the free tier Schema Compare covers up to 200 objects per schema and Data Compare up to 10,000 rows per table.

DBA tools

The app includes a session browser and a performance dashboard, plus engine-specific tools: SQL Server Agent jobs, a deadlock analyzer and a Query Store view for SQL Server, and a PL/SQL debugger and tablespace manager for Oracle. Backup, restore and clone are built in.

Notebooks, charts and dashboards

SQL notebooks are saved as Jupyter-compatible .ipynb files, the same format Azure Data Studio used. Query results can be drawn as bar, line, pie, area and scatter charts and combined into dashboards.

AI agents and the MCP server

A local Model Context Protocol (MCP) server lets AI agents such as Claude Code, Codex CLI, Cursor and GitHub Copilot list your saved connections (never passwords) and run queries on the connections you allow. The built-in terminal (free) runs a command-line agent next to your editor, and AI Workspace sync (Pro) keeps query tabs as files on disk so the agent can edit the same SQL you have open.

What makes Jam SQL Studio different

SQL Server tools on macOS and Linux

SQL Server Management Studio runs only on Windows, and Microsoft retired Azure Data Studio, its cross-platform editor, on February 28, 2026. In Jam SQL Studio the SQL Server tools, including graphical execution plans, SQL Server Agent jobs, the deadlock analyzer and Query Store, work the same on macOS, Windows and Linux. Windows Authentication is available only on Windows. See the SSMS comparison.

Six engines in one app, with engine-specific tools

Single-engine tools cover one database each: SSMS for SQL Server, pgAdmin for PostgreSQL, MySQL Workbench for MySQL, and Kusto.Explorer, which is Windows-only, for Azure Data Explorer. Jam SQL Studio covers all six with the same editor and grid. DBeaver and DataGrip support more database types; Jam SQL Studio supports fewer and adds tools specific to each engine, such as the Oracle PL/SQL debugger and the SQL Server Query Store view.

Imports saved connections from ten other tools

Jam SQL Studio reads the saved connections of Azure Data Studio, the VS Code mssql and PostgreSQL extensions, SSMS, DBeaver, DataGrip and other JetBrains IDEs, TablePlus, MySQL Workbench, Oracle SQL Developer, Navicat and pgAdmin, plus tnsnames.ora, pg_service.conf, .my.cnf and ODBC data sources. You pick which connections to bring across in a review dialog; see Connections.

AI agents start with queries blocked

The MCP server runs no queries until you allow it; at the default level an agent can read the schema and write into a query tab, but cannot execute anything. For each connection you can allow read-only (SELECT-class) queries, or turn on Confirm mode, where each write or DDL statement waits for your approval in a dialog. DataGrip also ships an MCP server as of July 2026; Jam SQL Studio's starts with queries blocked and is configured per connection.

Free for personal use, per-user pricing for work

The Personal tier has unlimited connections and needs no account. Pro is $9.99 per month or $99 per year per user, covers every machine you use, and can be cancelled at any time. For comparison, as of September 2026 DataGrip's commercial license starts at $109 per year for individuals ($259 for organizations), and TablePlus costs $99 per device with updates renewed at $59 per year.

Who uses Jam SQL Studio

• SQL Server developers and DBAs on macOS or Linux who need execution plans, Agent jobs and deadlock analysis without a Windows virtual machine.
• Teams moving off Azure Data Studio after its February 2026 retirement, who want their connections and .ipynb notebooks to carry over (migration guide).
• Developers who work with several engines, for example SQL Server in production, PostgreSQL in another service and SQLite on their own machine.
• Oracle developers who want a PL/SQL debugger and package explorer on macOS or Linux.
• Engineers who query Azure Data Explorer, Application Insights or Log Analytics in KQL and also work in SQL.
• Developers using Claude Code, Codex CLI, Cursor or GitHub Copilot who want an agent to query a database with read-only or approval-gated access.
• Students and hobbyists, since the Personal tier is free for non-commercial use.

Who builds Jam SQL Studio

Jam SQL Studio is developed by an independent software studio in Poland with no outside investors; Pro subscriptions pay for development. It started in 2024 as a personal replacement for Azure Data Studio on macOS and became a public product in early 2026, shortly before Microsoft retired Azure Data Studio.

Support email goes straight to development rather than a first-line help desk, so bug reports and feature requests reach the code directly, and many entries in the changelog are fixes and features users asked for. Besides unit tests, the test suite runs end to end against real SQL Server, PostgreSQL, MySQL and Oracle servers and SQLite databases.

How Jam SQL Studio works

Getting started

Download the installer for macOS, Windows or Linux; the free tier needs no account. Add a connection by hand, paste a connection string, or import connections from another tool. The Getting Started guide covers the first query.

Trial and licensing

To try Pro, sign in inside the app and start the 14-day trial; no card is needed. Pro is billed monthly or yearly through Stripe. The license is per user and covers every machine you use, and a subscription can be cancelled at any time (the current paid period is not refunded). Full terms are in the EULA.

Updates

The app checks for updates in the background every hour, and the changelog lists every release. There were 38 releases between February 6 and September 19, 2026 (version 1.5.0).

Support and contact

Email [email protected] for help; Pro subscribers get priority email support. For volume licensing and invoices, email [email protected]; security reports go to [email protected]. The contact page lists every channel.

Your data

Connections, queries and results stay on your machine, and saved passwords and SSH secrets are encrypted with the operating system's secure storage (Keychain on macOS, DPAPI on Windows, the Secret Service on Linux) when it is available. The app sends anonymous usage telemetry (categories such as engine type and latency, never SQL text, table names or results), which you can turn off in Settings → Privacy; crash reports are sent only if you agree (Ask, Always or Never). The MCP server listens only on 127.0.0.1 and requires a bearer token. See the privacy policy.

Key facts

Frequently asked questions

Who makes Jam SQL Studio?

Jam SQL Studio is developed by an independent, self-funded software studio based in Poland. It is not affiliated with Microsoft, Oracle or JetBrains.

Is Jam SQL Studio free?

Yes, for personal, non-commercial use. The Personal tier has unlimited connections and needs no account. Using it for work requires Pro, which costs $9.99 per month or $99 per year and has a 14-day free trial with no card required.

Is Jam SQL Studio open source?

No. Jam SQL Studio is proprietary software licensed under its EULA. The free Personal tier covers non-commercial use without an account.

Does Jam SQL Studio send my queries or data anywhere?

Not by default. Connections, queries and results stay on your machine. Anonymous usage telemetry never includes SQL text, table or column names, or results; crash reports are sent only if you agree, and AI agents can run queries only on connections you allow. Telemetry and crash reports are controlled in Settings → Privacy.

Which databases and operating systems does Jam SQL Studio support?

SQL Server, Azure SQL, PostgreSQL, MySQL, MariaDB, Oracle, SQLite and Azure Data Explorer (including Application Insights and Log Analytics). It runs on macOS 11 or later, Windows 10 or later, and Linux (.deb, .rpm and Arch packages).

How do I get support or request a feature?

Email [email protected]. It goes straight to development rather than a first-line help desk, and Pro subscribers get priority email support.