MCP MySQL Local Database Service

The MCP MySQL Service is a lightweight, personal-use server program designed to connect and operate local MySQL databases. This service can be utilized as a part of the Cursor MCP service, enabling seamless execution of various database operations through API interfaces.

Key Features

• Local MySQL Database Connection: Effortlessly connect to and manage your MySQL databases locally.
• RESTful API for Database Operations: Perform database operations through a robust RESTful API.
• Parameterized Queries: Safeguard against SQL injection with support for parameterized queries.
• SSE (Server-Sent Events) Capability: Stream data efficiently with SSE push capabilities.
• Integration with Cursor MCP Service: Enhance your Cursor MCP service with seamless integration.

Use Cases

1. Data Management: Ideal for developers and businesses looking to manage their local MySQL databases efficiently through a user-friendly API.
2. AI Model Integration: Facilitates AI models in accessing and interacting with external data sources, enhancing AI-driven applications.
3. Secure Database Operations: With built-in security features like API key protection and parameterized queries, it ensures secure interactions with databases.

Getting Started

Prerequisites

• Node.js (v14+)
• MySQL Server

Installation

1. Clone the repository.
2. Install dependencies using npm install.
3. Configure the .env file with your server and database settings.

Running the Service

Execute npm start to run the service or npm run dev for development mode with auto-restart.

API Interface

• Get All Databases: GET /api/databases
• Get All Tables in a Database: GET /api/databases/:database/tables
• Get Table Structure: GET /api/databases/:database/tables/:table/structure
• Execute Query: POST /api/query with JSON payload.
• SSE Connection: GET /api/sse?apiKey=your-api-key

Security Considerations

• Designed for local use only, not recommended for public exposure.
• API key protection for secure interface access.
• Default to executing only SELECT queries for added security.

UBOS Platform

UBOS is a full-stack AI Agent Development Platform focused on integrating AI Agents into every business department. It orchestrates AI Agents and connects them with enterprise data, allowing for the creation of custom AI Agents using LLM models and Multi-Agent Systems. The MCP MySQL Server complements UBOS by providing a reliable backend for data operations, crucial for AI-driven solutions.

Licensing

This service is licensed under the MIT License, allowing for flexible use and modification.