stackql
by stackql·★ 841·Score 52
StackQL is a Go-based SQL framework for querying and managing cloud resources and APIs via MCP protocol.
Overview
StackQL enables users to query, provision, and operate cloud and SaaS resources using SQL semantics. It acts as a middleware that translates SQL queries into API calls to various cloud providers. The system includes a provider registry where API definitions are stored, allowing for extensibility across different services. StackQL can be run in client mode (exec or shell) or server mode using the Postgres wire protocol.
Try asking AI
After installing, here are 5 things you can ask your AI assistant:
When to choose this
Choose StackQL when you need to query and manage multiple cloud resources using SQL syntax and want a consistent interface across different providers.
When NOT to choose this
Don't choose StackQL if you need real-time operational capabilities or complex transactional support, as it focuses on read-heavy querying and provisioning tasks.
Comparable tools
Installation
Installation
StackQL can be installed on multiple platforms:
**macOS:**
brew install stackql**Windows:**
choco install stackql**Linux:**
curl -L https://bit.ly/stackql-zip -O && unzip stackql-zip**Docker:**
docker pull stackql/stackql**Claude Desktop Integration:** In Claude Desktop's config.json:
{
"mcpServers": {
"stackql": {
"command": "stackql",
"args": ["srv"]
}
}
}FAQ
- What cloud providers does StackQL support?
- StackQL supports major cloud providers including Google Cloud, AWS, Azure, as well as SaaS providers like Okta and GitHub. The provider registry is extensible, allowing custom providers to be added.
- How does StackQL differ from traditional SQL databases?
- StackQL is not a traditional database - it's a query translation framework that converts SQL into API calls. It doesn't store data but queries external services through their APIs.
On Hacker News
Recent discussion from the developer community.
- Story by jeffreyaven · 2023-10-07
- Story by jeffreyaven · 2023-01-03
Compare stackql with
Last updated · Auto-generated from public README + GitHub signals.