A lightweight AI-powered MCP (Machine Control Protocol) server for automating MySQL databases using natural language. Ideal for testing, prototyping, and managing SQL workflows with Claude, OpenAI, DeepSeek, and other agents.

🐬 MySQL MCP Server (FastMCP-Powered)

Leverage the power of AI to automate your MySQL workflows with FastMCP.
This tool enables AI agents like DeepSeek, OpenAI, or DeepSeek to interact with your MySQL database using natural language, making database management seamless and intelligent.

Whether you're generating synthetic data, querying your tables, or performing updates, this MCP server allows AI to operate on your database through standardized interfaces — all from your local machine.

🔎 Best use for generating synthetic data for testing your apis.

💡 Key Features

• Automates SQL tasks via AI (DeepSeek, OpenAI, DeepSeek, etc.)
• Works over Stdio, ideal for local desktop integration
• Generates synthetic data based on your schema and recent values
• No manual SQL knowledge required
• Highly useful for test environments and data prototyping

🛠️ Supported Tools

These are internally used by the AI to understand and manipulate your database efficiently.

⚙️ Configuration & Setup

📋 Prerequisites

• Python 3.10+
• MySQL (running locally or remotely)
• Anthropic Claude Desktop app (or DeepSeek)
• UV (Python package manager), install with curl -LsSf https://astral.sh/uv/install.sh | sh

Steps

1. Clone this repository

   git clone https://github.com/Ashutosh-rajput/mysql-mcp.git
   cd mysql-mcp
   uv pip install -r requirements.txt
   

2. Fill the .env

   MYSQL_HOST=localhost
   MYSQL_PORT=3306
   MYSQL_USER=root
   MYSQL_PASSWORD=yourpassword
   MYSQL_DATABASE=yourdatabase
   

3. **Connect to