Boyce MCP Server

Name: Boyce MCP Server
Author: io.github.boyce-io

io.github.boyce-io/boyce

Repository Registry

What is the Boyce MCP server?

Deterministic SQL compiler for AI agents. Your agent stops guessing SQL.

How to install Boyce

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

BOYCE_DB_URL
PostgreSQL or Redshift connection string. Optional — tools work without live DB; required for live profiling and EXPLAIN pre-flight.
BOYCE_PROVIDER
LLM provider for the NL→StructuredFilter planner (anthropic, openai). MCP hosts using their own model should not set this — the host's model does the reasoning and Boyce receives a pre-built StructuredFilter.
ANTHROPIC_API_KEY
Required only when BOYCE_PROVIDER=anthropic and the host does not supply its own model. MCP hosts (Claude Desktop, Cursor, Claude Code, Codex, Cline, Windsurf, JetBrains) do not need this.

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "boyce": {
      "command": "uvx",
      "args": [
        "boyce"
      ],
      "env": {
        "BOYCE_DB_URL": "<YOUR_BOYCE_DB_URL>",
        "BOYCE_PROVIDER": "<YOUR_BOYCE_PROVIDER>",
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "boyce": {
      "command": "uvx",
      "args": [
        "boyce"
      ],
      "env": {
        "BOYCE_DB_URL": "<YOUR_BOYCE_DB_URL>",
        "BOYCE_PROVIDER": "<YOUR_BOYCE_PROVIDER>",
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "boyce": {
      "command": "uvx",
      "args": [
        "boyce"
      ],
      "env": {
        "BOYCE_DB_URL": "<YOUR_BOYCE_DB_URL>",
        "BOYCE_PROVIDER": "<YOUR_BOYCE_PROVIDER>",
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "boyce": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "boyce"
      ],
      "env": {
        "BOYCE_DB_URL": "<YOUR_BOYCE_DB_URL>",
        "BOYCE_PROVIDER": "<YOUR_BOYCE_PROVIDER>",
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
      }
    }
  }
}

Claude Code

claude mcp add boyce --env BOYCE_DB_URL=<YOUR_BOYCE_DB_URL> --env BOYCE_PROVIDER=<YOUR_BOYCE_PROVIDER> --env ANTHROPIC_API_KEY=<YOUR_ANTHROPIC_API_KEY> -- uvx boyce