UBOS Asset Marketplace: MySQL MCP Server - Unleash the Power of LLMs with Seamless Database Integration

In the rapidly evolving landscape of AI-driven applications, the ability for Large Language Models (LLMs) to interact with and leverage structured data is paramount. Enter the MySQL Model Context Protocol (MCP) Server, a crucial tool that bridges the gap between LLMs and your MySQL databases. As part of the UBOS Asset Marketplace, this MCP server empowers you to build more intelligent, data-aware AI agents, transforming how you extract insights and automate tasks.

What is an MCP Server?

An MCP (Model Context Protocol) server acts as a standardized bridge between AI models and external resources, which can include databases, APIs, and other tools. MCP is an open protocol that standardizes how applications provide context to LLMs. It enables LLMs to perform actions such as querying a database, retrieving specific information, or triggering actions based on the data it processes. By providing a structured way for LLMs to access and interact with data, MCP servers unlock new possibilities for AI-driven applications.

The MySQL MCP Server specifically focuses on enabling LLMs to connect to and interact with MySQL databases. It handles the complexities of database connections, query execution, and data retrieval, allowing developers to focus on building the core logic of their AI agents.

Key Features and Benefits

• Seamless MySQL Integration: Connect your LLMs directly to your MySQL or MariaDB databases, enabling real-time data access and manipulation.
• SQL Query Execution: Execute SQL queries generated by LLMs, allowing them to extract specific information, perform calculations, and update data within your databases.
• Database Schema Discovery: LLMs can explore the structure of your databases, including tables, columns, and data types, enabling them to generate more accurate and relevant queries.
• MCP Compliance: Adherence to the Model Context Protocol ensures seamless integration with other MCP-compliant tools and services.
• stdio Communication: Communicate with LLMs via standard input/output, eliminating the need for port bindings and simplifying deployment.
• Connection Management: Save and reuse database connection information for streamlined workflow and reduced setup time.
• Configuration Flexibility: Utilize configuration files for easy management of connection parameters and server settings.
• Enhanced Security: By using stdio communication, the risk of network-level attacks is reduced.
• Simplified Process Communication: Streamlines communication between LLMs and the database, making the entire process efficient.
• Connection State Control: Separate server startup from database connection, connect to multiple databases after server is live.

Use Cases

• AI-Powered Data Analysis: Empower LLMs to analyze your business data, identify trends, and generate actionable insights directly from your MySQL databases.
• Automated Reporting: Automate the creation of reports by enabling LLMs to query your databases and format the results into human-readable summaries.
• Intelligent Customer Support: Equip AI agents with the ability to access customer data in real-time, enabling them to provide personalized and effective support.
• Dynamic Content Generation: Generate dynamic website content based on data stored in your MySQL databases, ensuring that your website is always up-to-date.
• Data-Driven Decision Making: Provide LLMs with the data they need to make informed decisions, improving the accuracy and effectiveness of your AI-powered applications.
• Enhance UBOS AI Agents: Use the MySQL MCP Server to build AI Agents that can access and manipulate MySQL data to perform tasks.

Getting Started

Prerequisites

• Node.js: Version 20.0.0 or higher.
• MySQL: Version 5.7 or higher, or a MariaDB server.

Installation and Usage

1. Temporary Execution with NPX:

   bash npx -y https://github.com/yuki777/mysql-mcp-server --host 127.0.0.1 --port 13306 --user root

2. Configuration Options:

   • -h, --host <host>: MySQL host (default: localhost)
   • -p, --port <port>: MySQL port (default: 13306)
   • -u, --user <user>: MySQL user (default: root)
   • --password <password>: MySQL password (default: empty string)
   • -d, --database <database>: Default database (optional)
   • -c, --config <path>: Configuration file path (optional)
   • --auto-connect: Automatically connect to the database on server startup (default: false)
   • --server-port <port>: MCP server port (not used in stdio mode) (default: 3000)
   • --server-host <host>: MCP server host (not used in stdio mode) (default: localhost)
   • --query-timeout <ms>: Query timeout in milliseconds (default: 30000)
   • --max-results <count>: Maximum number of result rows (default: 1000)
   • --debug: Debug mode (default: false)

3. Saving and Reusing Connection Information:

   The MySQL MCP Server saves database connection information locally, allowing for automatic reuse on subsequent startups. This information is stored in the .mysql-mcp-connections.json file in the user’s home directory.

4. Using a Configuration File:

   Create a JSON configuration file (e.g., mysql-mcp-config.json) with the following structure:

   { “server”: { “port”: 3000, “host”: “localhost” }, “mysql”: { “host”: “localhost”, “port”: 13306, “user”: “root”, “password”: “yourpassword”, “database”: “mydb” }, “debug”: false, “queryTimeout”: 30000, “maxResultSize”: 1000 }

   Then, run the server with the configuration file:

   bash npx -y https://github.com/yuki777/mysql-mcp-server -c ./mysql-mcp-config.json

Communication Method

The MySQL MCP Server operates in “stdio” mode, conforming to the MCP standard. This means it communicates via standard input/output, eliminating the need for port bindings. This offers several advantages:

• Avoids port conflicts.
• Enhances security by eliminating network communication.
• Simplifies inter-process communication with LLMs.

Important Notes

• Communication occurs via JSON messages.
• Send one JSON message per line.
• Error information and connection logs are output to standard error (stderr).

Available MCP Tools

Database Connection Management

SQL Query Operations

Connecting on Demand

The MySQL MCP Server allows you to start the server independently of the database connection. This enables you to:

• Start the server without initial connection details.
• Connect to different databases after the server is already running.
• Simplify installation with just the following command: npx -y https://github.com/yuki777/mysql-mcp-server

Unleash the power of UBOS

The MySQL MCP Server integrates seamlessly with the UBOS platform. UBOS is a full-stack AI Agent development platform focused on bringing AI Agents to every business department.

With UBOS, you can:

• Orchestrate AI Agents: Design and manage complex workflows involving multiple AI Agents.
• Connect to Enterprise Data: Seamlessly integrate your AI Agents with various data sources, including your MySQL databases via the MySQL MCP Server.
• Build Custom AI Agents: Develop custom AI Agents tailored to your specific needs, leveraging your LLM model.
• Create Multi-Agent Systems: Build sophisticated AI systems that involve multiple agents working together to achieve a common goal.
• Use Knowledge and Memory Tools: Connect LLMs with knowledge and memory tools.

Conclusion

The MySQL MCP Server in the UBOS Asset Marketplace is the key to unlocking the full potential of LLMs with your MySQL databases. By providing seamless integration, powerful query capabilities, and flexible configuration options, this tool empowers you to build more intelligent, data-driven AI applications. Integrate the MySQL MCP Server with the UBOS platform to build enterprise grade AI Agents.