Boyce
About
Give AI agents structured database intelligence. Deterministic SQL, NULL trap detection, EXPLAIN pre-flight. MIT licensed.
Details
- Author
- boyce-io
- Downloads
- 280
- Categories
- Database, AI
Jump to
- Deterministic SQL compiler with zero LLM in the pipeline.
- Live database inspector for schema and NULL distributions.
- EXPLAIN pre-flight verification catches bad queries early.
- 8 MCP tools including get_schema and validate_sql.
- 10 source parsers: dbt, LookML, DDL, SQLite, Django, etc.
- Supports Redshift, Postgres, DuckDB, BigQuery dialects.
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
BoyceCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Connect any MCP host (Claude Desktop, Cursor, Claude Code, etc.) to Boyce. No API key is required. The host LLM reads the schema via get_schema, constructs a query, and Boyce compiles deterministic SQL. Boyce provides 8 MCP tools including ingest_source, get_schema, ask_boyce, validate_sql, query_database, profile_data, and check_health.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"boyce": {
"boyce": {
"command": "uvx",
"args": [
"boyce"
]
}
}
}
}McpServers
{
"boyce": {
"command": "uvx",
"args": [
"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.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
