広告掲載
MCP.so
ログイン

Multi-Database MCP Server (by Legion AI)

@TheRaLabs

リポジトリホームページ

基本情報

カテゴリ

データベース

ライセンス

GPL-3.0

トランスポート

stdio

作者

TheRaLabs

Multi-Database MCP Server について

A server that helps people access and query data in databases using the Legion Query Runner with Model Context Protocol (MCP) in Python.

#legion-mcp#database-access#ai-assistant

Multi-Database MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "legion_mcp": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/legion-mcp",
        "run",
        "mcp_server.py"
      ],
      "env": {
        "DB_TYPE": "pg",
        "DB_CONFIG": "{\"host\":\"localhost\",\"port\":5432,\"user\":\"username\",\"password\":\"password\",\"dbname\":\"database_name\"}"
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

Multi-Database MCP Server のツール

10

Execute a SQL query and return results as a markdown table

Execute a SQL query and return results as JSON

Get column names for a specific table

Get column types for a specific table

Get the recent query history

List all available database connections

Get detailed information about a database including schema

Find which database contains a specific table

Get detailed description of a table including column names and types

Get a sample of data from a table

概要

What is Multi-Database MCP Server (by Legion AI)?

Multi-Database MCP Server (by Legion AI) is a server that helps people access and query data in databases using the Legion Query Runner with integration of the Model Context Protocol (MCP) Python SDK. It provides a unified, multi-database interface for AI assistants, enabling natural language database operations across PostgreSQL, MySQL, Microsoft SQL Server, and other databases.

How to use Multi-Database MCP Server (by Legion AI)?

Install using uvx (recommended) or via pip install database-mcp. Configure single or multiple databases via environment variables (DB_TYPE/DB_CONFIG for single, DB_CONFIGS for multiple) or command-line arguments. Run the server with python mcp_server.py or uv run src/database_mcp/mcp_server.py. Tools like execute_query, list_databases, and find_table accept a db_id parameter to target a specific database.

Key features of Multi-Database MCP Server (by Legion AI)

  • Multi-database support – connect to multiple databases simultaneously.
  • AI-ready integration through the Model Context Protocol.
  • Zero-configuration automatic schema discovery.
  • Database-agnostic tools for queries and schema exploration.
  • Secure credential management separate from application code.
  • Simple deployment with popular AI development environments.

Use cases of Multi-Database MCP Server (by Legion AI)

  • AI agents that need to query and analyze data across multiple database types.
  • Providing a unified, natural-language interface to heterogeneous databases.
  • Simplifying database access for teams building AI-powered analytics tools.
  • Enabling stateful interactions between AI assistants and database systems.

よくある質問

1

Which databases are supported?

PostgreSQL (pg), Redshift, CockroachDB, MySQL, RDS MySQL, Microsoft SQL Server, BigQuery, Oracle DB, and SQLite. See the README for the full list of DB_TYPE codes.

2

How do I configure multiple databases at once?

Set the `DB_CONFIGS` environment variable to a JSON array, each element containing `db_type`, `configuration`, and an optional `id` and `description`. The system generates a unique ID if none is provided.

3

How do I specify which database to use when executing a query?

All database-specific tools (e.g., `execute_query`, `get_table_columns`) require a `db_id` parameter. Use the `list_databases` tool to see available IDs, then pass the desired `db_id`.

4

What tools does the server expose to AI assistants?

Tools include `execute_query`, `execute_query_json`, `get_table_columns`, `get_table_types`, `get_query_history`, `list_databases`, `get_database_info`, `find_table`, `describe_table`, and `get_table_sample`.

5

How do I run the server in production?

Run `python mcp_server.py` with the appropriate environment variables or command-line arguments set. Alternatively, use `uv run src/database_mcp/mcp_server.py` with your configuration.

コメント

「データベース」の他のコンテンツ

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539
広告掲載