MySQL Query MCP Server

by devakone
MIT License
40
1

query

Execute read-only SQL queries (SELECT and SHOW) against MySQL databases in specified environments, with customizable timeout settings, using the MCP server for AI-assisted data exploration.

Instructions

Execute read-only SQL queries against MySQL databases

Input Schema

NameRequiredDescriptionDefault
environmentYesTarget environment to run the query against
sqlYesSQL query to execute (SELECT and SHOW only)
timeoutNoQuery timeout in milliseconds (default: 30000)

Input Schema (JSON Schema)

{ "properties": { "environment": { "description": "Target environment to run the query against", "enum": [ "local", "development", "staging", "production" ], "type": "string" }, "sql": { "description": "SQL query to execute (SELECT and SHOW only)", "type": "string" }, "timeout": { "description": "Query timeout in milliseconds (default: 30000)", "type": "number" } }, "required": [ "sql", "environment" ], "type": "object" }

You must be authenticated.

Other Tools from MySQL Query MCP Server

Related Tools

ID: 4kr6r7qj4s