Metadata-Version: 2.4
Name: mcp-server-mysql-py
Version: 0.1.0
Summary: A Python MCP server for MySQL database queries
License: MIT
Requires-Python: >=3.10
Requires-Dist: mcp>=1.0.0
Requires-Dist: pymysql>=1.1.0
Description-Content-Type: text/markdown

# mcp-server-mysql-py

A Python MCP server for MySQL database queries.

## Installation

```bash
pip install mcp-server-mysql-py
```

## Configuration

Set environment variables:

- `MYSQL_HOST` - Database host (default: 127.0.0.1)
- `MYSQL_PORT` - Database port (default: 3306)
- `MYSQL_USER` - Database user (default: root)
- `MYSQL_PASS` - Database password
- `MYSQL_DB` - Database name

## Usage

### MCP Client Configuration

```json
{
  "mcpServers": {
    "mysql": {
      "command": "mcp-server-mysql-py",
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "password",
        "MYSQL_DB": "mydb"
      }
    }
  }
}
```

### Tools

- **mysql_query** - Execute SQL queries
- **mysql_tables** - List all tables
- **mysql_describe** - Show table columns
