MySQL MCP Server for Smithery (Python)
@aqaranewbiz
About MySQL MCP Server for Smithery (Python)
No overview available yet
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcp-mysql-server-aqaranewbiz": {
"command": "node",
"args": [
"run.js"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is MySQL MCP Server for Smithery (Python)?
MySQL MCP Server for Smithery (Python) is a connector that lets you connect to a MySQL database directly from Smithery. It is built with Python and provides tools for listing databases, tables, describing schemas, and executing read-only SQL queries.
How to use MySQL MCP Server for Smithery (Python)?
Add the server in Smithery, then enter your MySQL credentials (host, port, user, password, optional database). Alternatively, clone the repository, install dependencies (npm install, pip install -r requirements.txt), and start with node run.js or python mcp_server.py.
Key features of MySQL MCP Server for Smithery (Python)
- Connect to MySQL databases with configurable credentials
- List all accessible databases
- View all tables in a database
- Get detailed schema information for tables
- Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
- Built‑in query validation blocks write operations
Use cases of MySQL MCP Server for Smithery (Python)
- Explore the structure of a MySQL database from Smithery
- Run read-only queries to retrieve data without risk of modification
- Audit database schemas across multiple databases
- Integrate database inspection into Smithery workflows
FAQ from MySQL MCP Server for Smithery (Python)
What SQL statements are allowed?
Only SELECT, SHOW, DESCRIBE, and EXPLAIN queries are permitted. INSERT, UPDATE, DELETE, DROP, and other write commands are rejected.
What are the runtime dependencies?
Python 3 with mysql-connector-python>=8.0.0 and Node.js (for the launcher script). Missing modules are auto‑installed if possible.
How do I troubleshoot connection issues?
Verify your database credentials, ensure the MySQL server is running and accessible, and check Smithery’s console log for errors.
Can I run multiple SQL statements in one query?
No. Multiple statements separated by semicolons are not allowed for security reasons.
Does the server require authentication?
Yes, you must provide a valid MySQL username and password. The server does not implement additional authentication layers.
Frequently asked questions
What SQL statements are allowed?
Only SELECT, SHOW, DESCRIBE, and EXPLAIN queries are permitted. INSERT, UPDATE, DELETE, DROP, and other write commands are rejected.
What are the runtime dependencies?
Python 3 with `mysql-connector-python>=8.0.0` and Node.js (for the launcher script). Missing modules are auto‑installed if possible.
How do I troubleshoot connection issues?
Verify your database credentials, ensure the MySQL server is running and accessible, and check Smithery’s console log for errors.
Can I run multiple SQL statements in one query?
No. Multiple statements separated by semicolons are not allowed for security reasons.
Does the server require authentication?
Yes, you must provide a valid MySQL username and password. The server does not implement additional authentication layers.
Basic information
More Databases MCP servers
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
Local YDB MCP
astandrikSafety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
Comments