legion-mcp

概述

此 MCP 服务器使 AI 助手能够通过一致的接口与多种数据库类型交互。它支持 PostgreSQL、MySQL、SQL Server、BigQuery、Oracle 等数据库，将数据库操作作为 MCP 工具、资源和提示暴露出来。该服务器使用 Legion Query Runner 库进行数据库连接，并提供单数据库和多数据库配置选项，同时具备安全的凭证管理功能。

试试问 AI

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

• execute_query

  Execute a SQL query and return results as a markdown table

  试试:Show me all users from the customers table试试:Find the top 10 products by sales
• execute_query_json

  Execute a SQL query and return results as JSON

  试试:Get user data in JSON format试试:Retrieve product inventory as JSON
• get_table_columns

  Get column names for a specific table

  试试:What columns are in the orders table?试试:List all columns in the products table
• get_table_types

  Get column types for a specific table

  试试:What data types are in the users table?试试:Show column types for the inventory table
• get_query_history

  Get the recent query history

  试试:Show my last 5 queries试试:What queries have I run recently?
• list_databases

  List all available database connections

  试试:What databases are available?试试:Show me all connected databases
• get_database_info

  Get detailed information about a database including schema

  试试:Describe the sales database试试:What's in the marketing database?
• find_table

  Find which database contains a specific table

  试试:Which database has the customers table?试试:Find where the orders table is located
• describe_table

  Get detailed description of a table including column names and types

  试试:Describe the products table structure试试:What columns and types are in the orders table?
• get_table_sample

  Get a sample of data from a table

  试试:Show me 5 rows from the users table试试:Get a sample of the inventory data

可对比工具

安装

uvx database-mcp

{
  "mcpServers": {
    "database-mcp": {
      "command": "uvx",
      "args": [
        "database-mcp"
      ],
      "env": {
        "DB_TYPE": "pg",
        "DB_CONFIG": "{\"host\":\"localhost\",\"port\":5432,\"user\":\"user\",\"password\":\"pw\",\"dbname\":\"dbname\"}"
      }
    }
  }
}

pip install database-mcp

FAQ

支持哪些数据库？

该服务器支持 PostgreSQL、Redshift、CockroachDB、MySQL、RDS MySQL、Microsoft SQL Server、Big Query、Oracle DB 和 SQLite。

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

是的，该服务器通过 DB_CONFIGS 环境变量或命令行参数支持多数据库配置。

legion-mcp 对比