This MCP server implementation provides secure MySQL database access for LLMs. Developed by Dewei Yen, it offers both read and write operations, including SELECT queries, table listings, and INSERT/UPDATE/DELETE statements with transaction support. The server emphasizes security through read-only transaction modes, query limits, and performance monitoring. It's designed for integration with tools like Dive Desktop, making it suitable for AI-assisted database interactions, data analysis, and automated data management tasks.
No reviews yet. Be the first to review!
Sign in to join the conversation
Execute read-only SELECT queries. Inputs: sql (string): SQL SELECT query to execute. Limits: Maximum query length of 4096 characters, maximum result rows of 1000, query timeout of 30 seconds.
Execute data modification operations. Inputs: sql (string): SQL statement (INSERT/UPDATE/DELETE), params (array, optional): Parameters for the SQL statement. Features: Returns affected rows count, last insert ID, and automatic transaction handling.
List all tables in the current database. No inputs required.
Show table structure. Inputs: table (string): Table name to describe.