Which integrations are available for this server?

Provides read-only access to MySQL databases with schema inspection capabilities, allowing listing of tables, describing table structures, and executing SELECT queries.

How do I use MCP MySQL Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MCP MySQL Server describe_table users" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

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.