Skysql MCP Integration

🚀 SkySQL MCP Integration

This project offers a REST API for managing SkySQL databases and integrates the functionalities of GitHub and Smithery.ai.

🚀 Quick Start

This project provides a REST API interface for managing SkySQL databases and integrates the features of GitHub and Smithery.ai.

✨ Features

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

📦 Installation

Prerequisites

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

Setup Steps

1. Clone the repository:

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

2. Install dependencies:

npm install

3. Create a .env file and add 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

💻 Usage Examples

API Endpoints

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

🚀 Deployment

This project is configured to be deployed on Smithery.ai. Follow these steps:

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

📄 License

MIT