SkySQL MCP Integration

SkySQL MCP Integration

By anishksk GitHub

-

Overview

what is MCP-Server?

MCP-Server is a project that provides a REST API interface for managing SkySQL databases, enabling seamless integration with GitHub and Smithery.ai.

how to use MCP-Server?

To use MCP-Server, clone the repository, install the dependencies, set up your environment variables, and start the development server. You can then interact with the API endpoints to manage your databases.

key features of MCP-Server?

  • Create and manage serverless databases in SkySQL
  • RESTful API endpoints for various database operations
  • Integration with GitHub for version control
  • Deployment support on Smithery.ai

use cases of MCP-Server?

  1. Managing serverless databases for applications
  2. Automating database operations through API calls
  3. Integrating database management with version control systems like GitHub

FAQ from MCP-Server?

  • What are the prerequisites for using MCP-Server?

You need Node.js (v14 or higher), npm or yarn, a SkySQL API key, a GitHub account, and a Smithery.ai account.

  • How do I deploy my application?

Push your code to GitHub, connect your repository to Smithery.ai, configure your environment variables, and deploy.

  • What API endpoints are available?

The available endpoints include creating, listing, getting status, and deleting databases, as well as executing SQL queries.

Content

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
  1. Install dependencies:
npm install
  1. 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
  1. 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

No tools information available.
No content found.