mcp-server-mysql

dlbiaan/mcp-server-mysql

3.1

If you are the rightful owner of mcp-server-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.

Tools

Functions exposed to the LLM to take actions

connect_db

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

query

Execute SELECT query (support parameter binding)

execute

Perform INSERT/UPDATE/DELETE operation

list_tables

List all tables in the database

describe_table

Get table structure information

create_table

Create a new table (supports field and index definitions)

add_column

Add new columns to existing tables

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources