What is Skysql Mcp

SkySQL MCP is a server and client repository designed to facilitate the management of SkySQL database instances and interaction with SkyAI Agents through the Machine Control Protocol.

Use cases

Use cases include automating database management tasks, integrating AI agents for data processing, executing complex SQL queries, and managing database security through credential and IP allowlist management.

How to use

To use SkySQL MCP, clone the repository, set up a virtual environment, install the necessary dependencies, and configure your SkySQL API key in a .env file. You can then run the server and interact with it using the MCP CLI tool.

Key features

Key features include launching and managing serverless database instances, interacting with AI-powered database agents, executing SQL queries directly, managing database credentials and IP allowlists, and monitoring database services.

Where to use

SkySQL MCP can be used in various fields such as cloud computing, database management, artificial intelligence, and any application requiring efficient database interactions.

SkySQL MCP Server

This package contains everything needed to set up the SkySQL MCP (Model Context Protocol) server, which provides a powerful interface for managing SkySQL (MySQL/MariaDB) database instances and interacting with SkyAI Agents.

Features

• Launch and manage serverless MariaDB database instances
• Interact with AI-powered database agents
• Execute SQL queries directly on SkySQL (MySQL/MariaDB) instances
• Manage database credentials and IP allowlists
• List and monitor database services

Installation

Prerequisites

• Python 3.10 or higher
• A SkySQL API key

Option 1: Run locally

Installation steps

1. Clone the repository:

   git clone [email protected]:skysqlinc/skysql-mcp.git
   cd skysql-mcp
   

2. Run the installation script:

   chmod +x install.sh
   ./install.sh
   

3. Create a .env file in the root directory of the cloned git repository with your SkySQL API key. Obtain API key by signing up for free on SkySQL.

   SKYSQL_API_KEY=<your_skysql_api_key_here>
   

4. Use MCP CLI tool to test the server interactively.

   npx @wong2/mcp-cli uv run python src/mcp-server/server.py
   

5. Configure in Cursor.sh manually

   For Mac/Linux:

   chmod +x launch.sh
   

Update mcp.json:

• command "<full-path-to>/skysql-mcp/launch.sh" for Mac/Linux and "<full-path-to>\\skysql-mcp\\launch.bat" for Windows.
• SKYSQL_API_KEY with your SkySQL API key

Copy the mcp.json included in the repo to Cursor MCP Settings

Option 2: Installing via Smithery.ai

You can use Smithery.ai to test the MCP server via their UI. Follow the installation instructions from smithery.ai

For example, use the following command to install it in Cursor.sh IDE:

npx -y @smithery/cli@latest install @skysqlinc/skysql-mcp --client cursor --profile <your-smithery-profile> --key <your-smithery-kay>

For Windsurf:

npx -y @smithery/cli@latest install @skysqlinc/skysql-mcp --client windsurf --profile <your-smithery-profile> --key <your-smithery-key>