mysql-mcp

mysql-mcp

5
databases

The MySQL MCP Server is designed to integrate with MySQL databases, enabling secure database access for large language models (LLMs). Key features include read and write operations, security measures, and compatibility with Dive Desktop. The server supports Node.js and MySQL.

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

Usage with Dive Desktop

  1. Click "+ Add MCP Server" in Dive Desktop
  2. Copy and paste this configuration:
  3. Click "Save" to install the MCP server

Tool Documentation

  • mysql_query - Execute read-only SELECT queries
  • mysql_execute - Execute data modification operations
  • list_tables - List all tables in current database
  • describe_table - Show table structure

Requirements

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