legion-mcp

Overview

This MCP server enables AI assistants to interact with multiple database types through a consistent interface. It supports PostgreSQL, MySQL, SQL Server, BigQuery, Oracle, and others, exposing database operations as MCP tools, resources, and prompts. The server uses the Legion Query Runner library for database connections and provides both single and multi-database configuration options with secure credential management.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• execute_query

  Execute a SQL query and return results as a markdown table

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

  Execute a SQL query and return results as JSON

  Try:Get user data in JSON formatTry:Retrieve product inventory as JSON
• get_table_columns

  Get column names for a specific table

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

  Get column types for a specific table

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

  Get the recent query history

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

  List all available database connections

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

  Get detailed information about a database including schema

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

  Find which database contains a specific table

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

  Get detailed description of a table including column names and types

  Try:Describe the products table structureTry:What columns and types are in the orders table?
• get_table_sample

  Get a sample of data from a table

  Try:Show me 5 rows from the users tableTry:Get a sample of the inventory data

Comparable tools

Installation

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

Which databases are supported?

The server supports PostgreSQL, Redshift, CockroachDB, MySQL, RDS MySQL, Microsoft SQL Server, Big Query, Oracle DB, and SQLite.

Can I connect to multiple databases simultaneously?

Yes, the server supports multi-database configurations through the DB_CONFIGS environment variable or command-line argument.

Compare legion-mcp with