StackQL MCP Server

official

Exposes cloud provider control and data planes to agents as self-describing, queryable and mutable data sources using SQL, minimising tool surface and token usage.

View on stackql.io

What can you do with Stack QL MCP?

  • Discover available cloud providers and services — ask the assistant to list installed providers with list_providers or browse services and resources under a provider using list_services and list_resources.
  • Explore resource schemas and methods — use describe_resource to see a resource's fields, or describe_method to inspect the full input/output contract of an access method before querying.
  • Validate and run SQL queries against cloud APIs — have the assistant check a SELECT statement with validate_select_query, then execute it safely via run_select_query.
  • Manage provider registries — list available provider versions with list_registry and install new ones into the local cache using pull_provider.
  • Execute mutations and lifecycle operations — run INSERT, UPDATE, or DELETE statements through run_mutation_query, or trigger lifecycle operations with run_lifecycle_operation when the server mode permits.

Documentation

Ask AI about this page

These are the tools exposed by the StackQL MCP server. Availability of mutation and lifecycle tools depends on the server mode (read_only, safe, delete_safe, full_access).

Server

server_info

Identity and runtime of the connected MCP server

reload_credentials

Re-source credentials from the --env.file dotenv file and report per-provider status

Discovery

list_providers

Providers pulled into the local StackQL cache

list_services

Services available under a provider

list_resources

Resources available under a provider.service

list_methods

Access methods available for a resource

describe_resource

Output fields of a resource

describe_method

Full I/O contract of one access method

Registry

list_registry

Providers and versions available in the registry

pull_provider

Install a provider from the registry into the local cache

Query

validate_select_query

Parse and plan a SELECT without executing it

run_select_query

Execute a SELECT against a provider

Mutation & Lifecycle

run_mutation_query

Run INSERT, UPDATE, REPLACE, or DELETE against a provider

run_lifecycle_operation

Execute a StackQL EXEC lifecycle operation

  • Server
    • server_info
    • reload_credentials
  • Discovery
    • list_providers
    • list_services
    • list_resources
    • list_methods
    • describe_resource
    • describe_method
  • Registry
    • list_registry
    • pull_provider
  • Query
    • validate_select_query
    • run_select_query
  • Mutation & Lifecycle
    • run_mutation_query
    • run_lifecycle_operation