Mysql MCP Server

🚀 @davewind/mysql-mcp-server

A Model Context Protocol (MCP) server that provides read-only access to MySQL databases. This server enables Large Language Models (LLMs) to inspect the database schema and execute read-only queries.

🚀 Quick Start

The @davewind/mysql-mcp-server is designed to offer read - only access to MySQL databases, allowing LLMs to interact with the database in a secure and controlled manner.

✨ Features

1. Read - Only Database Access: Enforces read - only operations through SQL validation and READ ONLY transactions.
2. Schema Discovery: Automatically identifies and exposes the database table structure.
3. SQL Query Execution: Provides a query tool that accepts and executes SELECT statements.
4. Model Context Protocol Compliance: Implements the MCP specification for seamless integration with compatible LLMs.
5. Simple Configuration: Easy to set up with minimal configuration required.

🛠️ Tools

query

• Execute read - only SQL queries to access the connected database.
• Input: sql (string): The SQL query to be executed.
• All queries are executed within a READ ONLY transaction.

📦 Resources

The server provides schema information for each table:

• Table Schema (mysql://user:password@localhost:port/database)
  • JSON schema information for each table.
  • Includes column names and data types.
  • Automatically discovered from database metadata.

📦 Installation

npm install @davewind/mysql-mcp-server -g

⚙️ Configuration

MCP setup configuration file:

Recommended to use

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@davewind/mysql-mcp-server", "mysql://user:password@localhost:port/database"]
    }
  }
}

🧪 Testing

Replace mysql://user:password@localhost:port/ and run npm run inspector

  "scripts": {
    "inspector": "npx @modelcontextprotocol/inspector@0.10.2 build/index.js mysql://user:password@localhost:port/database"
  }

📋 Environment Requirements

Node.js v18 +

🏗️ System Architecture

The MySQL MCP server acts as an intermediary between the LLM and the MySQL database, handling requests according to the MCP protocol.

👥 Component Interaction

No detailed content provided.

🔒 Security Model

The MySQL MCP server implements a strict security model to ensure read - only database access.

Security measures include:

1. SQL query validation, allowing only SELECT statements.
2. All queries are executed within a READ ONLY transaction.
3. Data modification operations (INSERT, UPDATE, DELETE, etc.) are not supported.
4. Database schema modification operations (CREATE, ALTER, DROP, etc.) are not supported.

🔌 Integration with LLMs

The MySQL MCP server is designed to work with any LLM system that supports the Model Context Protocol. It communicates via JSON - RPC over stdio according to the MCP specification.

📄 License

MIT