Content
# 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
```bash
pip install datasource-mcp
```
If the package is not yet available on your PyPI mirror, use the official index:
```bash
pip install datasource-mcp -i https://pypi.org/simple/
```
Or run without installing (requires [uv](https://docs.astral.sh/uv/)):
```bash
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.
## Cursor / MCP Client Config
### Option 1: pip install (local environment)
Run `pip install datasource-mcp` first, then add this to `mcp.json`:
```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"
}
}
}
}
```
### Option 2: uvx without installing (recommended)
No `pip install` required — `uvx` fetches the package from PyPI and runs it automatically. Requires [uv](https://docs.astral.sh/uv/getting-started/installation/) to be installed.
```json
{
"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:
```json
{"success": true, "row_count": 1, "truncated": false, "rows": [...]}
```
Error response:
```json
{"success": false, "error": "error message"}
```
## Local Development
```bash
uv sync
uv run datasource-mcp
# or
uv run python -m datasource_mcp
```
Requires Python >= 3.11.
