SmartDB_MCP

概述

SmartDB是一个全面的MCP服务器，提供跨多个主要数据库系统的通用数据库连接，包括MySQL、PostgreSQL、SQL Server、MariaDB、DM8和Oracle。与其他数据库工具不同的是，它集成了高级功能，如OAuth 2.0认证、全面的健康检查、SQL优化建议和索引健康监控。该服务器支持多种连接模式，包括stdio、sse和streamableHttp，使其适用于不同的集成场景。工具集包括SQL执行、数据库健康分析、表结构探索、索引管理、SQL生成和优化功能。

试试问 AI

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

• execute_sql

  Execute SQL commands (SELECT, SHOW, DESCRIBE, EXPLAIN, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, TRUNCATE)

  试试:Show all tables in the database试试:Get the top 10 customers by revenue试试:Create a new user table
• get_db_health

  Analyze database health status and provide diagnostic reports

  试试:Check the health of the database试试:Detect any locks in the database试试:Get database connection status
• get_table_desc

  Search for table structures in the database

  试试:Get the structure of the customers table试试:Describe the orders table columns试试:Show schema for the products table
• get_table_index

  Search for table indexes in the database

  试试:Show indexes on the users table试试:Get all indexes for the orders table试试:List indexes for the inventory table
• get_table_name

  Query all table names in the database or search by name/description

  试试:List all tables in the database试试:Find tables related to customer information试试:Search for tables with 'order' in the name
• get_db_version

  Query database version information

  试试:What version of MySQL is running?试试:Get the PostgreSQL version试试:Check the Oracle database version
• sql_creator

  Generate SQL queries based on different database types

  试试:Create a SQL query to get monthly sales试试:Generate a SELECT statement for customer data试试:Write a query to find all products out of stock
• sql_optimize

  Optimize SQL performance with expert suggestions

  试试:Optimize this query: SELECT * FROM customers WHERE date > '2023-01-01'试试:Improve the performance of the sales report试试:How can I make this query faster?

可对比工具

安装

pip install SmartDB-MCP
smartdb --envfile=/path/to/.env --oauth=true

docker-compose up -d

uv sync
uv run -m core.server --mode stdio

{
  "mcpServers": {
    "smartdb": {
      "name": "smartdb",
      "type": "stdio",
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/SmartDB/",
        "run",
        "-m",
        "core.server",
        "--mode",
        "stdio"
      ],
      "env": {
        "DATABASE_CONFIG_FILE": "/path/to/database_config.json"
      }
    }
  }
}

FAQ

SmartDB支持哪些数据库？

SmartDB支持MySQL、PostgreSQL、SQL Server、MariaDB、DM8和Oracle数据库。

SmartDB是否支持OAuth认证？

是的，SmartDB支持OAuth 2.0认证，用于安全的数据库访问，特别是在使用streamableHttp模式时。

支持哪些不同的连接模式？

SmartDB支持三种连接模式：stdio、sse（服务器发送事件）和streamableHttp，可灵活地与不同客户端集成。

SmartDB_MCP 对比