Stackql

What is Stackql?

Stackql is an open-source, SQL-native query and provisioning engine for cloud and SaaS infrastructure. The MCP server exposes StackQL's provider registry and query engine as MCP tools, letting agents discover providers, explore schemas, and run live SQL queries against AWS, Azure, Google, GitHub, Databricks, Okta, and other providers through a single signed binary with no runtime dependencies.

How to use Stackql?

Install via the prebuilt MCP Bundle from the latest release for one-click setup in Claude Desktop, or manually with the stackql binary using the server config and an --approot setting. Provider credentials are passed via StackQL's --auth flag or environment variables.

Key features of Stackql

• Open-source SQL-native query and provisioning engine
• Single signed binary with no runtime dependencies
• Discover and install providers from the StackQL registry
• Explore provider schemas with service and resource tools
• Run live SQL queries against cloud and SaaS APIs
• Provision and lifecycle operations gated by server mode

Use cases of Stackql

• Query cloud and SaaS infrastructure across providers using SQL
• Discover and explore provider schemas and available resources
• Validate and run SQL queries before execution against live APIs
• Perform provisioning and lifecycle operations on cloud resources

FAQ from Stackql

What runtime dependencies does Stackql require?

Stackql is delivered as a single signed binary with no runtime dependencies.

What providers does Stackql support?

Stackql supports AWS, Azure, Google, GitHub, Databricks, Okta, and other providers available through the StackQL provider registry.

How do I install Stackql on Claude Desktop?

Download the prebuilt MCP Bundle (stackql-mcp-<platform>.mcpb) from the latest release, then go to Settings -> Extensions -> Install Extension. No separate StackQL install is needed.

How does authentication work?

Provider credentials are passed via StackQL's standard --auth flag or environment variables. The github provider works without credentials for public data.

What transport does Stackql use?

Stackql uses the stdio transport and works with any stdio-based MCP client. A server config with --approot and audit settings is required for manual installations.