Schema Search MCP Server

An MCP Server for Natural Language Search over RDBMS Schemas. Find exact tables you need, with all their relationships mapped out, in milliseconds.

Local serverstdioPython

What is the Schema Search MCP server?

Most database access work still happens through a UI a human drives. Schema Search MCP server moves it into the conversation instead. An MCP Server for Natural Language Search over RDBMS Schemas. Find exact tables you need, with all their relationships mapped out, in milliseconds. No vector database setup is required.

The short version

  • Grep through SQL files for 20 minutes
  • Pass the full schema to an LLM and watch it struggle with 200 tables

The tools it exposes

The server publishes 2 tools. What each one is for:

  • Benefits — The Benefits tool exposed by this server
  • Setup — Add to your MCP config (e.g., ~/.cursor/mcp.json or Claude Desktop config):

Getting it running

Setup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client. The configuration blocks on this page cover the common clients.

How it compares

This sits in the database access group, where several servers overlap in what they claim to do but differ sharply once you actually set them up. Schema Search's toolset — Benefits, Setup — is a fair guide to whether it matches your workflow. It is maintained by neehan; worth a glance at recent repository activity before you build anything load-bearing on it.

We check each listing at SyncDev against the project's documentation before it goes live — if something here drifts out of date, it is a bug worth reporting.

Things to watch

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

Available tools

ToolWhat it does
BenefitsThe Benefits tool exposed by this server.
SetupAdd to your MCP config (e.g., ~/.cursor/mcp.json or Claude Desktop config):

How to install the Schema Search MCP server

**Using pip:**
```json
{
  "mcpServers": {
    "schema-search": {
      // conda: /Users/<username>/opt/miniconda3/envs/<your env>/bin/schema-search",
      "command": "path/to/schema-search",
      "args": [
        "postgresql://user:pass@localhost/db", 
        "optional/path/to/config.yml", 
        "optional llm_api_key", 
        "optional llm_base_url"
      ]
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Example prompts to try

  • Use Schema Search to Benefits.
  • Use Schema Search to Setup.

Frequently asked questions

It connects Schema Search to MCP-compatible AI assistants such as Claude and Cursor, exposing 2 tools (Benefits, Setup) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Schema Search directly.