mcp-mysql-server

mcp-mysql-server

0
databases

The @enemyrr/mcp-mysql-server is a Model Context Protocol server designed to facilitate MySQL database operations for AI models. It supports multiple connection methods, ensures secure and efficient database interactions, and simplifies schema management. It is open to contributions and is released under the MIT license.

connect_db

Connect to a MySQL database using a URL, workspace path, or direct credentials

query

Execute SELECT query, support preprocessing statement parameters

execute

Execute INSERT, UPDATE or DELETE queries, supporting preprocessing statement 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