jamsql.com

What It Is

Jam SQL Studio is an AI-native, cross-platform desktop SQL IDE for working developers, data engineers, and DBAs. It runs on macOS, Windows, and Linux. One of its goals is to fill the gap left by the retirement of Azure Data Studio as a cross-platform database tool, with a particular focus on unified workflows across databases such as SQL Server, PostgreSQL, and MySQL.

Core Features and Ecosystem

Judging by its documentation, this is more than just a query tool. It is a full IDE covering development, administration, analytics, and migration. It supports connections to SQL Server, Azure SQL, PostgreSQL, MySQL, MariaDB, Oracle, and SQLite, and offers a Query Editor, IntelliSense, table browsing and inline editing, table design, SQL Notebooks, execution plans, charts, data profiling, dependency viewing, Schema Compare, Data Compare, backup and restore, cloning, security management, session monitoring, performance dashboards, and more. For Oracle, it includes a PL/SQL Debugger, Package Explorer, and Tablespace Manager. For SQL Server, it provides a Filegroup Manager and a cross-platform GUI for SQL Server Agent Jobs. On the AI side, it has a built-in AI Workspace and exposes a local MCP Server, allowing tools such as Claude Code, OpenCode, Codex CLI, and GitHub Copilot to access databases in read-only mode.

Pricing and Security Design

The main text states that the Personal tier is free forever and supports unlimited connections, but it does not disclose pricing for commercial, team, or enterprise licenses. Security is a standout part of the design: it is local-first, with connections, queries, and results kept on the local machine; MCP binds only to 127.0.0.1 and uses bearer-token auth; and the Agent is read-only by default, with writes and DDL rejected at the MCP layer.

Pros and Cons

Its strengths include broad database coverage, strong cross-platform consistency, a complete feature chain, plus dedicated migration guidance and connection import capabilities for Azure Data Studio users. The free personal plan with unlimited connections also improves its value for money. The limitations are that the main text does not state whether it is open source, making source-code transparency hard to assess; commercial pricing, payment methods, enterprise support SLA, AI model costs, and privacy details are also not sufficiently explained.

Who It’s For and Access from China

Jam SQL Studio is suitable for developers and DBA teams that need a local desktop SQL IDE, manage multiple types of databases, analyze execution plans, perform Schema/Data comparisons, or want to connect AI Agents to databases safely. There is no evidence in the main text about accessibility from mainland China, so it is rated as “unknown”; payment methods are likewise not disclosed. Comparable tools include DBeaver, DataGrip, TablePlus, SSMS, pgAdmin, MySQL Workbench, and Azure Data Studio for users still in the migration period.