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.
MySQL Model Context Protocol (MCP) server allows large language models (LLM) to execute SQL queries on a local MySQL database.
The MySQL MCP Server is a tool designed to facilitate the execution of SQL queries by large language models (LLMs) on a local MySQL or MariaDB database. It supports the Model Context Protocol (MCP) and enables seamless integration with LLMs through standard input/output communication, avoiding the need for port binding. The server manages multiple database connections through named profiles, allowing users to save and reuse connection information. It also provides a set of tools for database connection management, profile management, and SQL query execution, making it a versatile solution for developers working with LLMs and databases.
Features
- MySQL query execution: Direct execution of SQL queries from LLM.
- Database information retrieval: View database lists, table lists, and table structures.
- MCP compliance: Supports Model Context Protocol for LLM integration.
- Stdio communication: Uses standard input/output for communication, avoiding port binding.
- Connection profile management: Manage multiple connection settings with profile names.
Tools
connect_database
Connects to a database using host, port, and user parameters.
connect_by_profile
Connects using a saved profile name.
disconnect_database
Disconnects the current database connection.
get_connection_status
Retrieves the status of the database connection.
execute_query
Executes a MySQL query.