mcp-mysql-server
0
The MySQL MCP Server for Smithery is a Python-based connector that enables direct connection to MySQL databases from Smithery. It supports essential database operations like listing databases and tables and executing read-only SQL queries with built-in security validation.
MySQL MCP Server for Smithery (Python)
A MySQL connector for Smithery that allows you to connect to your MySQL database directly from Smithery, built with Python.
Features
- Connect to MySQL Databases
- List Databases
- List Tables
- Describe Tables
- Execute Queries (read-only)
- Security with built-in query validation
Installation in Smithery
Configure the MySQL database credentials directly in Smithery.
Manual Installation
Clone the repository, install dependencies, and make scripts executable.
Manual Usage
Start the server using Node.js or run the Python script directly.
Available Tools
- connect_db: Establish a connection.
- list_databases: Lists all databases.
- list_tables: Lists all tables.
- describe_table: Shows table schema.
- execute_query: Executes read-only queries.
Security
Built-in validation to ensure only read-only operations are permitted.