Boyce
Boyce is an MCP server that gives AI agents structured database intelligence to generate correct, safe SQL — deterministically.
The problem: AI agents querying databases without context produce unreliable SQL. They guess join paths, miss NULL distributions, and silently return wrong results. An unguarded equality filter on a column with 30% NULLs silently drops those rows — and the agent never knows.
What Boyce does:
- SQL Compiler — NL → StructuredFilter → deterministic SQL. Same inputs, same SQL, byte-for-byte, every time. Zero LLM in the SQL compiler.
- Database Inspector — Live Postgres/Redshift adapter. Real schema, real NULL distributions before writing a single filter.
- Query Verification — EXPLAIN pre-flight on every query. Bad SQL caught at planning time, not at 2am.
For MCP hosts (Claude Desktop, Cursor, Claude Code, etc.): No API key needed. The host LLM reads the schema via get_schema, constructs a query, and Boyce compiles deterministic SQL.
8 MCP tools: ingest_source, ingest_definition, get_schema, ask_boyce, validate_sql, query_database, profile_data, check_health.
10 source parsers: dbt manifest, dbt project, LookML, raw DDL, SQLite, Django, SQLAlchemy, Prisma, CSV, Parquet.
Dialects: Redshift, Postgres, DuckDB, BigQuery.
Named for Raymond F. Boyce, co-inventor of SQL (1974). MIT licensed.
Server Config
{
"mcpServers": {
"boyce": {
"command": "uvx",
"args": [
"boyce"
]
}
}
}