Boyce MCP
Boyce is a deterministic SQL compiler and semantic protocol that provides AI agents with structured database intelligence. It ensures correct, safe SQL generation by analyzing schema, detecting NULL traps, and performing EXPLAIN pre-flight validation without relying on LLMs for the SQL compilation itself.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
Checks and signals
Each line is separate evidence, not a trust score.
- Popularity 1 GitHub star
What you can do with it
- Generate correct SQL from natural language queries
- Detect NULL distribution traps in database schemas
- Validate SQL safety via EXPLAIN pre-flight
- Ingest database schemas from dbt, LookML, or DDL
Source and maintenance
- Last repository push
- Latest release
- v0.1.0
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
boyce 0.1.1
{
"version": "0.1.1",
"transport": "stdio",
"identifier": "boyce",
"registryType": "pypi",
"registryBaseUrl": "https://pypi.org",
"environmentVariables": [
{
"name": "BOYCE_DB_URL",
"description": "PostgreSQL or Redshift connection string. Optional — tools work without live DB; required for live profiling and EXPLAIN pre-flight."
},
{
"name": "BOYCE_PROVIDER",
"description": "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."
},
{
"name": "ANTHROPIC_API_KEY",
"description": "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."
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Maintenance history
Public check and source-refresh events. Editorial and ownership records remain private.
- · repository · passed · metadata changed · updated
- · backfill · recorded · Pre-expansion baseline; unobserved rich metadata remains unknown
Connect from your client
Each snippet configures the same source-provided package; replace placeholders before use.
Cursor
{
"mcpServers": {
"boyce-mcp": {
"command": "uvx",
"args": [
"boyce==0.1.1"
],
"env": {
"BOYCE_DB_URL": "<YOUR_BOYCE_DB_URL>",
"BOYCE_PROVIDER": "<YOUR_BOYCE_PROVIDER>",
"ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
}
}
}
}Cline
{
"mcpServers": {
"boyce-mcp": {
"command": "uvx",
"args": [
"boyce==0.1.1"
],
"env": {
"BOYCE_DB_URL": "<YOUR_BOYCE_DB_URL>",
"BOYCE_PROVIDER": "<YOUR_BOYCE_PROVIDER>",
"ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
}
}
}
}VS Code
{
"servers": {
"boyce-mcp": {
"type": "stdio",
"command": "uvx",
"args": [
"boyce==0.1.1"
],
"env": {
"BOYCE_DB_URL": "<YOUR_BOYCE_DB_URL>",
"BOYCE_PROVIDER": "<YOUR_BOYCE_PROVIDER>",
"ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
}
}
}
}Claude Desktop
{
"mcpServers": {
"boyce-mcp": {
"command": "uvx",
"args": [
"boyce==0.1.1"
],
"env": {
"BOYCE_DB_URL": "<YOUR_BOYCE_DB_URL>",
"BOYCE_PROVIDER": "<YOUR_BOYCE_PROVIDER>",
"ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
}
}
}
}Let your agent find its tools
Find servers like Boyce MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.