MCP-DATABASE/
├── pyproject.toml
├── .env.example
├── src/
│   └── mcp_mysql/
│       ├── __init__.py
│       ├── __main__.py
│       ├── config.py      # Variables de entorno
│       ├── db.py          # Conexión MySQL
│       ├── tools.py       # Lógica de las tools
│       └── server.py      # Servidor MCP (FastMCP)
└── README.md

python -m venv .venv
source .venv/bin/activate
pip install -e .

cp .env.example .env

{
  "mcpServers": {
    "mysql": {
      "command": "python",
      "args": ["-m", "mcp_mysql"],
      "cwd": "/ruta/absoluta/a/MCP-DATABASE",
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "tu_password",
        "MYSQL_DATABASE": "tu_database"
      }
    }
  }
}

{
  "mcpServers": {
    "mysql": {
      "command": "/ruta/absoluta/a/MCP-DATABASE/.venv/bin/python",
      "args": ["-m", "mcp_mysql"],
      "cwd": "/ruta/absoluta/a/MCP-DATABASE",
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "tu_password",
        "MYSQL_DATABASE": "tu_database"
      }
    }
  }
}

python -m mcp_mysql