Provides secure database access for MariaDB, including tools for listing tables, describing table schemas, executing SQL queries with named parameters, and analyzing query execution plans.
Provides secure database access for MySQL, including tools for listing tables, describing table schemas, executing SQL queries with named parameters, and analyzing query execution plans.
Provides secure database access for PostgreSQL, including tools for listing tables, describing table schemas, executing SQL queries with named parameters, and analyzing query execution plans.
Provides secure database access for SQLite, including tools for listing tables, describing table schemas, executing SQL queries with named parameters, and analyzing query execution plans.
数据库访问服务 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.