mcp-dbutils

概述

mcp-dbutils 在 AI 系统和数据库之间提供安全桥梁，允许模型在无需直接访问数据库的情况下分析数据。它通过统一配置支持 SQLite、MySQL、PostgreSQL 等多种数据库类型。该服务器采用安全优先的架构，只执行只读操作，保持连接隔离，并最小化数据暴露。用户可以浏览表、分析架构和执行 SQL 查询，同时确保数据保护和隐私安全。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• dbutils-list-connections

  Lists all available database connections with details while hiding sensitive information.

  试试:Show me all available database connections试试:List my configured databases
• dbutils-list-tables

  Lists all tables in a specified database connection with metadata.

  试试:What tables are in my database?试试:Show all tables in the postgres connection
• dbutils-run-query

  Executes read-only SQL queries and returns structured results.

  试试:Select all customers from California试试:Find the top 10 products by sales
• dbutils-describe-table

  Provides detailed table structure including column names and data types.

  试试:What's the structure of the customers table?试试:Describe the orders table columns
• dbutils-get-ddl

  Retrieves the complete DDL statement for creating a specified table.

  试试:Show me the DDL for the products table试试:Get the create table statement for inventory
• dbutils-list-indexes

  Lists all indexes on a specified table with their properties.

  试试:What indexes exist on the orders table?试试:Show all indexes for customers
• dbutils-get-stats

  Retrieves statistical information about a table including row count and size.

  试试:How big is the orders table?试试:Get statistics for the customers table
• dbutils-list-constraints

  Lists all constraints on a table including primary keys and foreign keys.

  试试:What constraints are on the products table?试试:Show all foreign keys in orders
• dbutils-explain-query

  Provides the execution plan for an SQL query showing how it will be processed.

  试试:Explain this query: SELECT * FROM customers WHERE age > 30试试:How will this query be executed?
• dbutils-get-performance

  Retrieves performance metrics for a database connection.

  试试:What's the performance of my database connection?试试:Show me query statistics for postgres
• dbutils-analyze-query

  Analyzes SQL query performance with execution plan and optimization suggestions.

  试试:Analyze this query for performance: SELECT SUM(amount) FROM orders GROUP BY customer_id试试:How can I optimize this query?

可对比工具

安装

smithery install @donghao1393/mcp-dbutils

uvx mcp-dbutils

docker run -it donghao1393/mcp-dbutils

{
  "mcpServers": {
    "dbutils": {
      "command": "mcp-dbutils",
      "args": []
    }
  }
}

FAQ

此服务器真的是只读的吗？

是的，mcp-dbutils 只支持读操作（SELECT语句）。它会阻止任何写入操作以确保数据安全。

我可以同时连接多个数据库吗？

是的，该服务器支持通过单个 YAML 文件配置的多个数据库连接。

mcp-dbutils 对比