Metadata-Version: 2.4
Name: vikashruhil-mysql-mcp
Version: 1.0.0
Summary: Secure read-only MySQL MCP server with query impact analysis
License: MIT
Requires-Python: >=3.10
Description-Content-Type: text/markdown
Requires-Dist: mcp[cli]>=1.2.0
Requires-Dist: aiomysql>=0.2.0
Requires-Dist: httpx

# vikashruhil-mysql-mcp

Secure read-only MySQL MCP server with query impact analysis.

## Features

- `list_tables` — list all tables in the connected database
- `describe_table` — show schema for a table (columns, types, keys)
- `run_query` — execute read-only SELECT/SHOW queries
- `explain_query` — run EXPLAIN on a SELECT to inspect execution plan
- `list_indexes` — list indexes for a table
- **Write operations blocked** — INSERT/UPDATE/DELETE/DROP/etc. are rejected

## Usage via uvx (zero install)

```bash
DB_HOST=localhost DB_USER=myuser DB_PASS=secret DB_NAME=mydb uvx vikashruhil-mysql-mcp
```

## Environment Variables

| Variable | Default     | Required |
|----------|-------------|----------|
| DB_HOST  | `localhost` | No       |
| DB_USER  | —           | Yes      |
| DB_PASS  | —           | Yes      |
| DB_NAME  | —           | Yes      |
| DB_PORT  | `3306`      | No       |

## Claude Code Plugin Integration

Install the `ai-agent-manager-plugin` and set env vars in your shell profile:

```bash
export DB_USER=myuser
export DB_PASS=mypassword
export DB_NAME=mydb
```

The plugin's `.mcp.json` will auto-run `uvx vikashruhil-mysql-mcp` on first use.

## Publishing

```bash
pip install hatch
cd mcps/mysql
hatch build
hatch publish   # prompts for PyPI token
```
