MySQL

About

A Model Context Protocol (MCP) server designed to bridge large language models with MySQL databases. It empowers LLMs to perform a wide range of database operations, including creating, altering, and dropping databases and tables, executing SELECT, INSERT, UPDATE, and DELETE queries, and managing indexes. The server also offers robust permission controls to govern write access, ensuring secure and controlled data manipulation through LLM interactions.

Key Features

• Data querying with SELECT statements and result retrieval
• Data modification capabilities (INSERT, UPDATE, DELETE statements)
• Comprehensive database management (create, drop, list, switch databases)
• 0 GitHub stars
• Index creation and deletion for performance optimization
• Full table operation support (create, alter, drop, describe, list tables)

Use Cases

• Interacting with MySQL databases using natural language queries via an LLM.
• Programmatically managing MySQL database schemas through LLM commands.
• Automating data manipulation (insert, update, delete) in MySQL databases driven by LLM agents.