Frequently Asked Questions about the MySQL MCP Server

Q: What is the MySQL MCP Server? A: The MySQL MCP Server is a connector that allows Smithery (Python) to connect to MySQL databases. It acts as a bridge between AI models and your data, enabling read-only data access.

Q: What are the main features of the MySQL MCP Server? A: Key features include connecting to MySQL databases, listing databases and tables, describing table schemas, executing read-only SQL queries, and built-in security validation.

Q: How does the MySQL MCP Server enhance security? A: The server validates queries to allow only SELECT, SHOW, DESCRIBE, and EXPLAIN commands. INSERT, UPDATE, DELETE, and DROP commands are automatically rejected, preventing data modification.

Q: How do I install the MySQL MCP Server manually? A: Clone the repository, install dependencies using npm install and pip install -r requirements.txt, and make the scripts executable using chmod +x mcp_server.py run.js.

Q: What parameters are required for the connect_db tool? A: The connect_db tool requires the database server hostname, port, username, password, and optionally the database name.

Q: Which SQL commands are permitted by the execute_query tool? A: The execute_query tool only allows SELECT, SHOW, DESCRIBE, and EXPLAIN SQL commands. Other commands are rejected for security reasons.

Q: What should I do if I encounter a ‘Python Not Found’ error? A: Ensure Python is installed and in your PATH. The server will detect python3 or python automatically. If neither works, you need to install Python and configure your PATH.

Q: What should I do if I encounter ‘Missing Modules’ error? A: Manually run pip install mysql-connector-python>=8.0.0 to install required packages.

Q: What if I have connection issues? A: Verify your database credentials and ensure the MySQL server is running and accessible from where the MCP server is running.

Q: How does the MySQL MCP Server integrate with UBOS? A: The MySQL MCP Server seamlessly integrates with the UBOS platform, providing a unified environment for building, deploying, and managing your AI agents and connecting them to MySQL databases.