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

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

4

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637