mcpbeat Sign in

Jam SQL Studio MCP Server

local only

Jam SQL Studio runs on your own machine — the client starts it, so there is no endpoint to ping. 306 installs a week from npm.

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

Installs per day peak 306 · avg 10
a month agotoday
306
Installs / week
npm · @jamsql/mcp
—
Stars
on GitHub
—
Last commit
2 releases in 90 days
—
License
language unknown

Nothing serious here today

Today is the operative word: we check Jam SQL Studio every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Three servers free · no card

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

run in your terminal
claude mcp add jam-sql-studio -- npx -y @jamsql/mcp
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "jam-sql-studio": {
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "command": "npx"
    }
  }
}
~/.codex/config.toml
[mcp_servers.jam-sql-studio]
command = "npx"
args = ["-y", "@jamsql/mcp"]
.cursor/mcp.json
{
  "mcpServers": {
    "jam-sql-studio": {
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "command": "npx"
    }
  }
}
.vscode/mcp.json
{
  "mcpServers": {
    "jam-sql-studio": {
      "args": [
        "-y",
        "@jamsql/mcp"
      ],
      "command": "npx"
    }
  }
}

This one needs environment variables set before it will start: 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 (Bearer token from Settings → AI Integrations. Leave unset to use the token saved by `jam-sql pair`.). The author declared them in the registry entry; get the values from the project itself.

Alternatives to Jam SQL Studio

same job, measured the same way
JDBC MCP Server
by igorolv

Read-only SQL, plans, schema for AI agents: PostgreSQL, Oracle, SQL Server, Firebird, SQLite, JDBC

local only
Faucet
by faucetdb

SQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.

371 installs/wk local only
SaturnSQL
by saturnsql

Query Postgres, MySQL, SQL Server, Oracle, BigQuery, ClickHouse and Redshift from your AI client.

answering
MCP SQL Rust
by rzlco666

Token-efficient MCP server for MySQL, PostgreSQL, and SQLite

local only
Strut Stack SQL
by rzlco666

Token-efficient MCP server for MySQL, PostgreSQL, and SQLite

local only
Raw SQL MCP
by kifopl

Execute raw SQL queries against SQL Server, SQLite, PostgreSQL, MySQL, and MariaDB.

local only
D
Data
by thinair

PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.

answering
MCP DB Connect
by phatngoit

MCP server for Oracle, MSSQL, PostgreSQL, MySQL, SQLite, MongoDB, and Qdrant vector search access.

53 installs/wk local only

Jam SQL Studio — questions

Answers built from our own checks of this server.

Why is there no uptime for Jam SQL Studio?
Jam SQL Studio runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the npm package @jamsql/mcp was installed 306 times last week.
How do I connect Jam SQL Studio?
Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It runs locally, so the command pulls @jamsql/mcp straight from npm; nothing to host, nothing to sign up for.
How many people use Jam SQL Studio?
The npm package @jamsql/mcp was installed 306 times in the last week. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.