koh-yoshimoto/mysql-mcp-server

3.3

If you are the rightful owner of mysql-mcp-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 Model Context Protocol (MCP) server that provides MySQL database access through standardized tools.

Tools

Functions exposed to the LLM to take actions

query

Execute SELECT queries to retrieve data from MySQL database.

execute

Execute INSERT, UPDATE, DELETE queries with safety checks.

schema

Get the schema of a MySQL table.

tables

List all tables in the database.

explain

Analyze the execution plan of a MySQL query to understand performance.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

koh-yoshimoto

Claim Ownership

Verify you have write access to the repository

Version

v0.1.3

Repository

https://github.com/koh-yoshimoto/mysql-mcp-server

GitHub Stars

License

MIT License

Last publish date

2025-06-20

Last update date

2025-09-21

Server configs

in claude desktop

{
  "mcpServers": {
    "mysql": {
      "command": "mysql-mcp-server",
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

in vscode

{
  "mcp.servers": {
    "mysql": {
      "command": "/path/to/mysql-mcp-server",
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "mydb"
      }
    }
  }
}

in cursor

{
  "mysql": {
    "command": "/path/to/mysql-mcp-server",
    "env": {
      "MYSQL_HOST": "localhost",
      "MYSQL_USER": "root",
      "MYSQL_PASSWORD": "password",
      "MYSQL_DATABASE": "mydb"
    }
  }
}