mysql-mcp-server
by @davewind
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.
Last updated: N/A
What is mysql-mcp-server?
The MySQL MCP Server is an intermediary between LLMs and MySQL databases, processing requests according to the Model Context Protocol. It provides read-only access to MySQL databases, allowing LLMs to inspect schemas and execute SELECT queries.
How to use mysql-mcp-server?
Install the server globally using npm install @davewind/mysql-mcp-server -g. Configure the MCP settings in a JSON file, specifying the command and arguments to run the server with the database connection string. Use the provided query tool to execute SQL queries against the connected database.
Key features of mysql-mcp-server
Read-Only Database Access: Enforces read-only operations through SQL validation and READ ONLY transactions
Schema Discovery: Automatically identifies and exposes database table structures
SQL Query Execution: Provides a query tool that accepts and executes SELECT statements
Model Context Protocol Compliance: Implements the MCP specification for seamless integration with compatible LLMs
Simple Configuration: Easy setup with minimal configuration required
Use cases of mysql-mcp-server
Allowing LLMs to understand and interact with data stored in MySQL databases.
Enabling LLMs to generate SQL queries based on natural language input.
Providing LLMs with context about database schemas for improved reasoning.
Integrating MySQL data into LLM-powered applications without compromising data security.
FAQ from mysql-mcp-server
What is the Model Context Protocol (MCP)?
What is the Model Context Protocol (MCP)?
MCP is a specification for enabling LLMs to interact with external data sources and tools.
What type of SQL queries are supported?
What type of SQL queries are supported?
Only SELECT queries are supported to ensure read-only access.
How is data security ensured?
How is data security ensured?
The server enforces read-only operations through SQL validation and READ ONLY transactions. No data modification operations are allowed.
What versions of Node.js are supported?
What versions of Node.js are supported?
Node.js version 18 and above are supported.
How does the server integrate with LLMs?
How does the server integrate with LLMs?
The server communicates with LLMs through JSON-RPC over stdio, following the MCP specification.