
Jam SQL Studio
Lets AI agents query SQL Server, Postgres, MySQL, Oracle and SQLite through Jam SQL Studio
- Pricing
- Freemium
- Platforms
- macOS, Windows, Linux
- Runs
- Locally
- Version
- 1.0.1
- Listing updated
- 2 days ago
About Jam SQL Studio
Jam SQL Studio is a freemium MCP server for databases. It runs locally on your machine and is started by your AI client.
This server is a bridge to the Jam SQL Studio desktop app, which must be running. The npm package finds the app's local MCP endpoint through a discovery file or the JAMSQL_MCP_URL variable, and authenticates with a bearer token saved by a pairing command or set in the app's AI Integrations settings.
The site says the app's MCP server listens only on localhost, runs no queries by default, and offers read-only or approval-gated writes, with audit logs. Beyond running queries, external agents can control query editor and notebook tabs. The app also has an AI Workspace that generates CLAUDE.md and AGENTS.md context files, exports the schema and syncs files both ways, plus an in-app Claude Code chat that reuses your local CLI.
The IDE itself is positioned as a replacement for Azure Data Studio, which the site says was retired on 28 February 2026. It adds IntelliSense, execution plans, schema and data compare, charting, notebooks and DBA tools across Mac, Windows and Linux.
Install
Run in a terminal
claude mcp add jam-sql-studio --env JAMSQL_MCP_TOKEN='<JAMSQL_MCP_TOKEN>' -- npx -y @jamsql/mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"jam-sql-studio": {
"command": "npx",
"args": [
"-y",
"@jamsql/mcp"
],
"env": {
"JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"jam-sql-studio": {
"command": "npx",
"args": [
"-y",
"@jamsql/mcp"
],
"env": {
"JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"jam-sql-studio": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@jamsql/mcp"
],
"env": {
"JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"jam-sql-studio": {
"command": "npx",
"args": [
"-y",
"@jamsql/mcp"
],
"env": {
"JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"jam-sql-studio": {
"command": "npx",
"args": [
"-y",
"@jamsql/mcp"
],
"env": {
"JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
}
}
}
}Configuration
JAMSQL_MCP_URLMCP endpoint of the running Jam SQL Studio app. Leave unset to find it automatically through ~/.jamsql/mcp-discovery.json.JAMSQL_MCP_TOKENBearer token from Settings → AI Integrations. Leave unset to use the token saved by `jam-sql pair`.
What it does
- Local-first MCP
- Listens on 127.0.0.1 with bearer token authentication and audit logs.
- Guarded writes
- No queries run by default; writes are read-only or approval-gated.
- Editor and notebook control
- External agents can drive query editor and SQL notebook tabs.
- AI Workspace
- Generates CLAUDE.md and AGENTS.md context, schema export and synced files.
- Five database engines
- Works with SQL Server, PostgreSQL, MySQL, Oracle and SQLite, including Azure SQL and MariaDB.
- Azure Data Studio import
- Reads Azure Data Studio settings.json to bring over connections.
Good for
- Let a coding agent inspect a schema and run read-only queries
- Compare schemas between environments with agent help
- Migrate from Azure Data Studio and keep existing .sql files
- Chat with Claude Code about a live database from inside the IDE
Pricing
Freemium, from $9.99 a month
Free for personal use; Pro $9.99/month or $99/year; 14-day Pro trial
Prices change. Check jamsql.com before you buy.
Jam SQL Studio FAQ
Does it work without the desktop app?
No. The package connects to the running Jam SQL Studio app's local MCP endpoint.
Is it free?
Personal use is free forever with no account. Pro costs $9.99 a month or $99 a year and adds commercial use, removes size caps and enables AI Workspace sync. The MCP server is listed as included on the free tier.
Can the agent change my data?
Only if you allow it. By default no queries run, and writes are read-only or require approval.
Which operating systems are supported?
macOS on Apple Silicon and Intel, Windows, and Linux with deb and rpm packages.
Is Jam SQL Studio free?
Jam SQL Studio has a free plan, with paid plans for more usage or features. Paid plans start at $9.99 a month.
How do I add Jam SQL Studio to Claude Code?
Run this command in your terminal: claude mcp add jam-sql-studio --env JAMSQL_MCP_TOKEN='<JAMSQL_MCP_TOKEN>' -- npx -y @jamsql/mcp
What are the best alternatives to Jam SQL Studio?
The closest alternatives to Jam SQL Studio are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.
Alternatives to Jam SQL Studio

REA
MCP serverCLI and MCP server that lets coding agents reverse engineer apps and binaries
Runs locally- Open source
- 464K GitHub stars
- Developer tools

Codebase Memory
MCP serverLocal MCP server that builds a code knowledge graph for AI coding agents
Runs locally- Open source
- 48.7K GitHub stars
- Knowledge and memory

GitHub
MCP serverOfficial MCP server connecting AI assistants to GitHub repos, issues and workflows
Not checked yet- Remote
- Open source
- 34.5K GitHub stars
- Developer tools

Serena MCP: the IDE for your agent
MCP serverMCP toolkit giving coding agents symbol-level code retrieval and editing
Runs locally- Open source
- 31.5K GitHub stars
- Developer tools

XERJ
MCP serverLocal search engine for AI agents with cited answers over your code and docs
Runs locally- Open source
- 19.2K GitHub stars
- Knowledge and memory

Ouroboros
MCP serverSpec-first layer that pins requirements and verifies results of AI coding agent work
Runs locally- Open source
- 6.4K GitHub stars
- Developer tools