SkySQL MCP Integration

SkySQL MCP Integration

This project provides a REST API interface for managing SkySQL databases, with integration capabilities for GitHub and Smithery.ai.

Features

• Create and manage serverless databases in SkySQL
• RESTful API endpoints for database operations
• GitHub integration for version control
• Smithery.ai deployment support

Prerequisites

• Node.js (v14 or higher)
• npm or yarn
• SkySQL API key
• GitHub account
• Smithery.ai account

Setup

1. Clone the repository:

git clone <your-repo-url>
cd skysql-mcp

2. Install dependencies:

npm install

3. Create a .env file with your credentials:

SKYSQL_API_KEY=your_api_key
SKYSQL_HOST=your_host
SKYSQL_USER=your_user
SKYSQL_PASSWORD=your_password
SKYSQL_DATABASE=your_database

4. Start the development server:

npm run dev

API Endpoints

• POST /api/databases - Create a new database
• GET /api/databases - List all databases
• GET /api/databases/:id - Get database status
• DELETE /api/databases/:id - Delete a database
• POST /api/query - Execute SQL queries
• GET /health - Health check endpoint

Deployment

This project is configured for deployment on Smithery.ai. Follow these steps:

1. Push your code to GitHub
2. Connect your GitHub repository to Smithery.ai
3. Configure your environment variables in Smithery.ai
4. Deploy your application

License

MIT