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

1. Create a folder: Create a new directory for your server, for example, my-mcp-server.

   mkdir my-mcp-server cd my-mcp-server

2. Save the files: Place package.json, tsconfig.json, index1.ts, and README.md into this new directory.

3. Install dependencies: Open your terminal in the my-mcp-server directory and run:

   npm install

4. 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