Lets AI agents query SQL Server, PostgreSQL, MySQL, Oracle and SQLite via the Jam SQL Studio app.
Connect Runs on your machine
claude mcp add jam-sql-studio -e JAMSQL_MCP_URL=<JAMSQL_MCP_URL> -e JAMSQL_MCP_TOKEN=<JAMSQL_MCP_TOKEN> -- npx -y @jamsql/[email protected]{
"mcpServers": {
"jam-sql-studio": {
"command": "npx",
"args": [
"-y",
"@jamsql/[email protected]"
],
"env": {
"JAMSQL_MCP_URL": "<JAMSQL_MCP_URL>",
"JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
}
}
}
}{
"mcpServers": {
"jam-sql-studio": {
"command": "npx",
"args": [
"-y",
"@jamsql/[email protected]"
],
"env": {
"JAMSQL_MCP_URL": "<JAMSQL_MCP_URL>",
"JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
}
}
}
}{
"servers": {
"jam-sql-studio": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@jamsql/[email protected]"
],
"env": {
"JAMSQL_MCP_URL": "<JAMSQL_MCP_URL>",
"JAMSQL_MCP_TOKEN": "<JAMSQL_MCP_TOKEN>"
}
}
}
}Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
JAMSQL_MCP_URLOptional | MCP endpoint of the running Jam SQL Studio app. Leave unset to find it automatically through ~/.jamsql/mcp-discovery.json. |
JAMSQL_MCP_TOKENOptional, secret | Bearer token from Settings → AI Integrations. Leave unset to use the token saved by `jam-sql pair`. |
Details
| Package | @jamsql/[email protected] (NPM, stdio) |
| First published | 8 Nov 2026 |
| Last updated | 8 Nov 2026 |
| Registry name | com.jamsql/jam-sql-studio |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.