Mysql MCP

🚀 MySQL MCP Server

An MCP server implementation integrated with a MySQL database, providing secure database access capabilities for large language models (LLMs).

🚀 Quick Start

The MySQL MCP Server is designed to offer secure database access for LLMs. It integrates with a MySQL database and can be easily set up and used in conjunction with compatible tools.

✨ Features

• Read Operations:
  • Execute read - only SELECT queries.
  • List all database tables.
  • View table structures.
  • Display schema information.
• Write Operations:
  • Execute INSERT/UPDATE/DELETE operations with transaction support.
  • Use parameterized queries to ensure data security.
  • Return the number of affected rows and the inserted ID.
• Security:
  • Read - only transaction mode for SELECT queries.
  • Query length and result set size limits.
  • Performance monitoring and logging.
  • Automatic transaction handling.

📦 Installation

npm install -g @kevinwatt/mysql-mcp

💻 Usage Examples

Basic Usage

Let your LLM execute the following instructions:

"Show all tables in the database"
"Describe the structure of the users table"
"Query all active users"
"Insert a new record into the orders table"

Advanced Usage

If you need to start the server manually:

npx @kevinwatt/mysql-mcp

📚 Documentation

Usage with Dive Desktop

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

{
  "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 a read - only SELECT query.
  • Input:
    • sql (string): The SELECT SQL query to execute.
  • Limits:
    • Maximum query length: 4096 characters.
    • Maximum number of result rows: 1000.
    • Query timeout: 30 seconds.
• mysql_execute:
  • Execute data modification operations.
  • Input:
    • sql (string): SQL statements (INSERT/UPDATE/DELETE).
    • params (array, optional): Parameters for the SQL statement.
  • Features:
    • Return the number of affected rows.
    • Return the last inserted ID.
    • Automatic transaction handling.
• list_tables:
  • List all tables in the current database.
  • No input required.
• describe_table:
  • Display the table structure.
  • Input:
    • table (string): The name of the table to describe.

🔧 Technical Details

Requirements

• Node.js version 18+.
• MySQL service.
• LLM service compatible with MCP.

📄 License

MIT

👨‍💻 Author

Dewei Yen

🔑 Keywords

• mcp
• mysql
• database
• dive
• llm
• ai