mysql-mcp-server

bhaveshrmahajan/mysql-mcp-server

3.2

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 Model Context Protocol (MCP) server that connects AI assistants to MySQL databases for safe and controlled access.

Tools

Functions exposed to the LLM to take actions

list-tables

List all tables in the database.

describe-table

Get the schema of a specific table.

create-table

Create a new table using a SQL query.

insert-row

Insert a new row into a table using JSON data.

execute-query

Execute read-only SQL queries safely.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources