Last updated: 2026-02-12

AI Integrations & MCP

Jam SQL Studio is designed as an AI-native SQL IDE. There are three ways to leverage AI with your databases: the built-in AI Chat Sidebar for conversational assistance right in the editor, the AI Workspace for file-backed collaboration with AI agents, and MCP Server for external AI tools to safely interact with your databases.

Quick Start: Connect Your AI Tool

Get your AI coding assistant connected to Jam SQL Studio in under 2 minutes. Choose your tool below:

{
  "mcpServers": {
    "jam-sql": {
      "type": "http",
      "url": "http://127.0.0.1:14507/mcp",
      "headers": {
        "Authorization": "Bearer YOUR_TOKEN_HERE"
      }
    }
  }
}

{
  "mcpServers": {
    "jam-sql": {
      "type": "http",
      "url": "${JAM_SQL_MCP_ENDPOINT:-http://127.0.0.1:14507/mcp}",
      "headers": {
        "Authorization": "Bearer ${JAM_SQL_MCP_TOKEN}"
      }
    }
  }
}

claude mcp add --transport http jam-sql http://127.0.0.1:14507/mcp \
  --header "Authorization: Bearer YOUR_TOKEN_HERE" \
  --scope user

claude mcp list

[mcp_servers.jam-sql]
url = "http://127.0.0.1:14507/mcp"
bearer_token_env_var = "JAM_SQL_MCP_TOKEN"

export JAM_SQL_MCP_TOKEN="YOUR_TOKEN_HERE"

codex mcp add jam-sql --url http://127.0.0.1:14507/mcp

node --version  # Must be v20.0.0 or higher

{
  "mcpServers": {
    "jam-sql": {
      "command": "/path/to/node20+/bin/npx",
      "args": [
        "-y",
        "mcp-remote",
        "http://127.0.0.1:14507/mcp",
        "--header",
        "Authorization:${JAM_SQL_TOKEN}"
      ],
      "env": {
        "JAM_SQL_TOKEN": "Bearer YOUR_TOKEN_HERE"
      }
    }
  }
}

curl -X POST http://127.0.0.1:14507/mcp \
  -H "Authorization: Bearer YOUR_TOKEN_HERE" \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","method":"tools/list","id":1}'

export JAM_SQL_MCP_ENDPOINT="http://127.0.0.1:14507/mcp"
export JAM_SQL_MCP_TOKEN="YOUR_TOKEN_HERE"

AI Chat Sidebar

The AI Chat Sidebar brings conversational AI directly into the Query Editor and SQL Notebooks. Click the AI button in the toolbar to open a chat panel alongside your work.

Supported AI Backends

The AI Chat Sidebar supports two AI backends. Install either or both — Jam SQL auto-detects available CLIs:

• Claude CLI (Claude Code) — Anthropic's AI coding assistant
• Codex CLI — OpenAI's command-line coding agent

When both CLIs are installed, a segmented control in the sidebar header lets you switch between them. Your preference is saved and applied to new tabs automatically.

How It Works

1. Install Claude CLI or Codex CLI (or both)
2. Open a Query Editor or SQL Notebook
3. Click the AI button in the toolbar to open the chat sidebar
4. Ask your AI about your SQL — it can read your editor content, run queries, and update your code

Features

• Database-aware — the AI auto-connects to the MCP server for schema introspection and query execution
• Editor integration — the AI can update your SQL directly in the editor
• Notebook support — In SQL Notebooks, the AI understands your cell structure and can add, edit, and execute cells on your behalf
• @-mentions — type @ to reference database objects from the Object Explorer
• Streaming responses — see answers appear in real-time with inline tool call indicators
• Session continuity — conversations persist across tab switches and session restores
• Multi-backend — switch between Claude and Codex with a single click; each manages its own authentication
• Zero configuration — if a supported CLI is installed, the sidebar auto-connects to the MCP server. No API keys to paste into Jam SQL.
• Privacy — all communication happens locally between the app and the CLI binary on your machine

Understanding the Three Approaches

Jam SQL Studio offers flexibility in how you work with AI. Depending on your workflow, you might prefer one approach or combine them:

AI Workspace (Inside the App)

The AI Workspace provides file-backed query tabs that sync bidirectionally with .sql files. Combined with the integrated terminal, this enables AI agents (like Claude Code) to edit your queries in real-time.

AI Workspace Features

