vissong/gen-http-mysql-mcp
3.1
If you are the rightful owner of gen-http-mysql-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
A Model Context Protocol (MCP) server providing secure, read-only access to MySQL databases.
Tools
Functions exposed to the LLM to take actions
get_database_schema
Retrieves comprehensive information about all tables in the database.
execute_sql_query
Executes SQL SELECT queries safely with restrictions.
execute_write_operation
Executes SQL write operations (INSERT and UPDATE) safely with restrictions.
test_database_connection
Tests the database connection to ensure proper configuration and connectivity.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client