mcp-database-server

概述

这个 MCP 服务器通过统一接口使 Claude 能够与多个数据库系统交互。它提供执行 SQL 查询、管理数据库架构、导出数据以及存储业务洞察的工具。该服务器既支持通过 NPM 包直接使用，也支持本地开发配置。

试试问 AI

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

• read_query

  Execute SELECT queries to read data

  试试:Show me all customers from the database试试:List all products with prices greater than $50
• write_query

  Execute INSERT, UPDATE, or DELETE queries

  试试:Add a new customer to the customers table试试:Update product prices by 10%
• create_table

  Create new tables in the database

  试试:Create a new orders table with customer_id and product_id columns试试:Design a table for storing product reviews
• alter_table

  Modify existing table schema

  试试:Add a new column to the users table试试:Change the data type of the price column
• drop_table

  Remove a table from the database

  试试:Delete the temporary_orders table试试:Remove the unused backup table
• list_tables

  Get a list of all tables

  试试:Show all tables in the database试试:List all available tables
• describe_table

  View schema information for a table

  试试:Show the structure of the customers table试试:Describe the orders table columns
• export_query

  Export query results as CSV/JSON

  试试:Export customer data to CSV试试:Save product information as JSON
• append_insight

  Add a business insight to memo

  试试:Note that sales increased by 20% this quarter试试:Record that customer satisfaction is at 95%
• list_insights

  List all business insights

  试试:Show me all business insights试试:List previously recorded insights

可对比工具

安装

npm install -g @executeautomation/database-server

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "@executeautomation/database-server",
        "/path/to/your/database.db"
      ]
    }
  }
}

FAQ

支持哪些数据库？

支持 SQLite、SQL Server、PostgreSQL 和 MySQL 数据库。

如何使用 AWS RDS 进行身份验证？

使用 --mysql --aws-iam-auth 标志，并在环境中配置适当的 AWS 凭据。

mcp-database-server 对比