scopweb/mcp-go-mysql
If you are the rightful owner of mcp-go-mysql 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.
Advanced MySQL MCP Server with Intelligent Security is a production-ready server built in Go, offering comprehensive database tools and an intelligent security system to protect against dangerous operations.
Tools
Functions exposed to the LLM to take actions
query
Execute SELECT queries (read-only)
tables
List all tables
describe
Describe table/view structure
list_views
List all views
view_definition
Show complete view definition
create_view
Create new views
drop_view
Delete views
view_dependencies
Analyze view dependencies
explain_query
Analyze query execution plans
analyze_object
Analyze database objects
optimize_tables
Optimize table performance
process_list
Show active MySQL processes
execute_write
INSERT/UPDATE/DELETE with smart protection
execute_ddl
CREATE/DROP/ALTER with mandatory confirmation
show_safety_info
Display security configuration
create_report
Generate custom reports (JSON/CSV/Summary)
view_report
Comprehensive view analysis
database_report
Complete database overview
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client