Loading connector details…
MCP MySQL Server
MCPOpen SourceMIT31.4
by mukul975 • Uncategorized
A production-ready MCP server providing secure HTTP endpoints for read-only MySQL database operations and performance monitoring.
Example Use Cases
- 1
Execute secure, read-only SQL queries on MySQL databases.
- 2
Monitor and analyze MySQL server performance and status.
- 3
Audit MySQL security and user privileges.
Description
This MCP server enables agents to execute read-only SQL queries, analyze InnoDB performance, and monitor MySQL server status through secure and authenticated HTTP endpoints. It includes extensive security features such as authentication, rate limiting, and input validation, ensuring safe database interactions. The server supports observability with structured logging, health monitoring, and performance metrics, making it suitable for production environments. It also offers a rich set of diagnostic, operational, and security tools to facilitate comprehensive MySQL database management.
Capabilities(19 total)
Tools (14)
connect_db
Connect to a MySQL database using URL, workspace config, or direct parameters
url:stringworkspace:stringhost:stringport:numberuser:stringpassword:stringdatabase:string
query
Execute a SELECT query and return results
sql:string*params:array
execute
Execute an INSERT, UPDATE, or DELETE query
sql:string*params:array
list_tables
List all tables in the connected database
list_databases
List all accessible databases on the server
Prompts (5)
generate-select
Generate a SELECT query for a table with optional filters
tablecolumnswhereorderBylimit
generate-insert
Generate an INSERT statement template for a table
table
generate-update
Generate an UPDATE statement template for a table
tablewhere
explain-schema
Get a natural language explanation of a table structure
table
suggest-indexes
Analyze a table and suggest potential indexes for optimization
table
Quick Actions
Security
Scanned 1 month(s) agoRisk Level
MODERATE
Can modify files, state, or send data externally
Trust Score
B67/100
11/17 checks passed
Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.
Quick Stats
Service TypeMCP
Pricing ModelFree
Capabilities14 Tools / 5 Prompts / 0 Resources
Ownermukul975
CategoryUncategorized
DependenciesStandalone
Tags
aiai-toolsclaudeclaude-desktopclaude-mcpdatabase-managementdatabase-optimizationdatabase-securitydiagnosticsmcpmcp-servermodel-context-protocolmysqlmysql-diagnosticsopen-sourceperformance-analysispythonsql-queries