MySQL
Summary
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.
Available Actions(4)
mysql_query
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.
mysql_execute
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_tables
List all tables in current database. No inputs required.
describe_table
Show table structure. Inputs: table (string): Table name to describe.
Community Reviews
No reviews yet. Be the first to review!
Sign in to join the conversation
