TheRaLabs/legion-mcp

Overview

A Python server that connects the Legion Query Runner to MCP clients, enabling natural language queries against databases. It translates requests into SQL and returns results through the Model Context Protocol.

Best for

Best for
Developers who want to query databases from MCP-enabled AI assistants without writing raw SQL.

Use cases

• Query databases via natural language from MCP-compatible assistants
• Integrate Legion Query Runner with AI coding tools for data exploration
• Automate database lookups in development workflows

How to use

Install

npx @modelcontextprotocol/inspector uv run src/database_mcp/mcp_server.py

Tools exposed

• execute_query
• execute_query_json
• get_table_columns
• get_table_types
• get_query_history
• list_databases
• get_database_info
• find_table
• describe_table
• get_table_sample
• sql_query
• explain_query
• optimize_query
• select_database

Example client config

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

Notes

A Python server that connects the Legion Query Runner to MCP clients, enabling natural language queries against databases. It translates requests into SQL and returns results through the Model Context Protocol.

92 stars on GitHub. Last updated 2025-05-11. Licensed GPL-3.0.

Use cases

• Query databases via natural language from MCP-compatible assistants
• Integrate Legion Query Runner with AI coding tools for data exploration
• Automate database lookups in development workflows

Pros

• Simplifies database access for non-SQL users through MCP
• Lightweight Python implementation with clear protocol boundaries
• Open source with 92 stars and active community potential

Cons

• Limited to Legion Query Runner supported databases
• Requires MCP client setup and Python environment
• Small user base may mean fewer examples and slower issue resolution

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.