Jam SQL Studio MCP Server

com.jamsql/jam-sql-studiov1.0.0

Lets AI agents query SQL Server, PostgreSQL, MySQL, Oracle and SQLite via the Jam SQL Studio app.

Node.jsstdioofficial registry

context tax

pending

security

pending

cold start

pending

freshness

Active8d ago

Our reading of Jam SQL Studio, from the data

Jam SQL Studio is a database MCP server, listed in the official MCP Registry.

We haven't measured its tool list yet, so its token cost is unknown.

Maintenance is active: the last public signal was 8 days ago (2026-10-10). For comparison, 64% of database servers are active or maintained.

It runs locally on your machine over stdio and needs one secret (JAMSQL_MCP_TOKEN); use a scoped, least-privilege key.

Install Jam SQL Studio MCP server

claude mcp add jamsql -e JAMSQL_MCP_TOKEN='<jamsql-mcp-token>' -- npx -y @jamsql/mcp

{
  "mcpServers": {
    "jamsql": {
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<jamsql-mcp-token>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "jamsql": {
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<jamsql-mcp-token>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "jamsql": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<jamsql-mcp-token>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "jamsql": {
      "command": "npx",
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "env": {
        "JAMSQL_MCP_TOKEN": "<jamsql-mcp-token>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
JAMSQL_MCP_URL	—	—	MCP endpoint of the running Jam SQL Studio app. Leave unset to find it automatically through ~/.jamsql/mcp-discovery.json.
JAMSQL_MCP_TOKEN	—	yes	Bearer token from Settings → AI Integrations. Leave unset to use the token saved by `jam-sql pair`.

Freshness

Active — last maintenance signal 8d ago. The newest of the signals below sets the band.

Last commit (default branch)
no data · GitHub
Latest release
no data · GitHub
Package published
no data · npm/PyPI
Registry entry updated
2026-10-10 · 8d ago · official registry · v1.0.0

How it compares in Database

Against the most-starred database servers we index. Token cost is per model turn, measured from each server's live tool list.

Server	Stars	Tools	Tokens / turn	Freshness	Runs
Jam SQL Studio (this)	—	—	not measured	Active	local
Screenpipe	21,982	—	not measured	Active	—
Genai Toolbox	16,679	—	not measured	Active	hosted
Convex Backend	12,716	—	not measured	Active	—
Kubeshark	12,100	—	not measured	Active	local
Baserow	6,174	—	not measured	Active	—

All database MCP servers

FAQ

›How do I install the Jam SQL Studio MCP server in Claude Code?

Run: claude mcp add jamsql -e JAMSQL_MCP_TOKEN='<jamsql-mcp-token>' -- npx -y @jamsql/mcp. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does Jam SQL Studio require an API key?

Yes. It expects JAMSQL_MCP_TOKEN, of which 1 is a secret.

›Can I use Jam SQL Studio as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is Jam SQL Studio in the official MCP registry?

Yes, as com.jamsql/jam-sql-studio.

Sources and method

Official MCP Registry entry: updated 2026-10-10
Package registry (npm / PyPI): listed
Last checked against all sources: 2026-10-19

The description, packages and links come from the maintainer's own published metadata. Token cost, security signals, freshness and the reading above are MCPSkillHub's own measurements; see the methodology. Spot an error? Request a correction or claim the listing.