SkySQL Integration

Manage your serverless databases effortlessly with a REST API. Create, list, and execute queries on your databases while integrating seamlessly with GitHub and Smithery.ai for enhanced deployment and version control.

Installation

Installing for Claude Desktop

Manual Configuration Required

This MCP server requires manual configuration. Run the command below to open your configuration file:

npx mcpbar@latest edit -c claude

This will open your configuration file where you can add the SkySQL Integration MCP server manually.

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

Share:
Details:
  • Stars


    0
  • Forks


    0
  • Last commit


    3 months ago
  • Repository age


    4 months
View Repository

Auto-fetched from GitHub .

MCP servers similar to SkySQL Integration:

 

 
 
  • Stars


  • Forks


  • Last commit


 

 
 
  • Stars


  • Forks


  • Last commit


 

 
 
  • Stars


  • Forks


  • Last commit