designcomputer/mysql_mcp_server ? reverse-engineered prompt

Reverse engineered prompt

Build me a Python MCP server that lets an AI assistant safely work with a MySQL database.

I want it to connect through environment variables, support local use with stdio and remote use over HTTP or SSE, and load settings from a .env file when possible. It should be able to list databases and tables, read table contents, inspect schema details, and run SQL queries with good error handling. Please include support for single statement queries only, and make destructive actions like insert, update, or delete feel clearly marked. If no single database is set, it should work in a multi database mode and let me use fully qualified table names.

It would also be nice if it supports SSH tunneling, basic logging, and a couple of helpful MCP prompts for exploring a database and analyzing a table. Set it up so it’s easy to run locally, package cleanly, and use from Claude or other MCP clients. If you need to, look up the current MCP docs online first.

Are you gonna build this?

make sure you review the code using coderabbit

Try freeSponsored — opens CodeRabbit in a new tab