SkySQL MCP Integration

What is SkySQL MCP Integration?

SkySQL MCP Integration provides a REST API for managing serverless databases in SkySQL. It includes integration capabilities for GitHub version control and Smithery.ai deployment, targeting developers who need programmatic database lifecycle management.

How to use SkySQL MCP Integration?

Clone the repository, install dependencies with npm install, configure a .env file with your SkySQL API key and database credentials, then start the development server with npm run dev. Use the REST API endpoints to create, list, get status, delete databases, or execute SQL queries.

Key features of SkySQL MCP Integration

• Create and manage serverless SkySQL databases
• RESTful API endpoints for database operations
• GitHub integration for version control
• Smithery.ai deployment support
• Execute SQL queries via API
• Health check endpoint

Use cases of SkySQL MCP Integration

• Automate database provisioning in development workflows
• Integrate database management with CI/CD pipelines via GitHub
• Deploy and manage serverless databases through Smithery.ai
• Execute ad‑hoc SQL queries programmatically from applications

FAQ from SkySQL MCP Integration

What are the prerequisites to use SkySQL MCP Integration?

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 start the development server?

After installing dependencies and configuring the .env file, run npm run dev from the project directory.

What API endpoints are available?

The server exposes POST /api/databases, GET /api/databases, GET /api/databases/:id, DELETE /api/databases/:id, POST /api/query, and GET /health.

How do I deploy the integration on Smithery.ai?

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

Where are API credentials stored?

Credentials are stored in a .env file containing SKYSQL_API_KEY, SKYSQL_HOST, SKYSQL_USER, SKYSQL_PASSWORD, and SKYSQL_DATABASE.