Jam SQL Studio

Official registry Data and databases

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

Install

Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).

NPM package @jamsql/mcp
Claude Code
claude mcp add jam-sql-studio -e 'JAMSQL_MCP_URL=<JAMSQL_MCP_URL>' -e 'JAMSQL_MCP_TOKEN=<your jamsql_mcp_token>' -- npx -y @jamsql/mcp@1.0.0
JSON configuration (Claude Desktop, Cursor, VS Code)
{
    "mcpServers": {
        "jam-sql-studio": {
            "command": "npx",
            "args": [
                "-y",
                "@jamsql/mcp@1.0.0"
            ],
            "env": {
                "JAMSQL_MCP_URL": "<JAMSQL_MCP_URL>",
                "JAMSQL_MCP_TOKEN": "<your jamsql_mcp_token>"
            }
        }
    }
}

Environment variables

  • 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 secret Bearer token from Settings → AI Integrations. Leave unset to use the token saved by `jam-sql pair`.

Frequently asked questions

What is Jam SQL Studio?

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

How do I install Jam SQL Studio?

It runs on your machine. In Claude Code: claude mcp add jam-sql-studio -e 'JAMSQL_MCP_URL=<JAMSQL_MCP_URL>' -e 'JAMSQL_MCP_TOKEN=<your jamsql_mcp_token>' -- npx -y @jamsql/mcp@1.0.0. For other clients, paste the JSON configuration from this page into their MCP settings.

Does Jam SQL Studio need an API key?

Yes. It expects JAMSQL_MCP_TOKEN, which you set in its configuration.

Who maintains Jam SQL Studio?

It is published by com.jamsql. AI.tn lists it but does not maintain or endorse it.

From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.