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.
Execute read-only SELECT queries. Inputs: sql (string): SQL SELECT query to execute. Limits: Maximum query length: 4096 characters, Maximum result rows: 1000, Query timeout: 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, Returns last insert ID, Automatic transaction handling.
List all tables in current database. No inputs required.
Show table structure. Inputs: table (string): Table name to describe.
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIOur bundler currently only supports TypeScript-based servers. Check back soon!