mysql-mcp-server
If you are the rightful owner of mysql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
The @davewind/mysql-mcp-server is a specialized server designed to facilitate read-only interactions with MySQL databases through the Model Context Protocol (MCP). It allows Language Model Machines (LLMs) to access and inspect database schemas and execute SELECT queries without the risk of data modification. The server is compliant with MCP standards, ensuring seamless integration with compatible LLMs. It features automatic schema discovery, SQL query execution, and a simple configuration process, making it an efficient tool for developers looking to integrate database access into their LLM applications. The server enforces strict security measures to maintain data integrity by validating SQL queries and executing them within READ ONLY transactions.
Features
- 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.
Tools
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.
