MySQL enables Large Language Models (LLMs) to securely interact with MySQL databases. It offers functionalities for executing read-only SELECT queries, listing database tables, showing table structures, and viewing schema information. Furthermore, it supports write operations such as INSERT, UPDATE, and DELETE with transaction support, parameterized queries for data safety, and returns affected rows and insert IDs. Security features include read-only transaction mode for SELECT queries, query length and result size limits, performance monitoring and logging, and automatic transaction handling.
Key Features
01Implements parameterized queries for data safety
023 GitHub stars
03Supports INSERT/UPDATE/DELETE with transaction support
04Provides performance monitoring and logging
05Executes read-only SELECT queries
06Offers query length and result size limits
