Frequently Asked Questions (FAQ)

Q: What is MCP? A: MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to LLMs. It acts as a bridge between AI models and external data sources.

Q: What is the purpose of the Dockerized MCP MySQL Server? A: It provides a containerized MCP server that allows AI models to access and interact with MySQL databases.

Q: What are the key features of this asset? A: The key features include running SQL queries via MCP tools, retrieving table schemas, listing all tables in a connected MySQL database, and Dockerized deployment.

Q: What are the requirements for using this asset? A: The requirements include Python 3.10+, Docker, MySQL server or container, and the fastmcp library.

Q: How do I configure the MySQL credentials? A: You need to copy .env.example to .env and fill in your MySQL credentials in the .env file.

Q: Can I use Docker Compose with this asset? A: Yes, you can use Docker Compose to start both MySQL and the MCP server with one command. Make sure to set DB_HOST=db in your .env file when using Docker Compose.

Q: What tools are exposed by the server? A: The server exposes run_sql_query(query: str) -> list, get_table_schema(table_name: str) -> list, and list_tables() -> list.

Q: How does this integrate with the UBOS platform? A: The Dockerized MCP MySQL Server seamlessly integrates with the UBOS platform, allowing you to connect your AI agents to your MySQL databases within the UBOS ecosystem.

Q: Where can I find more information about the UBOS platform? A: Visit the UBOS website at https://ubos.tech for more information.