mcpbridge
Allows running parameterized SQL queries against MySQL databases, exposing them as MCP tools.
Allows running parameterized SQL queries against PostgreSQL databases, exposing them as MCP tools.
Allows running parameterized SQL queries against SQLite databases, exposing them as MCP tools.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcpbridgeget weather in London"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
mcpbridge
One YAML file. Any data source. Instant MCP server.
mcpbridge turns a YAML config file into a working MCP server — no code required.
Point it at a database, a REST API, or a folder of Markdown files. Claude (or any MCP client) can query them immediately.
What It Does
db_query— run parameterized SQL queries against PostgreSQL, SQLite, or MySQLget_endpoint— call any REST GET endpoint and expose the result as an MCP toolknowledge_base— serve.mdfiles or directories as MCP resources
All three can live in a single config.yaml. Swap the YAML, restart — done.
Related MCP server: MCP YAML API
5-Minute Quickstart
With npx (no install)
# 1. Create a config file
cat > config.yaml << 'EOF'
server:
name: weather-mcp
version: 1.0.0
transport: stdio
sources:
- type: get_endpoint
name: get_weather
description: >
Returns current weather for a location given latitude and longitude.
Use when the user asks about weather or temperature.
url: https://api.open-meteo.com/v1/forecast
query_params:
- name: latitude
type: float
required: true
- name: longitude
type: float
required: true
response_field: current_weather
EOF
# 2. Validate it
npx mcpbridge validate config.yaml
# 3. Add to Claude Desktop (see below) and ask: "What's the weather in Amsterdam?"With Docker
docker run \
-v ./config.yaml:/app/config.yaml \
--env-file .env \
mcpbridge/mcpbridgeClaude Desktop Setup
Add to ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows):
{
"mcpServers": {
"my-server": {
"command": "npx",
"args": ["mcpbridge", "run", "/absolute/path/to/config.yaml"],
"env": {
"DATABASE_URL": "postgresql://user:pass@localhost/mydb"
}
}
}
}YAML Reference
db_query — SQL query as MCP tool
- type: db_query
name: get_orders # snake_case, becomes tool name
description: > # LLM reads this — be specific about when to use it
Returns all orders for a specific user.
Use when asked about order history or purchases.
query: >
SELECT id, product, amount, status
FROM orders
WHERE user_id = :user_id
params:
- name: user_id
type: integer # string | integer | boolean | float
required: true
connection: "${DATABASE_URL}" # always an env var — never hardcode
allow_write: false # default: false — set true only for explicit write toolsSupported databases: PostgreSQL (postgresql://), MySQL (mysql://), SQLite (sqlite://./path.db)
Read-only by default. INSERT/UPDATE/DELETE/DROP are blocked unless allow_write: true. DDL (DROP/ALTER/CREATE) is always blocked.
get_endpoint — REST GET as MCP tool
- type: get_endpoint
name: get_weather
description: >
Returns current weather forecast for a given latitude and longitude.
Use when the user asks about weather or temperature.
url: https://api.open-meteo.com/v1/forecast
query_params:
- name: latitude
type: float
required: true
- name: longitude
type: float
required: true
headers:
Authorization: "Bearer ${API_KEY}" # env var substitution in headers too
response_field: current_weather # optional: extract nested field (dot notation)
timeout: 30 # seconds, default: 30knowledge_base — Markdown files as MCP resources
- type: knowledge_base
name: company_faq
description: >
Internal company FAQ and policies.
Use when the user asks about company procedures or rules.
path: ./kb/ # file or directory (recursive)
strategy: chunk # full | chunk
chunk_size: 800 # chars per chunk (default: 800)
chunk_overlap: 100 # overlap between chunks (default: 100)Hidden files (.hidden.md) and directories (.git/) are skipped automatically.
Full Example Config
server:
name: my-company-mcp
version: 1.0.0
transport: stdio
sources:
- type: get_endpoint
name: get_weather
description: >
Returns current weather for a location.
Use when the user asks about weather.
url: https://api.open-meteo.com/v1/forecast
query_params:
- name: latitude
type: float
required: true
- name: longitude
type: float
required: true
response_field: current_weather
- type: db_query
name: get_orders
description: >
Returns orders for a specific user.
Use when the user asks about their order history.
query: "SELECT id, product, amount, status FROM orders WHERE user_id = :user_id"
params:
- name: user_id
type: integer
required: true
connection: "${DATABASE_URL}"
- type: knowledge_base
name: company_faq
description: >
Company FAQ and internal policies.
Use when the user asks about company procedures.
path: ./kb/
strategy: chunk
chunk_size: 800Running Locally
# Install
npm install -g mcpbridge
# or without installing:
npx mcpbridge
# Validate a config
mcpbridge validate config.yaml
# Run the server
DATABASE_URL=sqlite://./dev.db mcpbridge run config.yamlRunning with Docker
# Build locally
docker build -t mcpbridge .
# Run with a config
docker run \
-v ./config.yaml:/app/config.yaml \
-v ./kb:/app/kb \
--env-file .env \
mcpbridge
# Or with docker-compose (includes PostgreSQL)
docker compose upSecurity Notes
Secrets always via env vars. The YAML schema rejects connection strings not using
${ENV_VAR}syntax.Read-only DB by default. Set
allow_write: trueexplicitly per source to enable mutations.DDL is never allowed. DROP/ALTER/CREATE/TRUNCATE are blocked regardless of
allow_write.No auth on the MCP server in v0.1 — run behind a firewall or VPN. Auth is on the v0.2 roadmap.
Let Claude Configure It For You
Share your CLAUDE.md with Claude (or just point Claude at this repo)
Say: "Configure mcpbridge for my [restaurant / e-commerce store / SaaS app]. Here's what it does: ..."
Claude generates a complete
config.yamland.env.exampleRun
mcpbridge validate config.yamlto verify, then deploy
Contributing
See CONTRIBUTING.md.
Roadmap
See ROADMAP.md.
License
MIT — see LICENSE.
This server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- Alicense-qualityCmaintenanceA server for the Machine Chat Protocol (MCP) that provides a YAML-based configuration system for LLM applications, allowing users to define resources, tools, and prompts without writing code.6MIT
- AlicenseBqualityDmaintenanceA Model Context Protocol server that creates tools from API configurations defined in YAML files, allowing easy integration of external APIs into an MCP ecosystem without coding.7447MIT
- Alicense-qualityAmaintenanceOne command to turn any codebase into an MCP server. Not just REST APIs. Not just OpenAPI specs.41Apache 2.0
- Alicense-qualityBmaintenanceAuto-generates MCP servers from any data source, enabling AI clients to query databases, spreadsheets, and APIs with zero code.5MIT
Related MCP Connectors
Self-hosted MCP gateway: turn any API, database or MCP server into AI connectors — no code.
GibsonAI MCP server: manage your databases with natural language
MCP server for generating rough-draft project plans from natural-language prompts.
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/kchaturanga/mcp-gate'
If you have feedback or need assistance with the MCP directory API, please join our Discord server