SkySQL MCP Integration

SkySQL MCP Integration

anishksk

Cloud Platforms
Visit Server

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

Recommended Servers

contentful-mcp

contentful-mcp

Update, create, delete content, content-models and assets in your Contentful Space

Featured
TypeScript
Supabase MCP Server

Supabase MCP Server

A Model Context Protocol (MCP) server that provides programmatic access to the Supabase Management API. This server allows AI models and other clients to manage Supabase projects and organizations through a standardized interface.

Featured
JavaScript
Azure MCP Server

Azure MCP Server

Enables natural language interaction with Azure services through Claude Desktop, supporting resource management, subscription handling, and tenant selection with secure authentication.

Official
Local
TypeScript
SettleMint

SettleMint

Leverage SettleMint's Model Context Protocol server to seamlessly interact with enterprise blockchain infrastructure. Build, deploy, and manage smart contracts through AI-powered assistants, streamlining your blockchain development workflow for maximum efficiency.

Official
Local
TypeScript
Brev

Brev

Run, build, train, and deploy ML models on the cloud.

Official
Local
Python
Story SDK MCP Server

Story SDK MCP Server

This server provides MCP (Model Context Protocol) tools for interacting with Story's Python SDK. Features Get license terms Mint and register IP Asset with PIL Terms Mint license tokens Send $IP to a wallet Upload image to ipfs via Pinata [External] Upload ip and nft metadata via Pinata [External]

Official
Python
Tembo MCP Server

Tembo MCP Server

An MCP server that enables Claude to interact with Tembo Cloud platform API, allowing users to manage Tembo Cloud resources through natural language.

Official
TypeScript
Workers MCP

Workers MCP

A package that connects Claude Desktop and other MCP clients to Cloudflare Workers, enabling custom functionality to be accessed via natural language through the Model Context Protocol.

Official
TypeScript
Appwrite MCP Server

Appwrite MCP Server

A Model Context Protocol server that allows AI assistants to interact with Appwrite's API, providing tools to manage databases, users, functions, teams, and other resources within Appwrite projects.

Official
Python
MCP2Lambda

MCP2Lambda

Enables AI models to interact with AWS Lambda functions via the MCP protocol, allowing access to private resources, real-time data, and custom computation in a secure environment.

Official
Python