What is an MCP Server?

An MCP (Model Context Protocol) server acts as a bridge, allowing AI models to access and interact with external data sources and tools. MCP is an open protocol that standardizes how applications provide context to LLMs.

What are the key features of the MySQL MCP Server?

The MySQL MCP Server allows you to connect LLMs to MySQL, execute SQL queries, manage databases, and integrate with the UBOS platform. It supports stdio communication, connection management, and configuration files.

What are the prerequisites for using the MySQL MCP Server?

You need Node.js (20.0.0 or higher) and MySQL (5.7 or higher) or MariaDB server.

How do I install and use the MySQL MCP Server?

You can temporarily run it with NPX or install it and use configuration options to connect to your MySQL database. Refer to the documentation for detailed steps.

What is stdio communication?

stdio communication uses standard input/output streams for communication, eliminating the need for port bindings and simplifying deployment.

How do I save and reuse 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.

Can I use a configuration file?

Yes, you can create a JSON configuration file to manage connection parameters and server settings.

What tools are provided by the MySQL MCP Server?

The server provides tools for database connection management (connect, disconnect, get status) and SQL query operations (execute query, get databases, get tables, describe table).

How can I test the connection management features?

The repository includes a test-connection-management.js script that you can use to test the connection management features.

How does the MySQL MCP Server integrate with UBOS?

The MySQL MCP Server is part of the UBOS Asset Marketplace and integrates seamlessly with the UBOS platform, allowing you to build AI Agents that can access and manipulate MySQL data to perform tasks.