🐳 MCP MySQL Server (Dockerized)

This project provides a fully containerized MCP (Model Context Protocol) server using Python, FastMCP, and MySQL.

📦 Features

• Run SQL queries via MCP tools
• Retrieve table schemas
• List all tables in a connected MySQL database
• Containerized using Docker and ready for deployment

---

🚀 Getting Started

1. Clone the Repository and Navigate

git clone <this-repo-url>
cd mcp_docker

2. Configure Environment

Copy .env.example to .env and fill in your MySQL credentials:

DB_HOST=your-db-host
DB_USER=your-db-user
DB_PASSWORD=your-db-password
DB_NAME=your-db-name

3. Build and Run with Docker

docker build -t mcp-mysql-server .
docker run --env-file .env -p 8000:8000 mcp-mysql-server

4. Using Docker Compose (optional)

Start both MySQL and MCP server with one command:

docker compose up --build

Note: If using Docker Compose, set DB_HOST=db in your .env file.

---

🧪 Tools Exposed

• run_sql_query(query: str) -> list
• get_table_schema(table_name: str) -> list
• list_tables() -> list

You can interact with the server via an MCP-compatible client.

---

📁 File Structure

mcp_docker/
├── Dockerfile
├── requirements.txt
├── .env.example
├── docker-compose.yml
├── mcp_mysql_server.py
└── README.md

---

🛠 Requirements

• Python 3.10+
• Docker
• MySQL server or container
• fastmcp

---

📜 License

MIT — feel free to use and modify!

---

Happy coding! 🎉