About
This tool acts as a Model Context Protocol (MCP) server, facilitating interaction with a MySQL database. It enables agents to execute a variety of SQL queries, including reading data (SELECT), creating tables (CREATE TABLE), inserting data (INSERT), updating data (UPDATE), and deleting data (DELETE). Query results are returned in JSON format, and database connection settings are configurable. All transactions are logged with unique IDs for auditing.
Key Features
- 1 GitHub stars
- Returns query results in JSON format
- Transaction logging with unique IDs
- Execute SQL queries against a MySQL database
- Supports SELECT, CREATE TABLE, INSERT, UPDATE, and DELETE statements
- Configurable database connection settings
Use Cases
- Retrieving data from a MySQL database based on user prompts
- Creating new tables in a MySQL database
- Modifying data within a MySQL database
