mysql-mcp-server

mysql-mcp-server

3.2

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

  1. connect_database

    Connects to a database using host, port, and user parameters.

  2. connect_by_profile

    Connects using a saved profile name.

  3. disconnect_database

    Disconnects the current database connection.

  4. get_connection_status

    Retrieves the status of the database connection.

  5. execute_query

    Executes a MySQL query.