MCP.so
Sign In
B

Boyce

@boyce-io

Repository

About Boyce

Give AI agents structured database intelligence. Deterministic SQL, NULL trap detection, EXPLAIN pre-flight. MIT licensed.

#mcp#sql#database#postgresql#redshift#duckdb#bigquery#dbt#semantic-layer#agents#llm

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_schema and validate_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

Comments

Basic information

Category

Databases

Transports

stdio

Author

boyce-io

Submitted by

Will Wright

More Databases MCP servers

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617