Stackql

@stackql

访问 MCP Server

2 days ago

Open source SQL-native query and provisioning engine for cloud and SaaS infrastructure. Ships as a single signed binary with MCP tools for provider discovery, schema exploration, queries, and lifecycle operations.

概览工具评论

概览

StackQL MCP Server

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 - all through a single signed binary with no runtime dependencies.

Tools

list_providers, pull_provider, list_registry - discover and install providers from the StackQL registry
list_services, list_resources, describe_resource, list_methods, describe_method - explore provider schemas
run_select_query, validate_select_query - live SQL queries against cloud APIs
run_mutation_query, run_lifecycle_operation - provisioning and lifecycle operations (gated by server mode)
server_info - server and registry status

Install (Claude Desktop - one-click)

Download the prebuilt MCP Bundle for your platform from the latest release - stackql-mcp-<platform>.mcpb - then Settings -> Extensions -> Install Extension. No separate StackQL install needed. Each bundle has a .sha256 alongside it.

Install (manual, any stdio MCP client)

With the stackql binary installed, use the server config shown above. Replace /Users/yourname with your home directory. The --approot and audit settings matter: some MCP clients launch servers with an unwritable working directory.

Authentication

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

服务器配置

{
  "mcpServers": {
    "stackql": {
      "command": "stackql",
      "args": [
        "mcp",
        "--mcp.server.type=stdio",
        "--approot",
        "/Users/yourname/.stackql",
        "--mcp.config",
        "{\"server\": {\"audit\": {\"disabled\": true}}}"
      ]
    }
  }
}

Build with ShipAny.