blackdesert5410/mysql-mcp-server

3.3

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

A fully functional MySQL Model Context Protocol (MCP) server providing comprehensive database management capabilities.

Tools

Functions exposed to the LLM to take actions

test_connection

Test MySQL connection

list_databases

List all databases

create_database

Create a new database

drop_database

Delete a database

use_database

Select a database to use

list_tables

List all tables in a database

describe_table

Describe table structure

create_table

Create a new table

drop_table

Delete a table

select

Execute SELECT query

insert

Insert data into a table

update

Update data in a table

delete

Delete data from a table

execute_sql

Execute SQL query or command

get_database_schema

Get complete schema information of the database

get_table_schema

Get complete schema information of a specific table

get_foreign_keys

Get foreign key relationships of a table

get_indexes

Get index information of a table

get_table_info

Get statistical information of a table

get_sample_data

Get sample data from a table

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client