mysql-mcp-server

mysql-mcp-server

8
databases

The project is a Model Context Protocol server designed for read-only access to MySQL databases. It supports schema discovery and execution of SELECT queries, primarily for LLM integration. The server emphasizes security by allowing only read-only operations.

@davewind/mysql-mcp-server

A Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute queries.

Key Features

  • Read-Only Database Access: Enforces read-only operations and transactions
  • Schema Discovery: Identifies and exposes database table structures
  • SQL Query Execution: Allows execution of SELECT statements
  • MCP Compliance: Integrates seamlessly with compatible LLMs
  • Simple Configuration: Easy setup with minimal configuration

Tools

  • query: Execute read-only SQL queries

Resources

  • Table schema information including column names and data types, automatically discovered

Install

  • Install using npm: "npm install @davewind/mysql-mcp-server -g"

Configuration

  • MCP settings configuration for MySQL

System Architecture

  • Acts as an intermediary between LLMs and MySQL databases, processing requests according to MCP

Security

  • Implements strict security model for read-only access

Integration

  • Designed to work with any LLM system supporting MCP