概要
What is Jewei Mysql Mcp Server?
Jewei Mysql Mcp Server is a MySQL database query server that executes SQL queries (only SELECT statements), retrieves table structure information (columns, primary keys, foreign keys, indexes), and lists all tables in a database. It is designed for developers who need to interact with MySQL databases through MCP-compatible tools like Windsurf, Cursor, Claude, or Cline.
How to use Jewei Mysql Mcp Server?
Install dependencies with pip install -r requirements.txt, create a .env file with the environment variables DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, and DB_NAME, then run using uvx --from jewei-mysql-mcp-server jewei-mysql-mcp-server (recommended) or from source with python -m jewei_mysql_mcp_server.server. Configure the server in MCP config files for supported clients, replacing placeholder values with your actual database connection info.
Key features of Jewei Mysql Mcp Server
- Execute SQL queries and return result sets (SELECT only)
- Get detailed table structure including columns, keys, and indexes
- List all tables in the specified database
- Supports MCP integration with Windsurf, Cursor, Claude, and Cline
- Run via uvx for easy installation and execution
Use cases of Jewei Mysql Mcp Server
- Query a MySQL database using SELECT statements through MCP clients
- Explore database schema by listing tables and viewing table structure
- Integrate MySQL database interactions into AI-assisted development workflows
FAQ from Jewei Mysql Mcp Server
What queries does Jewei Mysql Mcp Server support?
Only SELECT statements are supported. INSERT, UPDATE, DELETE, and other SQL commands are not allowed.
How do I configure the database connection for Jewei Mysql Mcp Server?
Set the environment variables DB_HOST, DB_PORT, DB_USER
