MCP MySQL Server

by TristanLib

Data/Databases MySQL API REST SSE Cursor Local Database

MCP MySQL Server is a lightweight service for connecting to and operating a local MySQL database. It provides a RESTful API and SSE support, and can be integrated as a Cursor MCP service.

View on GitHub

Last updated: N/A

What is MCP MySQL Server?

This is a lightweight service program for connecting to and operating a local MySQL database. It provides a RESTful API to enable database operations and can be used as a Cursor MCP service.

How to use MCP MySQL Server?

Clone the repository. 2. Install dependencies using npm install. 3. Configure the .env file with your MySQL and API credentials. 4. Run the server using npm start or npm run dev for development mode. Use the provided API endpoints to interact with the database.

Key features of MCP MySQL Server

Connects to local MySQL databases
Provides RESTful API for database operations
Supports parameterized queries to prevent SQL injection
Supports SSE (Server-Sent Events) push capability
Supports integration as a Cursor MCP service

Use cases of MCP MySQL Server

Connecting Cursor to a local MySQL database
Performing database queries through an API
Receiving real-time updates from the database via SSE
Developing applications that require local MySQL database access
Testing database queries locally

FAQ from MCP MySQL Server

Is this service safe to expose to the public internet?

No, this service is designed for local use only and should not be exposed to the public internet due to security concerns.

What type of queries are allowed by default?

By default, only SELECT queries are allowed for security reasons.

How do I protect the API endpoints?

The API endpoints are protected by an API key, which you should configure in the .env file.

What versions of Node.js are supported?

Node.js version 14 or higher is required.

How can I integrate this service with Cursor?

You can integrate this service with Cursor using either SSE or Command mode as described in the README.