# MySQL MCP Server

Model Context Protocol server for MySQL database access.

## Features

- Execute SQL queries with prepared statements
- List database tables
- Describe table schemas
- Get table statistics (row counts, sizes)
- Connection pooling for performance

## Installation

```bash
npm install
npm run build
```

## Configuration

Configure via environment variables:

- `MYSQL_HOST` - MySQL server hostname (default: localhost)
- `MYSQL_PORT` - MySQL server port (default: 3306)
- `MYSQL_USER` - MySQL username (default: root)
- `MYSQL_PASS` - MySQL password (default: empty)
- `MYSQL_DB` - MySQL database name (default: empty)

## Usage with Claude Code

Add to `.claude/.mcp.json`:

```json
{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/path/to/mysql-mcp-server/dist/server.js"
      ],
      "env": {
        "MYSQL_HOST": "your-host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your-user",
        "MYSQL_PASS": "your-password",
        "MYSQL_DB": "your-database"
      }
    }
  }
}
```

## Available Tools

### `mysql_query`

Execute any SQL query with optional prepared statement parameters.

**Example:**
```sql
SELECT * FROM users WHERE id = ?
```

### `mysql_show_tables`

List all tables in the current database.

### `mysql_describe_table`

Get the schema/structure of a specific table.

### `mysql_table_info`

Get detailed table information including row counts and sizes.

## License

MIT