Skip to content
MCP server

Jam SQL Studio

Lets AI agents query SQL Server, Postgres, MySQL, Oracle and SQLite through Jam SQL Studio

Runs locallyStatus and history
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/mcp

Add 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

  1. REA

    MCP server

    CLI and MCP server that lets coding agents reverse engineer apps and binaries

    Runs locally
    • Open source
    • 464K GitHub stars
    • Developer tools
  2. Codebase Memory

    MCP server

    Local MCP server that builds a code knowledge graph for AI coding agents

    Runs locally
    • Open source
    • 48.7K GitHub stars
    • Knowledge and memory
  3. GitHub

    MCP server

    Official MCP server connecting AI assistants to GitHub repos, issues and workflows

    Not checked yet
    • Remote
    • Open source
    • 34.5K GitHub stars
    • Developer tools
  4. MCP toolkit giving coding agents symbol-level code retrieval and editing

    Runs locally
    • Open source
    • 31.5K GitHub stars
    • Developer tools
  5. XERJ

    MCP server

    Local search engine for AI agents with cited answers over your code and docs

    Runs locally
    • Open source
    • 19.2K GitHub stars
    • Knowledge and memory
  6. Ouroboros

    MCP server

    Spec-first layer that pins requirements and verifies results of AI coding agent work

    Runs locally
    • Open source
    • 6.4K GitHub stars
    • Developer tools