MCP 服务器

DB-Mcp

MCP Database Server is a service that provides secure database access for AI assistants and LLM-based tools, supporting SQLite, PostgreSQL, MySQL and MariaDB, and featuring query verification, audit logs and security control functions.

README

数据库访问服务 DB Mcp

MCP Database Server 是一个为AI助手和基于LLM的工具提供安全数据库访问的服务，支持SQLite、PostgreSQL、MySQL和MariaDB，具有查询验证、审计日志和安全控制功能。 MCP Database Server is a service that provides secure database access for AI assistants and LLM-based tools, supporting SQLite, PostgreSQL, MySQL and MariaDB, and featuring query verification, audit logs and security control functions.## 工具列表 Tool List

本MCP服务封装下列工具，可让模型通过标准化接口调用以下功能。本MCP服务封装下列工具，可让模型通过标准化接口调用以下功能。

工具 Tool	描述 Description
db_tables	List all tables in the database, optionally filtered by schema. Returns qualified table names.
db_describe_table	Get column information for a specific table including column names, data types, and nullability.
db_execute	Execute a SQL statement. Supports SELECT (read), INSERT/UPDATE/DELETE (write if enabled), and DDL (if enabled). Use named parameters with :param syntax.
db_explain	Get query execution plan and performance information using EXPLAIN. Helps analyze query performance and optimization opportunities.

检查服务 ## Inspector

工具在线测试： https://mcp.xiaobenyang.com/inspector/1777316659322883

Online Tool test https://mcp.xiaobenyang.com/inspector/1777316659322883

服务配置 MCP Server Config

如何获取 XBY-APIKEY ？ How to get XBY-APIKEY ?

访问小笨羊科技网站 https://xiaobenyang.com，注册用户即可获得APIKEY Visit XiaoBenYang website https://xiaobenyang.com, register and get the APIKEY.

SSE

{
  "mcpServers": {
    "数据库访问服务": {
      "headers": {
        "XBY-APIKEY": "<YOUR_XBY_APIKEY>"
      },
      "type": "sse",
      "url": "https://mcp.xiaobenyang.com/1777316659322883/sse"
    }
  }
}

STREAMABLE HTTP

{
  "mcpServers": {
    "数据库访问服务": {
      "headers": {
        "XBY-APIKEY": "<YOUR_XBY_APIKEY>"
      },
      "type": "streamable_http",
      "url": "https://mcp.xiaobenyang.com/1777316659322883/mcp"
    }
  }
}

STDIO

{
    "mcpServers": {
        "数据库访问服务": {
          "command": "npx",
          "args": [
            "-y",
            "xiaobenyang-mcp"
          ],
          "env": {
            "XBY_APIKEY": "<YOUR_XBY_APIKEY>",
            "mcpId": "1777316659322883",
          },
          "transport": "stdio"
        }
      }
}