mcpField
S
SkySQL MCP Integration

SkySQL MCP Integration

Local
github.com/anishkskDatabases0Updated 83w ago
Repository

About SkySQL MCP Integration

SkySQL MCP Integration is a REST API service for creating and managing SkySQL serverless databases. It also supports GitHub version control and deployment through Smithery.ai.

Key features

  1. 01Create and manage serverless databases
  2. 02REST endpoints for database operations
  3. 03GitHub version-control integration
  4. 04Smithery.ai deployment support

Use cases

  1. 01Create a SkySQL database through an API
  2. 02List, inspect, or delete databases
  3. 03Run SQL queries through the REST API
  4. 04Deploy the service via Smithery.ai

MCP support

The project describes a REST API for managing SkySQL databases but does not specify MCP tools, resources, or protocol behavior.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

SkySQL MCP Integration

smithery badge

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

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.