MCP Mysql App

🚀 MySQL MCP Tool Server

This is an implementation of a Model Context Protocol (MCP) tool server that interacts with a MySQL database through an AI interface.

🚀 Quick Start

The project offers a set of tools that allow AI systems to connect to and query a MySQL database via the Model Context Protocol. It enables AI assistants to execute SQL queries and check the database connection status.

✨ Features

• Simple yet powerful MySQL tool integration
• Type-safe tool definitions
• Enhanced error handling
• Support for handling request termination signals
• Session awareness

📦 Installation

1. Clone this repository.
2. Install the dependencies:

npm install

💻 Usage Examples

Cursor Configuration

When using it in Cursor, you need to make the following settings in the settings.json file:

{
  "mcpMySQL": {
    "host": "localhost",
    "port": 3306,
    "user": "root",
    "password": "password"
  }
}

Other AI Platform Configuration

When using it in other AI platforms, you need to configure it according to the platform's requirements. Usually, you need to provide MySQL connection information (host, port, user, and password).

Available Tools

• sql_check_connection: Check if the MySQL connection is working properly.
• sql_query: Execute an SQL query on the connected database.

Using MySQL Tools in an AI Environment

Once you have configured the MySQL tools, you can start using them in your AI environment. Here are some examples:

Basic Usage

In Cursor, you can simply prompt Claude to perform MySQL-related tasks:

• Check if the connection is working: "Check if the MySQL connection is working properly."
• View all databases: "Show all databases on this MySQL server."
• View tables: "List all tables in the current database."
• Query data: "Show the first 10 records of the users table."
• Create a table: "Create a new table named 'products' with columns id, name, price, and description."
• Insert data: "Insert a new product with the name 'Smartphone', price 499.99, and description 'Latest model'."
• Update a record: "Update the price of the 'Smartphone' product to 449.99."

These examples demonstrate how to naturally interact with MySQL through an AI assistant once the tools are properly configured.

📚 Documentation

If you encounter issues while using this tool, please do the following:

• Check if your MySQL connection details are correct.
• Ensure that Node.js is properly installed.
• Check your MCP configuration in the AI platform.
• Review any error messages that may be shown in the log files.
• Verify the network connection to the MySQL server.

📄 License

This project is licensed under the MIT License. For more details, please refer to the LICENSE file.