wuwen1030_mysql_mcp_server
by wuwen1030MySQL Model Context Protocol Server
Overview
The MySQL Model Context Protocol (MCP) Server is a specialized implementation that enables AI models to interact seamlessly with MySQL databases through a standardized interface. This server facilitates secure and efficient database operations, making it an essential tool for developers working with AI and database integration.
Features
- List Available Database Tables: Easily retrieve a list of all tables in the connected MySQL database.
- Get Table Schemas: Access detailed schema information for any table.
- Execute Read-Only SQL Queries: Safely execute SQL queries without modifying the database.
- Safe Transaction Handling: Ensures transactions are handled securely with automatic rollback in case of errors.
Installation
To install the MySQL MCP Server, follow these steps:
npm install
npm run build
Configuration
To configure the server for use with the Claude Desktop App, update the claude_desktop_config.json file as shown below:
{
"mcpServers": {
"mysql": {
"command": "node",
"args": [
"/ABSOLUTE/PATH/TO/PARENT/FOLDER/mysql-mcp-server/dist/index.js",
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASSWORD": "",
"MYSQL_DATABASE": "test"
}
}
}
}
Replace the environment variables with your specific MySQL database credentials.
Usage
The MySQL MCP Server is designed to be integrated with AI models, particularly those using the Claude Desktop App. Once configured, the server allows AI models to interact with MySQL databases securely and efficiently.
License
This project is licensed under the MIT License.
About
The MySQL MCP Server is a powerful tool for developers looking to bridge the gap between AI models and MySQL databases. Its standardized interface and robust features make it an ideal choice for secure and efficient database interactions.
Resources
Stars
Watchers
Forks
Releases
No releases published.
Packages
No packages published.
Languages
- JavaScript 100.0%
Invite Gmail Contacts
