How do I install the boyce mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `BOYCE_DB_URL`, `BOYCE_PROVIDER`, `BOYCE_MODEL`, `ANTHROPIC_API_KEY`, `OPENAI_API_KEY`, `BOYCE_HTTP_TOKEN` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Boyce MCP Server

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

Local serverstdioPython

What is the Boyce MCP Server?

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

The short version

Named for Raymond F. Boyce, co-inventor of SQL (1974) and co-author of Boyce-Codd Normal Form (BCNF).

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
ingest_source	Parse a SemanticSnapshot from dbt manifest, dbt project, LookML, DDL, SQLite, Django, SQLAlchemy, Prisma, CSV, or Parquet.
ingest_definition	Store a certified business definition — injected automatically at query time.
get_schema	Return full schema context + StructuredFilter format docs. Used by MCP hosts so the host LLM can construct queries without a Boyce API key.
ask_boyce	Full NL → SQL pipeline: query planner (LiteLLM) → deterministic kernel → NULL trap check → EXPLAIN pre-flight.
validate_sql	Validate hand-written SQL — EXPLAIN pre-flight, Redshift lint, NULL risk — without executing.
query_database	Execute a read-only SELECT against the live database. Write operations rejected at two independent layers.
profile_data	Null %, distinct count, min/max for any column — surface data quality issues before they affect query results.
check_health	Operational health check — DB connectivity, snapshot freshness, actionable fix commands. Call when queries fail unexpectedly.

How to install the Boyce MCP Server

{
  "mcpServers": {
    "boyce": {
      "command": "uvx",
      "args": ["boyce"],
      "env": {
        "BOYCE_DB_URL": "your-value",
        "BOYCE_PROVIDER": "your-value",
        "BOYCE_MODEL": "your-value",
        "ANTHROPIC_API_KEY": "your-value",
        "OPENAI_API_KEY": "your-value",
        "BOYCE_HTTP_TOKEN": "your-value"
      }
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

Variable	Description	Required
BOYCE_DB_URL	Endpoint or connection string the server talks to.	Yes
BOYCE_PROVIDER	Configuration value read at startup.	Optional
BOYCE_MODEL	Configuration value read at startup.	Optional
ANTHROPIC_API_KEY	Credential the server authenticates with.	Yes
OPENAI_API_KEY	Credential the server authenticates with.	Yes
BOYCE_HTTP_TOKEN	Credential the server authenticates with.	Yes

Example prompts to try

“Use Boyce to ingest source.”
“Use Boyce to ingest definition.”
“Use Boyce to get schema.”

Frequently asked questions

Deterministic SQL compiler for AI agents. Your agent stops guessing SQL. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.