# MySQL MCP Server

An MCP server implementation that integrates with MySQL databases, providing secure database access capabilities for LLMs.

## Features

* **Read Operations**
  * Execute read-only SELECT queries
  * List all database tables
  * Show table structures
  * View schema information
* **Write Operations**
  * Execute INSERT/UPDATE/DELETE with transaction support
  * Parameterized queries for data safety
  * Returns affected rows and insert IDs
* **Security**
  * Read-only transaction mode for SELECT queries
  * Query length and result size limits
  * Performance monitoring and logging
  * Automatic transaction handling

## Installation

```bash
npm install -g @kevinwatt/mysql-mcp
```

## Usage with [Dive Desktop](https://github.com/OpenAgentPlatform/Dive)

1. Click "+ Add MCP Server" in Dive Desktop
2. Copy and paste this configuration:

```json
{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@kevinwatt/mysql-mcp"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "your_database"
      }
    }
  }
}
```

3. Click "Save" to install the MCP server

## Tool Documentation

* **mysql_query**
  * Execute read-only SELECT queries
  * Inputs:
    * `sql` (string): SQL SELECT query to execute
  * Limits:
    * Maximum query length: 4096 characters
    * Maximum result rows: 1000
    * Query timeout: 30 seconds

* **mysql_execute**
  * Execute data modification operations
  * Inputs:
    * `sql` (string): SQL statement (INSERT/UPDATE/DELETE)
    * `params` (array, optional): Parameters for the SQL statement
  * Features:
    * Returns affected rows count
    * Returns last insert ID
    * Automatic transaction handling

* **list_tables**
  * List all tables in current database
  * No inputs required

* **describe_table**
  * Show table structure
  * Inputs:
    * `table` (string): Table name to describe

## Usage Examples

Ask your LLM to:

```
"Show me all tables in the database"
"Describe the structure of users table"
"Select all active users from the database"
"Insert a new record into orders table"
```

## Manual Start

If needed, start the server manually:

```bash
npx @kevinwatt/mysql-mcp
```

## Requirements

* Node.js 18+
* MySQL Server
* MCP-compatible LLM service

## License

MIT

## Author

Dewei Yen

## Keywords

* mcp
* mysql
* database
* dive
* llm
* ai
README

Installation
