mysql-mcp-server

A Model Context Protocol server that provides read-only access to Mysql databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.Read-Only Database Access: Enforces read-only operations through SQL validation and READ ONLY transactions 2.Schema Discovery: Automatically identifies and exposes database table structures 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 setup with minimal configuration required

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

The server provides schema information for each table in the database:

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

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

MCP settings configuration file:

> recommended use

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

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

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

node v18 +

> The MySQL MCP Server acts as an intermediary between LLMs and MySQL databases, processing requests according to the Model Context Protocol. <p> <img src="./docs/High-Level Architecture.png"