enemyrr_mcp-mysql-server
1
The project is a Model Context Protocol server enabling AI models to interact with MySQL databases. It features secure connection handling, error management, and supports schema tools.
connect_db
Connect to a MySQL database using a URL, workspace path, or direct credentials
query
Execute SELECT query to support preprocessing parameters
execute
Perform INSERT, UPDATE or DELETE queries, supporting preprocessing parameters
list_tables
List all tables in the connection database
describe_table
Get the structure of a specific table
create_table
Create a new table with specified fields and indexes
add_column
Add new columns to existing tables