Model Context Protocol moderate risk

Legion

Database MCP provides a unified interface to query and manage multiple databases via the Model Context Protocol, enabling AI assistants to interact with data.

Connections & Capabilities

Connects To

GitHubPostgreSQLMySQLSQLite

Capabilities

readwriteexec

Quickstart

Install

pip install database-mcp

Config

{
    "mcpServers": {
      "database-mcp": {
        "command": "uvx",
        "args": [
          "database-mcp"
        ],
        "env": {
          "DB_CONFIGS": "[{\"id\":\"pg_main\",\"db_type\":\"pg\",\"configuration\":{\"host\":\"localhost\",\"port\":5432,\"user\":\"user\",\"password\":\"pw\",\"dbname\":\"postgres\"},\"description\":\"PostgreSQL Database\"},{\"id\":\"mysql_data\",\"db_type\":\"mysql\",\"configuration\":{\"host\":\"localhost\",\"port\":3306,\"user\":\"root\",\"password\":\"pass\",\"database\":\"mysql\"},\"description\":\"MySQL Database\"}]"
        },
        "disabled": true,
        "autoApprove": []
      }
    }
}

Exposed MCP Tools (10)

high

execute_query

Executes a SQL query against the database and returns the results as a markdown table.

Allows arbitrary SQL execution, potentially leading to data modification or deletion.

high

execute_query_json

Executes a SQL query and returns results as JSON.

Allows arbitrary SQL execution, potentially leading to data modification or deletion.

safe

get_table_columns

Retrieves the column names for a specified table.