gakkiismywife/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.

This is a Model Context Protocol (MCP) server designed for interacting with a MySQL database in a read-only manner, focusing on schema inspection and executing custom queries.

Tools

3

Resources

0

Prompts

0

MCP MySQL Server

This is a generated Model Context Protocol (MCP) server designed to interact with a MySQL database in a read-only fashion, providing schema inspection and custom query capabilities.

Setup Instructions

Create a folder: Create a new directory for your server, for example, my-mcp-server.
```
mkdir my-mcp-server
cd my-mcp-server
```
Save the files: Place package.json, tsconfig.json, index1.ts, and README.md into this new directory.
Install dependencies: Open your terminal in the my-mcp-server directory and run:
```
npm install
```
Build the project: Compile the TypeScript code:
```
npm run build
```

Available Tools

This server exposes the following tools:

list_tables(): Lists all tables in the connected MySQL database.
describe_table(tableName: string): Describes the columns of a specified table.
execute_read_query(query: string, params?: any[]): Executes a read-only SQL query (SELECT, SHOW, DESCRIBE) against the database.

With Cursor