# Jam SQL Studio

> Jam SQL Studio is a freemium MCP server for databases. Lets AI agents query SQL Server, Postgres, MySQL, Oracle and SQLite through Jam SQL Studio. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Starting price:** $9.99 a month
- **Platforms:** macOS, Windows, Linux, CLI
- **Website:** https://jamsql.com
- **MCP Registry name:** com.jamsql/jam-sql-studio
- **Categories:** databases, developer tools
- **Listing updated:** 2026-11-14

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

```sh
claude mcp add jam-sql-studio --env JAMSQL_MCP_TOKEN='<JAMSQL_MCP_TOKEN>' -- npx -y @jamsql/mcp
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "jam-sql-studio": {
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
      }
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "jam-sql-studio": {
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "jam-sql-studio": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "jam-sql-studio": {
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "jam-sql-studio": {
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
      }
    }
  }
}
```

## 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

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.

---
Source: https://ai-powered.com/mcp/jam-sql-studio
