tansunyj/mysql_mcp_server

3.2

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.

MySQL MCP Server is a service that facilitates secure interaction with MySQL databases using the Model Context Protocol (MCP).

Tools

Functions exposed to the LLM to take actions

query_mysql

Executes SQL queries and returns results

list_databases

Lists all databases on the MySQL server

list_tables

Lists all tables in a specified database

describe_table

Describes the structure of a specified table

search_table

Searches for data containing a keyword in a specified table and column

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

tansunyj

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/tansunyj/mysql_mcp_server

License

MIT License

Last publish date

2025-06-15

Last update date

2025-06-16

Server configs

in claude desktop

{
  "mcpServers": {
    "mysql": {
      "command": "python",
      "args": ["path/to/mcp_mysql.py"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

in vs code

{
  "servers": {
    "mysql": {
      "type": "stdio",
      "command": "python",
      "args": ["path/to/mcp_mysql.py"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}