Boyce
@boyce-io
About Boyce
Give AI agents structured database intelligence. Deterministic SQL, NULL trap detection, EXPLAIN pre-flight. MIT licensed.
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"boyce": {
"command": "uvx",
"args": [
"boyce"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Boyce?
Boyce is an MCP server that gives AI agents structured database intelligence to generate correct, safe SQL — deterministically. It compiles natural language to deterministic SQL via a StructuredFilter pipeline (zero LLM involvement), inspects live Postgres/Redshift schema, and verifies queries with EXPLAIN pre-flight.
How to use Boyce?
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.
Key features of Boyce
- 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_schemaandvalidate_sql. - 10 source parsers: dbt, LookML, DDL, SQLite, Django, etc.
- Supports Redshift, Postgres, DuckDB, BigQuery dialects.
Use cases of Boyce
- AI agents querying production Postgres/Redshift databases safely.
- Generating deterministic, byte-for-byte identical SQL from natural language.
- Pre-validating SQL with EXPLAIN to avoid runtime errors in Claude Desktop.
- Inspecting schema and NULL distributions to write
More Databases MCP servers
Postgres Mcp
crystaldbaPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
MCP MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
Comments