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

Fetch the live tool list by running this server in a temporary sandbox using the button above.

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

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Dbhub

bytebase

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

3.1K

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281