• Bidirectional file sync — Query tabs sync to .sql files; AI edits the file, your tab updates automatically
• Auto-generated context — CLAUDE.md and AGENTS.md contain connection info, schema summary, and recent execution results
• Schema export — Detailed table/view/procedure definitions exported to .schema/ for granular @table mentions
• Results history — Query results saved to .history/ so AI agents can analyze output and iterate
• Knowledge pack — App capabilities and how-to documentation in .knowledge/
• MCP environment variables — Terminal sessions include JAM_SQL_MCP_ENDPOINT and JAM_SQL_MCP_TOKEN for direct MCP access
• Auto-generated MCP configs — Config files for popular AI tools (.mcp.json, .cursor/mcp.json, opencode.json, .vscode/mcp.json) are automatically created with endpoint and token

How to Use AI Workspace

1. Open Jam SQL Studio and go to Settings → AI Workspace
2. Enable AI Workspace and select or create a workspace folder
3. Open the integrated terminal (View → Terminal or click Terminal in the sidebar)
4. Run your AI coding agent (e.g., claude for Claude Code)
5. The agent can read/edit .sql files, and your query tabs update in real-time

MCP Server (Outside the App)

Jam SQL Studio runs a local MCP server (Model Context Protocol) that external AI tools can use to list connections, execute queries, control the UI, and read live app state — all under configurable safety policies.

MCP Server Capabilities

The MCP server exposes tools and resources for connections, queries, UI control, and app context. For a live, accurate list, read sql-studio://knowledge/app_capabilities.

Supported AI Tools

Any AI tool that supports MCP or HTTP can connect to Jam SQL Studio:

• Claude Code (recommended) — Native HTTP support via .mcp.json (project) or ~/.claude.json (user), or use claude mcp add
• Claude Desktop — Requires mcp-remote proxy and Node.js 20+ (see setup guide above)
• Codex CLI — Configure in ~/.codex/config.toml or use codex mcp add
• OpenCode — Environment variable configuration
• GitHub Copilot — Via MCP extension or custom integration
• Custom agents — Built with LangChain, AutoGen, or any HTTP client

Setting Up MCP Server

1. Open Jam SQL Studio and go to Settings → AI Integrations
2. Enable MCP Server
3. Copy the Endpoint URL (e.g., http://127.0.0.1:14507/mcp)
4. Copy the Bearer Token (click "Show" then "Copy")
5. Configure your AI tool with the endpoint and token (see examples below)

Configuration Examples

Claude Code (JSON format, .mcp.json or ~/.claude.json):

{
  "mcpServers": {
    "jam-sql": {
      "type": "http",
      "url": "http://127.0.0.1:14507/mcp",
      "headers": {
        "Authorization": "Bearer YOUR_TOKEN_HERE"
      }
    }
  }
}

Note: Claude Desktop requires a different format using mcp-remote proxy. See the Claude Desktop quick start section above.

Codex CLI (~/.codex/config.toml):

[mcp_servers.jam-sql]
url = "http://127.0.0.1:14507/mcp"
bearer_token_env_var = "JAM_SQL_MCP_TOKEN"

Then set export JAM_SQL_MCP_TOKEN="YOUR_TOKEN_HERE" in your shell profile.

Permission Levels

Configure the AI policy in Settings to control what the MCP server can do:

• Block (default) — No query execution; allows safe query-tab editing (open tab + set SQL text) and schema introspection
• Read-only — Allow strict read-only queries only (SELECT, EXPLAIN, SHOW, PRAGMA — recommended)
• Confirm — Allow write queries only after in-app approval (each write prompts you)

Write Approval Flow (Confirm Mode)

When permission level is set to Confirm, AI agents can execute write queries (INSERT, UPDATE, DELETE, etc.) but only after you approve each one in an in-app dialog:

Agent Capabilities

Some MCP tools are controlled by additional toggles in Settings → AI Integrations:

• Allow AI to connect using saved connections — Off by default (uses saved credentials)
• Allow AI screenshots — On by default (disable if you handle sensitive data)

jam-sql CLI

Jam SQL Studio ships with a Go-based CLI tool (jam-sql) that wraps the MCP server for quick terminal access:

# Check installation and MCP status
jam-sql doctor

# List saved connections
jam-sql connections

# Execute a query
jam-sql query -c production "SELECT * FROM users LIMIT 5"

# List available MCP tools and resources
jam-sql tools
jam-sql resources

# Call any MCP tool
jam-sql call ui_open_tab '{"type": "query"}'

# Read an MCP resource
jam-sql read sql-studio://context/tabs

Which Approach Should You Use?

All three approaches complement each other:

• Use AI Chat Sidebar for quick, conversational assistance while writing queries or building notebooks. It's the fastest way to get AI help without leaving your editor.
• Use AI Workspace when you want to iterate on queries with AI agents using the integrated terminal + file sync workflow.
• Use MCP Server when you're working in an external AI tool (like Claude Desktop) and need to access your database connections and execute queries from outside the app.
• Use all three for maximum flexibility — the sidebar for quick help, AI Workspace for file-backed collaboration, MCP for external tool integration.