mcp-mysql-server
If you are the rightful owner of mcp-mysql-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A MySQL connector for Smithery that allows you to connect to your MySQL database directly from Smithery, built with Python.
The MySQL MCP Server for Smithery is a Python-based connector that facilitates seamless integration between Smithery and MySQL databases. It allows users to configure and connect to MySQL databases, view accessible databases and tables, describe table schemas, and execute read-only SQL queries. The server is designed with security in mind, ensuring that only read-only operations are permitted, thus preventing any modifications to the database. The installation process is straightforward, requiring cloning the repository, installing dependencies, and running the server. The server supports both Node.js and Python execution, providing flexibility in usage. Additionally, it includes troubleshooting tips to address common issues such as connection problems and missing modules.
Features
- Connect to MySQL Databases: Configure and connect to MySQL databases
- List Databases: View all accessible databases
- List Tables: View all tables in a specified database
- Describe Tables: Get detailed schema information for tables
- Execute Queries: Run read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
Tools
connect_db
Establishes a connection to a MySQL database.
list_databases
Lists all accessible databases.
list_tables
Lists all tables in a database.
describe_table
Shows the schema for a table.
execute_query
Executes a read-only SQL query.
