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

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

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_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

MongoDB MCP Server

mongodb-js

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

1.1K