Mysql MCP Server Pji

🚀 MySQL MCP Server

This is a MySQL-based implementation of the Model Context Protocol (MCP) server. The server enables AI models to interact with MySQL databases through a standardized interface.

🚀 Quick Start

This MySQL MCP Server allows AI models to interact with MySQL databases via a standardized interface.

✨ Features

• List available database tables.
• Retrieve table schemas.
• Execute read-only SQL queries.
• Handle secure transactions with automatic rollback.

📦 Installation

npm install
npm run build

💻 Usage Examples

Claude Desktop Application

Edit the configuration file at the following path:

code ~/Library/Application\ Support/Claude/claude_desktop_config.json

Then add the following content to the JSON file:

{
  "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 according to your MySQL configuration!

📄 License

MIT