MySQL MCP Server

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

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
  • 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:

Manual Start

If needed, start the server manually:

Requirements

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

License

MIT

Author

Dewei Yen

Keywords

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