# MySQL MCP (Management Control Plane)

A system for managing multiple MySQL databases with natural language query support, built with FastMCP framework.

## Features

- Manage multiple MySQL database connections
- Store metadata about all managed databases in a central metadata database
- Query data using natural language
- Built with FastMCP framework for easy integration with AI assistants

## Installation

1. Install Python 3.7+
2. Install required packages:
   ```
   pip install -r requirements.txt
   ```

## Setup

1. Create a MySQL database for storing metadata:
   ```
   mysql -u root -p < init_metadata_db.sql
   ```

2. Update `config.ini` with your metadata database connection details:
   ```ini
   [metadata_db]
   host = localhost
   port = 3306
   user = your_username
   password = your_password
   database = metadata_db
   ```

3. Add your database connections to the metadata database using the provided SQL schema.

## Usage

Run the FastMCP server:
```
python mysql_mcp_server.py
```

Once the server is running, you can access the SSE endpoint at:
```
http://localhost:8000/sse
```

The server exposes the following tools:
1. `list_databases()` - List all registered databases
2. `execute_query(database_id, query)` - Execute a SQL query on a specific database
3. `natural_language_query(database_id, natural_query)` - Execute a natural language query on a specific database
4. `get_database_tables(database_id)` - Get list of tables in a specific database

## Configuration

All configuration is stored in `config.ini`:
- `metadata_db`: Connection details for the metadata database
- `app`: Application settings

## Architecture

- `mysql_mcp_server.py`: FastMCP server implementation
- `db_manager.py`: Database connection and management logic
- `nlp_processor.py`: Natural language processing to convert queries to SQL
- `database_models.py`: Data classes representing database entities
- `config.ini`: Configuration file
- `init_metadata_db.sql`: Schema for the metadata database
- `requirements.txt`: Python dependencies

## Extending the System

To improve natural language processing capabilities:
1. Enhance the `natural_language_query` function in `mysql_mcp_server.py`
2. Add more patterns to recognize different query types
3. Consider integrating with advanced NLP libraries like spaCy or NLTK

## Integration with AI Assistants

This FastMCP server can be integrated with AI assistants that support the Model Context Protocol (MCP), allowing them to:
- List available databases
- Execute SQL queries
- Process natural language queries
- Explore database schemas