Skip to main content
Glama
datasource-mcp

datasource-mcp

datasource-mcp

MySQL datasource MCP server for AI clients (Cursor, Claude Desktop, etc.).

Database Support: Currently supports MySQL only. Support for PostgreSQL, SQLite, and other databases is planned for future releases.

Install

pip install datasource-mcp

If the package is not yet available on your PyPI mirror, use the official index:

pip install datasource-mcp -i https://pypi.org/simple/

Or run without installing (requires uv):

uvx datasource-mcp

Note: uvx datasource-mcp downloads the package and immediately starts the MCP stdio server. It will block the terminal while waiting for a client connection. Configure it in your MCP client instead of running it manually.

Related MCP server: MySQL MCP Server

Cursor / MCP Client Config

Option 1: pip install (local environment)

Run pip install datasource-mcp first, then add this to mcp.json:

{
  "mcpServers": {
    "datasource-mcp": {
      "command": "datasource-mcp",
      "env": {
        "DB_HOST": "127.0.0.1",
        "DB_PORT": "3306",
        "DB_USER": "root",
        "DB_PASSWORD": "your_password",
        "DB_NAME": "your_database"
      }
    }
  }
}

No pip install required — uvx fetches the package from PyPI and runs it automatically. Requires uv to be installed.

{
  "mcpServers": {
    "datasource-mcp": {
      "command": "uvx",
      "args": ["datasource-mcp"],
      "env": {
        "DB_HOST": "127.0.0.1",
        "DB_PORT": "3306",
        "DB_USER": "root",
        "DB_PASSWORD": "your_password",
        "DB_NAME": "your_database"
      }
    }
  }
}

After updating the config, click Refresh in the MCP panel to apply changes.

Environment Variables

Variable

Default

Description

DB_HOST

127.0.0.1

MySQL host

DB_PORT

3306

MySQL port

DB_USER

root

MySQL user

DB_PASSWORD

root

MySQL password

DB_NAME

aix

Database name

DB_CONNECT_TIMEOUT

5

Connection timeout (seconds)

Tools

db_exe

Execute SQL and return a JSON string:

{"success": true, "row_count": 1, "truncated": false, "rows": [...]}

Error response:

{"success": false, "error": "error message"}

Local Development

uv sync
uv run datasource-mcp
# or
uv run python -m datasource_mcp

Requires Python >= 3.11.

Available Tools

1 tool
db_exeB

执行 SQL 并返回 JSON 字符串结果。

Inputs: sql (required), max_rows. Returns: result

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.2/5.0

    Scored across 1 tool

    Disambiguation5/5

    With only one tool, there is no ambiguity in tool selection. The tool's description clearly states it executes SQL and returns JSON.

    Naming Consistency4/5

    A single tool name, db_exe, follows snake_case and is understandable, but it lacks a clear verb_noun pattern. However, consistency is not an issue with only one tool.

    Tool Count2/5

    The server has only one tool, which is too few for a datasource MCP server. Its apparent scope would typically require multiple tools for connection management, schema inspection, and querying.

    Completeness2/5

    The tool surface is severely limited; it only executes SQL. There are no tools to list tables, describe schemas, or manage data sources, causing significant gaps for agents.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      D
      maintenance
      MCP server that allows Claude AI to interact directly with MySQL databases, enabling query execution and table information retrieval through natural language.
      1
      4
      ISC
    • A
      license
      Not graded
      quality
      D
      maintenance
      A MySQL MCP server for secure database interaction, enabling schema inspection, query execution, and RBAC via AI coding assistants.
      7
      MIT
    • A
      license
      B
      quality
      C
      maintenance
      MCP server that connects AI agents to MySQL databases for schema exploration, data querying, and SQL execution via natural language.
      7
      22 PyPI
      2
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      A production-ready MCP server for MySQL database integration with AI agents, enabling database exploration, CRUD operations, schema management, and performance monitoring through natural language.
      MIT