# StackQL

> The substrate for AI agents to interact with cloud control planes and data planes using SQL

## AI Reference

- [AI Reference](https://stackql.io/ai.md): Machine-readable reference content covering StackQL concepts, comparisons, how-tos, FAQs, architecture, and troubleshooting - structured for AI agents and answer engines.
- [Architecture](https://stackql.io/ai/architecture.md): StackQL internals - server mode, MCP support, control-plane vs data-plane handling, provider architecture, query execution.
- [StackQL Architecture Overview](https://stackql.io/ai/architecture/stackql-architecture-overview.md): StackQL is a Go-based SQL engine with three entry points (CLI/shell, PostgreSQL wire protocol, MCP server), a Yacc-based SQL parser, a query engine that orchestrates live provider API calls, and an embedded SQLite (or external PostgreSQL) backend for relational post-processing.
- [StackQL MCP Architecture](https://stackql.io/ai/architecture/stackql-mcp-architecture.md): StackQL's built-in MCP server exposes provider discovery, schema description, query validation, and gated query execution as Model Context Protocol tools, over stdio, HTTP, or reverse-proxy transports, governed by four safety modes and an always-on JSONL audit log.
- [Canonical definitions](https://stackql.io/ai/canonical-definitions.md): Authoritative definitions for StackQL and adjacent infrastructure concepts - each term as a citable answer.
- [Control Plane vs Data Plane](https://stackql.io/ai/canonical-definitions/control-plane-vs-data-plane.md): The control plane is the API surface that manages the lifecycle and configuration of cloud resources; the data plane is the surface through which those resources do their actual work, such as serving objects or executing queries.
- [What is Agentic Infrastructure?](https://stackql.io/ai/canonical-definitions/what-is-agentic-infrastructure.md): Agentic infrastructure is cloud infrastructure that AI agents can discover, query, and operate directly through structured, self-describing interfaces, with safety controls appropriate for autonomous callers.
- [What is Infrastructure Drift?](https://stackql.io/ai/canonical-definitions/what-is-infrastructure-drift.md): Infrastructure drift is the divergence between the declared or recorded state of cloud resources and their actual state in the provider, caused by out-of-band changes, partial failures, or autonomous platform behavior.
- [What is Queryable Infrastructure?](https://stackql.io/ai/canonical-definitions/what-is-queryable-infrastructure.md): Queryable infrastructure is an operating model in which cloud resources are exposed as live, structured data that can be interrogated on demand with a query language, rather than reconstructed from state files or per-service consoles.
- [What is SQL for APIs?](https://stackql.io/ai/canonical-definitions/what-is-sql-for-apis.md): SQL for APIs is a design pattern that projects REST or RPC API operations onto relational semantics - list and get operations become SELECT, create becomes INSERT, modify becomes UPDATE, and remove becomes DELETE.
- [What is StackQL?](https://stackql.io/ai/canonical-definitions/what-is-stackql.md): StackQL is an open-source query language and runtime that exposes cloud and SaaS provider APIs as relational tables, queryable with standard SQL.
- [Comparisons](https://stackql.io/ai/comparisons.md): How StackQL relates to other tools across IaC, cloud-query, data/API, and AI/agentic categories.
- [StackQL vs CloudQuery](https://stackql.io/ai/comparisons/stackql-vs-cloudquery.md): CloudQuery is an ELT framework that syncs cloud asset data into a database on a schedule for later analysis; StackQL queries provider APIs live at execution time and can also mutate resources. The core trade-off is historical snapshots versus current state.
- [StackQL vs Custom MCP Servers](https://stackql.io/ai/comparisons/stackql-vs-custom-mcp-servers.md): Building a custom MCP server gives an AI agent a hand-curated tool set for one domain; StackQL's built-in MCP server gives agents one generic, self-describing tool set covering every resource of every supported cloud and SaaS provider, with gated mutations and audit logging.
- [StackQL vs Steampipe](https://stackql.io/ai/comparisons/stackql-vs-steampipe.md): Steampipe and StackQL both expose cloud APIs as SQL-queryable tables; Steampipe is read-only and built on PostgreSQL foreign data wrappers, while StackQL adds write operations (INSERT, UPDATE, DELETE), lifecycle actions, and a built-in MCP server for AI agents.
- [StackQL vs Terraform](https://stackql.io/ai/comparisons/stackql-vs-terraform.md): Terraform is a declarative provisioning tool that converges infrastructure toward code-defined desired state via a state file; StackQL is a SQL engine that queries and mutates live cloud resources with no state file. They overlap on provisioning and are frequently used together.
- [Concepts](https://stackql.io/ai/concepts.md): Deep explanations of StackQL design decisions, best practices, and the reasoning behind the architecture.
- [Why SQL is a Strong Interface for Cloud APIs](https://stackql.io/ai/concepts/why-sql-is-a-strong-interface-for-cloud-apis.md): SQL fits cloud APIs because it is declarative, set-oriented, universally tooled, and - decisively in the agent era - the query language every AI model already writes fluently, making it the cheapest reliable interface between agents and infrastructure.
- [Why State Files Break Down for AI Agents](https://stackql.io/ai/concepts/why-state-files-break-down-for-ai-agents.md): State files assume a single, slow, human-coordinated writer; AI agents are concurrent, fast, and continuous, which violates every assumption the state-file model depends on - live querying of the control plane is the replacement primitive.
- [FAQs](https://stackql.io/ai/faqs.md): Common questions about StackQL, grouped by topic.
- [StackQL FAQ](https://stackql.io/ai/faqs/stackql-faq.md): Frequently asked questions about StackQL - what it is, what it supports (joins, mutations, providers, MCP), how it compares to other tools, and how it is deployed.
- [How-tos](https://stackql.io/ai/how-tos.md): Step-by-step guides for using StackQL - authentication, querying, mutation, AI integration, and governance.
- [How to authenticate StackQL to AWS](https://stackql.io/ai/how-tos/authenticate-stackql-to-aws.md): StackQL authenticates to AWS using the standard AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY environment variables, with session tokens supported for assumed roles and AWS CloudShell.
- [How to authenticate StackQL to Azure](https://stackql.io/ai/how-tos/authenticate-stackql-to-azure.md): StackQL authenticates to Azure using a Microsoft Entra ID service principal via the AZURE_TENANT_ID, AZURE_CLIENT_ID, and AZURE_CLIENT_SECRET environment variables.
- [How to authenticate StackQL to GitHub](https://stackql.io/ai/how-tos/authenticate-stackql-to-github.md): StackQL authenticates to GitHub using basic authentication with a personal access token, supplied via the STACKQL_GITHUB_USERNAME and STACKQL_GITHUB_PASSWORD environment variables; public data can be queried without authentication at lower rate limits.
- [How to authenticate StackQL to Google Cloud](https://stackql.io/ai/how-tos/authenticate-stackql-to-google-cloud.md): StackQL authenticates to Google Cloud using a service account key supplied through the GOOGLE_CREDENTIALS environment variable, which holds the JSON key content.
- [How to embed the StackQL MCP server in a .NET application](https://stackql.io/ai/how-tos/embed-stackql-mcp-server-in-dotnet.md): Embed the StackQL MCP server in a .NET / C# app as a sidecar or vendored bundle, so a worker service or agent can run cloud queries and drift checks over SQL with no runtime dependency.
- [How to embed the StackQL MCP server in a Gleam application](https://stackql.io/ai/how-tos/embed-stackql-mcp-server-in-gleam.md): Embed the StackQL MCP server in a Gleam app on the Erlang/BEAM target, supervised by OTP, so a BEAM service can run cloud queries over SQL with no runtime dependency.
- [How to embed the StackQL MCP server in a Go application](https://stackql.io/ai/how-tos/embed-stackql-mcp-server-in-go.md): Embed the StackQL MCP server inside a compiled Go binary using go:embed or sidecar mode, so an agentic Go app can run cloud queries and provisioning over SQL with no runtime dependency.
- [How to embed the StackQL MCP server in a Kotlin or JVM application](https://stackql.io/ai/how-tos/embed-stackql-mcp-server-in-kotlin.md): Embed the StackQL MCP server in a Kotlin/JVM app as a library or Gradle plugin, so a JVM service or CI/CD pipeline can run cloud queries and cost gates over SQL with no runtime dependency.
- [How to embed the StackQL MCP server in a Rust application](https://stackql.io/ai/how-tos/embed-stackql-mcp-server-in-rust.md): Embed the StackQL MCP server inside a Rust binary using the sidecar feature or include_bytes! vendoring, so a Rust app can run cloud queries and provisioning over SQL with no runtime dependency.
- [How to embed the StackQL MCP server in a macOS Swift application](https://stackql.io/ai/how-tos/embed-stackql-mcp-server-in-swift.md): Bundle the notarised StackQL MCP server binary inside a signed macOS Swift app, so a native menu-bar or desktop app can run cloud queries over SQL while keeping its notarisation valid.
- [How to query AWS EC2 instances with StackQL](https://stackql.io/ai/how-tos/query-aws-ec2-instances-with-stackql.md): Query EC2 instances as the SQL table aws.ec2.instances - filter by region, project attributes such as instance type and IP addresses, and aggregate across regions with GROUP BY.
- [How to query GitHub repositories with StackQL](https://stackql.io/ai/how-tos/query-github-repositories-with-stackql.md): Query GitHub repositories as the SQL table github.repos.repos - list repositories by organization or user, filter on language, visibility, and activity, and update repository settings with SQL.
- [How to query S3 buckets with StackQL](https://stackql.io/ai/how-tos/query-s3-buckets-with-stackql.md): List S3 buckets with the aws.s3.buckets table and retrieve per-bucket configuration - encryption, versioning, public access blocks - with the aws.s3.bucket detail table keyed by data__Identifier.
- [How to use StackQL with AI agents](https://stackql.io/ai/how-tos/use-stackql-with-ai-agents.md): Run StackQL as a Model Context Protocol (MCP) server so AI agents can discover cloud provider schemas, validate queries, and execute governed reads and mutations against live infrastructure.
- [How to use StackQL with Claude](https://stackql.io/ai/how-tos/use-stackql-with-claude.md): Register StackQL as an MCP server in Claude Desktop or Claude Code so Claude can query and manage cloud infrastructure across AWS, Azure, Google Cloud, GitHub, and other providers using natural language.
- [Industry positioning](https://stackql.io/ai/industry-positioning.md): Where StackQL fits in the agentic-infrastructure, AI-native IaC, and queryable-infrastructure landscape.
- [From IaC to Agentic Infrastructure](https://stackql.io/ai/industry-positioning/from-iac-to-agentic-infrastructure.md): Infrastructure tooling has moved through three eras - imperative scripts, declarative state-file IaC, and now agentic infrastructure, where AI agents operate the control plane through self-describing, governed interfaces over live state.
- [Providers reference](https://stackql.io/ai/providers.md): Per-provider, per-service, per-resource reference for StackQL - generated from provider specifications.
- [Troubleshooting](https://stackql.io/ai/troubleshooting.md): Common StackQL errors and resolutions - authentication, provider registry, server mode, PostgreSQL wire connections.
- [Common StackQL Errors](https://stackql.io/ai/troubleshooting/common-stackql-errors.md): Resolutions for the most common StackQL failures - provider not installed, missing required WHERE parameters, authentication failures, GitHub rate limiting, empty results, and MCP mutation refusals.
- [Tutorials](https://stackql.io/ai/tutorials.md): End-to-end walkthroughs - building multi-cloud inventory systems, AI infrastructure agents, governance dashboards, drift detection, and security audits with StackQL.
- [Getting started with StackQL](https://stackql.io/ai/tutorials/getting-started-with-stackql.md): Install StackQL, run your first query against live public GitHub data with no credentials, then authenticate to a cloud provider and explore the discoverable schema with SHOW and DESCRIBE.

## Documentation

- [SQL for cloud infrastructure, SaaS APIs and AI agents](https://stackql.io/index.md): StackQL is an open-source engine that lets humans and AI agents query, provision and operate cloud and SaaS services with SQL, with no state file and no per-cloud SDK.
- [AI Agents](https://stackql.io/ai-agents.md): Connect AI agents to cloud and SaaS services with StackQL through MCP servers, tools, embedded integrations and SQL queries.
- [exec](https://stackql.io/command-line-usage/exec.md): The stackql exec command runs one StackQL statement or a script of statements, with flags for output format, authentication and the provider registry.
- [Global Flags](https://stackql.io/command-line-usage/global-flags.md): Global flags for the stackql binary: authentication, output format, registry location, logging and SQL backend settings, available on every command.
- [mcp](https://stackql.io/command-line-usage/mcp.md): The stackql mcp command runs StackQL as a Model Context Protocol server for AI agents: deployment modes, safety modes, credential reloading and the audit log.
- [registry](https://stackql.io/command-line-usage/registry.md): The stackql registry command lists, pulls and manages providers from the StackQL provider registry from the command line.
- [shell](https://stackql.io/command-line-usage/shell.md): The stackql shell command launches the interactive StackQL command shell for running queries and provider commands against your cloud and SaaS accounts.
- [srv](https://stackql.io/command-line-usage/srv.md): The stackql srv command runs StackQL as a PostgreSQL wire protocol server, so psql, BI tools and language drivers can query cloud and SaaS APIs with SQL.
- [Architecture](https://stackql.io/developers/architecture.md): How StackQL works internally: entry points, the query pipeline, the any-sdk provider SDK, the SQL backend, and how a statement reaches cloud providers.
- [Developing StackQL Providers](https://stackql.io/developers/developing-stackql-providers.md): How StackQL providers are structured, built from the provider template, tested locally, and published to the StackQL Provider Registry served from Cloudflare.
- [Using StackQL with Claude Desktop](https://stackql.io/getting-started/claude-desktop.md): Use StackQL with Claude Desktop to query and provision cloud resources using natural language
- [OTel Backend Recipes](https://stackql.io/getting-started/otel-recipes.md): Cloud inventory, drift and entitlement history from StackQL otel output in ClickHouse and Datadog, with a scheduled CI example
- [Output Modes](https://stackql.io/getting-started/output-modes.md): StackQL output modes: table, json, jsonl, csv and otel, how to select them, and what each emits for shell, exec and server use.
- [Resource Heirarchy](https://stackql.io/getting-started/resource-hierarchy.md): The StackQL resource hierarchy: how providers, services, resources and methods map cloud and SaaS APIs onto queryable SQL tables.
- [Creating Infrastructure Templates](https://stackql.io/getting-started/templating.md): Generate INSERT templates for any resource with SHOW INSERT in StackQL, full or required parameters only, as the starting point for infrastructure definitions.
- [Using a Provider](https://stackql.io/getting-started/using-a-provider.md): Using a provider in StackQL: pull it from the registry, authenticate with environment variables or credentials, and query its services and resources.
- [Using StackQL](https://stackql.io/getting-started/using-stackql.md): Using StackQL: run queries interactively in the shell, non-interactively with exec, or as a server, and discover providers, services and resources as you go.
- [Using Variables](https://stackql.io/getting-started/variables.md): Using variables in StackQL: supply values from Jsonnet or JSON data files, reference them in statements, source external values and preview with dry run.
- [Installation](https://stackql.io/installing-stackql.md): Install StackQL on macOS, Linux, Windows, Docker or a cloud shell, and use the StackQL MCP server from Claude Desktop, ChatGPT, Goose and other MCP clients, or via npx, uvx, pip, Docker and GitHub Actions.
- [CREATE VIEW](https://stackql.io/language-spec/createview.md): CREATE VIEW in StackQL: save a query, including cross-cloud UNIONs, as a named view, or as a materialized view whose results are stored for reuse.
- [Data Types](https://stackql.io/language-spec/data-types.md): StackQL data types: the types used for resource properties and parameters in queries and results, and how they map to provider API schemas.
- [DELETE](https://stackql.io/language-spec/delete.md): DELETE in StackQL: remove an instance or instances of a cloud or SaaS resource with a SQL statement, taking the required parameters from the WHERE clause.
- [DESCRIBE](https://stackql.io/language-spec/describe.md): DESCRIBE in StackQL: list the fields of a resource, or the parameters and return type of a specific method, before you query or mutate it.
- [DROP VIEW](https://stackql.io/language-spec/dropview.md): DROP VIEW in StackQL: remove a view or materialized view created with CREATE VIEW.
- [EXEC](https://stackql.io/language-spec/exec.md): EXEC in StackQL: call a provider resource method directly, with query hints to return results or await completion, such as starting or stopping an instance.
- [AVG](https://stackql.io/language-spec/functions/aggregate/avg.md): AVG aggregate function in StackQL: the average of the non-NULL values in a column or grouping.
- [COUNT](https://stackql.io/language-spec/functions/aggregate/count.md): COUNT aggregate function in StackQL: the number of rows in a resource, or the non-NULL values of a column within a grouping.
- [GROUP_CONCAT](https://stackql.io/language-spec/functions/aggregate/group_concat.md): GROUP_CONCAT aggregate function in StackQL: concatenate the non-NULL values of a column or grouping into one string with an optional separator.
- [MAX](https://stackql.io/language-spec/functions/aggregate/max.md): MAX aggregate function in StackQL: the largest value in a column or grouping of columns.
- [MIN](https://stackql.io/language-spec/functions/aggregate/min.md): MIN aggregate function in StackQL: the smallest value in a column or grouping of columns.
- [SUM](https://stackql.io/language-spec/functions/aggregate/sum.md): SUM aggregate function in StackQL: the total of the non-NULL values in a column or grouping, returned as an integer when every input is an integer.
- [TOTAL](https://stackql.io/language-spec/functions/aggregate/total.md): TOTAL aggregate function in StackQL: the total of the non-NULL values in a column or grouping, always returned as a floating point number.
- [DATE](https://stackql.io/language-spec/functions/datetime/date.md): DATE function in StackQL: return a date as a YYYY-MM-DD string from a time value and optional modifiers.
- [Date Modifiers](https://stackql.io/language-spec/functions/datetime/date_modifiers.md): Date and time modifiers in StackQL: shift DATE, TIME, DATETIME, JULIANDAY and STRFTIME results by days, months or years, to a period start, a weekday and more.
- [DATETIME](https://stackql.io/language-spec/functions/datetime/datetime-fn.md): DATETIME function in StackQL: compute a datetime value from an input and one or more modifiers, returned as YYYY-MM-DD HH:MM:SS.
- [JULIANDAY](https://stackql.io/language-spec/functions/datetime/julianday.md): JULIANDAY function in StackQL: the fractional number of days since noon on 24 November 4714 BC for a time value, useful for date arithmetic.
- [STRFTIME](https://stackql.io/language-spec/functions/datetime/strftime.md): STRFTIME function in StackQL: format a datetime value with a format string, using the same substitutions as the C strftime function.
- [TIME](https://stackql.io/language-spec/functions/datetime/time.md): TIME function in StackQL: return a time as an HH:MM:SS string from a time value and optional modifiers.
- [COALESCE](https://stackql.io/language-spec/functions/general/coalesce.md): COALESCE function in StackQL: return the first non-NULL argument from two or more, typically to substitute a default for a missing value.
- [IFNULL](https://stackql.io/language-spec/functions/general/ifnull.md): IFNULL function in StackQL: return the first of exactly two arguments that is not NULL, a two-argument form of COALESCE.
- [IIF](https://stackql.io/language-spec/functions/general/iif.md): IIF function in StackQL: return one of two values depending on whether a condition is true, an inline if-then-else expression.
- [NULLIF](https://stackql.io/language-spec/functions/general/nullif.md): NULLIF function in StackQL: return NULL when two arguments are equal, otherwise return the first argument.
- [AWS_POLICY_EQUAL](https://stackql.io/language-spec/functions/json/aws_policy_equal.md): Compare two AWS IAM policy documents or AWS tags arrays for semantic equivalence using SQL.
- [JSON_ARRAY_LENGTH](https://stackql.io/language-spec/functions/json/json_array_length.md): JSON_ARRAY_LENGTH function in StackQL: the number of elements in a JSON array, at the top level or at a path within a JSON value.
- [JSON_EACH](https://stackql.io/language-spec/functions/json/json_each.md): JSON_EACH table-valued function in StackQL: expand a JSON array or object into one row per element or member, to join and filter nested API responses.
- [JSON_EQUAL](https://stackql.io/language-spec/functions/json/json_equal.md): Compare two JSON strings for equivalence using SQL.
- [JSON_EXTRACT](https://stackql.io/language-spec/functions/json/json_extract.md): JSON_EXTRACT function in StackQL: pull one or more values out of a JSON object or array by path, the main tool for flattening nested API response fields.
- [JSON_GROUP_ARRAY](https://stackql.io/language-spec/functions/json/json_group_array.md): Aggregate JSON objects into a JSON array using SQL in StackQL.
- [JSON_GROUP_OBJECT](https://stackql.io/language-spec/functions/json/json_group_object.md): Aggregate key-value pairs into a JSON object using SQL in StackQL.
- [JSON_INSERT](https://stackql.io/language-spec/functions/json/json_insert.md): Insert new values into a JSON document without overwriting existing data using SQL in StackQL.
- [JSON_OBJECT](https://stackql.io/language-spec/functions/json/json_object.md): JSON_OBJECT function in StackQL: build a JSON object from key and value arguments, for example to construct request bodies for INSERT and UPDATE.
- [JSON_PATCH](https://stackql.io/language-spec/functions/json/json_patch.md): Apply a JSON MergePatch to a JSON document using SQL in StackQL, modifying or merging JSON objects.
- [JSON_REMOVE](https://stackql.io/language-spec/functions/json/json_remove.md): Remove elements from a JSON document by specifying paths using SQL in StackQL.
- [JSON_REPLACE](https://stackql.io/language-spec/functions/json/json_replace.md): Replace existing values in a JSON document using SQL in StackQL.
- [JSON_SET](https://stackql.io/language-spec/functions/json/json_set.md): Update or insert values in a JSON document using SQL in StackQL.
- [JSON_TYPE](https://stackql.io/language-spec/functions/json/json_type.md): JSON_TYPE function in StackQL: the type (object, array, text, integer, real, true, false or null) of a JSON value's outermost element, or of a path within it.
- [ABS](https://stackql.io/language-spec/functions/math/abs.md): ABS function in StackQL: the absolute value of a numeric argument.
- [CEIL](https://stackql.io/language-spec/functions/math/ceil.md): CEIL function in StackQL: round a numeric argument up to the nearest integer.
- [FLOOR](https://stackql.io/language-spec/functions/math/floor.md): FLOOR function in StackQL: round a numeric argument down to the nearest integer.
- [LN](https://stackql.io/language-spec/functions/math/logarithmic/ln.md): Calculate the natural logarithm of a number using SQL in StackQL.
- [LOG](https://stackql.io/language-spec/functions/math/logarithmic/log.md): Calculate the logarithm of a number for any base using SQL in StackQL.
- [LOG10](https://stackql.io/language-spec/functions/math/logarithmic/log10.md): Calculate the base-10 logarithm of a number using SQL in StackQL.
- [LOG2](https://stackql.io/language-spec/functions/math/logarithmic/log2.md): Calculate the base-2 logarithm of a number using SQL in StackQL.
- [MOD](https://stackql.io/language-spec/functions/math/mod.md): Calculate the remainder of one number divided by another using SQL in StackQL.
- [POW](https://stackql.io/language-spec/functions/math/pow.md): Calculate the power of one number raised to another using SQL in StackQL.
- [ROUND](https://stackql.io/language-spec/functions/math/round.md): ROUND function in StackQL: round a numeric argument to a given number of decimal places, defaulting to zero.
- [SIGN](https://stackql.io/language-spec/functions/math/sign.md): SIGN function in StackQL: return -1, 0 or 1 depending on whether a numeric argument is negative, zero or positive.
- [SQRT](https://stackql.io/language-spec/functions/math/sqrt.md): Calculate the square root of a number using SQL in StackQL.
- [ACOS](https://stackql.io/language-spec/functions/math/trigonometric/acos.md): Calculate the arc cosine (inverse cosine) of a number, returning an angle in radians using SQL in StackQL.
- [ACOSH](https://stackql.io/language-spec/functions/math/trigonometric/acosh.md): Calculate the hyperbolic arc cosine (inverse hyperbolic cosine) of a number, returning an angle in radians using SQL in StackQL.
- [ASIN](https://stackql.io/language-spec/functions/math/trigonometric/asin.md): Calculate the arc sine (inverse sine) of a number, returning an angle in radians using SQL in StackQL.
- [ASINH](https://stackql.io/language-spec/functions/math/trigonometric/asinh.md): Calculate the hyperbolic arc sine (inverse hyperbolic sine) of a number, returning an angle in radians using SQL in StackQL.
- [ATAN](https://stackql.io/language-spec/functions/math/trigonometric/atan.md): Calculate the arc tangent (inverse tangent) of a number, returning an angle in radians using SQL in StackQL.
- [ATAN2](https://stackql.io/language-spec/functions/math/trigonometric/atan2.md): Calculate the arc tangent of two numbers (y/x), returning an angle in radians using SQL in StackQL.
- [ATANH](https://stackql.io/language-spec/functions/math/trigonometric/atanh.md): Calculate the hyperbolic arc tangent (inverse hyperbolic tangent) of a number, returning an angle in radians using SQL in StackQL.
- [COS](https://stackql.io/language-spec/functions/math/trigonometric/cos.md): Calculate the cosine of an angle, provided in radians, using SQL in StackQL.
- [COSH](https://stackql.io/language-spec/functions/math/trigonometric/cosh.md): Calculate the hyperbolic cosine of a number, returning the result using SQL in StackQL.
- [DEGREES](https://stackql.io/language-spec/functions/math/trigonometric/degrees.md): Convert an angle from radians to degrees using SQL in StackQL.
- [PI](https://stackql.io/language-spec/functions/math/trigonometric/pi.md): Retrieve the mathematical constant π (pi) using SQL in StackQL.
- [RADIANS](https://stackql.io/language-spec/functions/math/trigonometric/radians.md): Convert an angle from degrees to radians using SQL in StackQL.
- [SIN](https://stackql.io/language-spec/functions/math/trigonometric/sin.md): Calculate the sine of an angle, provided in radians, using SQL in StackQL.
- [SINH](https://stackql.io/language-spec/functions/math/trigonometric/sinh.md): Calculate the hyperbolic sine of a number, returning the result using SQL in StackQL.
- [TAN](https://stackql.io/language-spec/functions/math/trigonometric/tan.md): Calculate the tangent of an angle, provided in radians, using SQL in StackQL.
- [TANH](https://stackql.io/language-spec/functions/math/trigonometric/tanh.md): Calculate the hyperbolic tangent of a number, returning the result using SQL in StackQL.
- [TRUNC](https://stackql.io/language-spec/functions/math/trunc.md): TRUNC function in StackQL: the integer part of a number, rounding towards zero and discarding any fraction.
- [Regex Reference](https://stackql.io/language-spec/functions/re/reference.md): Regular expression reference for StackQL: syntax, character classes, anchors, quantifiers and groups for REGEXP_LIKE, REGEXP_REPLACE and REGEXP_SUBSTR.
- [REGEXP](https://stackql.io/language-spec/functions/re/regexp.md): Use regular expressions to match patterns in strings using SQL in StackQL.
- [REGEXP_LIKE](https://stackql.io/language-spec/functions/re/regexp_like.md): REGEXP_LIKE function in StackQL: test whether a string matches a regular expression, returning true or false, for pattern filters in WHERE clauses.
- [REGEXP_REPLACE](https://stackql.io/language-spec/functions/re/regexp_replace.md): REGEXP_REPLACE function in StackQL: replace the parts of a string that match a regular expression with a replacement string.
- [REGEXP_SUBSTR](https://stackql.io/language-spec/functions/re/regexp_substr.md): REGEXP_SUBSTR function in StackQL: extract the substring of an input that matches a regular expression.
- [CHAR](https://stackql.io/language-spec/functions/string/char.md): CHAR function in StackQL: the characters for one or more character codes, for putting newlines, quotes, tabs and other control characters into strings.
- [Concatenation Operator](https://stackql.io/language-spec/functions/string/concatenation.md): The || concatenation operator in StackQL: join two or more string values into one string.
- [INSTR](https://stackql.io/language-spec/functions/string/instr.md): INSTR function in StackQL: the one-based position of the first occurrence of one string inside another, or 0 when it is not found.
- [LENGTH](https://stackql.io/language-spec/functions/string/length.md): LENGTH function in StackQL: the number of characters in a string, or the number of bytes in a BLOB.
- [LOWER](https://stackql.io/language-spec/functions/string/lower.md): LOWER function in StackQL: convert a string to lowercase.
- [LTRIM](https://stackql.io/language-spec/functions/string/ltrim.md): LTRIM function in StackQL: remove whitespace, or a given set of characters, from the left of a string.
- [REPLACE](https://stackql.io/language-spec/functions/string/replace.md): REPLACE function in StackQL: substitute every occurrence of a substring within a string with another string.
- [RTRIM](https://stackql.io/language-spec/functions/string/rtrim.md): RTRIM function in StackQL: remove whitespace, or a given set of characters, from the right of a string.
- [SPLIT_PART](https://stackql.io/language-spec/functions/string/split_part.md): SPLIT_PART function in StackQL: split a string on a separator and return the part at a one-based position, handy for picking apart resource IDs and ARNs.
- [SUBSTRING](https://stackql.io/language-spec/functions/string/substring.md): SUBSTRING function in StackQL (alias SUBSTR): return part of a string or binary value by start position and length.
- [TRIM](https://stackql.io/language-spec/functions/string/trim.md): TRIM function in StackQL: remove whitespace, or a given set of characters, from both ends of a string.
- [UPPER](https://stackql.io/language-spec/functions/string/upper.md): UPPER function in StackQL: convert a string to uppercase.
- [CUME_DIST](https://stackql.io/language-spec/functions/window/cume_dist.md): CUME_DIST window function in StackQL: the cumulative distribution of the current row within its partition, as row number divided by partition rows.
- [DENSE_RANK](https://stackql.io/language-spec/functions/window/dense_rank.md): DENSE_RANK window function in StackQL: the rank of the current row in its partition without gaps, so tied rows share a rank and the next rank follows at once.
- [FIRST_VALUE](https://stackql.io/language-spec/functions/window/first_value.md): FIRST_VALUE window function in StackQL: the value of an expression for the first row of the window frame.
- [LAG](https://stackql.io/language-spec/functions/window/lag.md): LAG window function in StackQL: evaluate an expression against a previous row in the partition, with an optional offset and default.
- [LAST_VALUE](https://stackql.io/language-spec/functions/window/last_value.md): LAST_VALUE window function in StackQL: the value of an expression for the last row of the window frame.
- [LEAD](https://stackql.io/language-spec/functions/window/lead.md): LEAD window function in StackQL: evaluate an expression against a following row in the partition, with an optional offset and default.
- [NTH_VALUE](https://stackql.io/language-spec/functions/window/nth_value.md): NTH_VALUE window function in StackQL: the value of an expression for the Nth row of the window frame.
- [NTILE](https://stackql.io/language-spec/functions/window/ntile.md): NTILE window function in StackQL: split a partition into N groups as evenly as possible and number each row's group from 1 to N.
- [PERCENT_RANK](https://stackql.io/language-spec/functions/window/percent_rank.md): PERCENT_RANK window function in StackQL: the relative rank of the current row within its partition as a value between 0.0 and 1.0.
- [RANK](https://stackql.io/language-spec/functions/window/rank.md): RANK window function in StackQL: the rank of the current row within its partition with gaps, so tied rows share a rank and the following ranks are skipped.
- [ROW_NUMBER](https://stackql.io/language-spec/functions/window/row_number.md): ROW_NUMBER window function in StackQL: number the rows within a partition from 1 in the order given by the window's ORDER BY clause.
- [INSERT](https://stackql.io/language-spec/insert.md): INSERT in StackQL: create one or more instances of a cloud or SaaS resource with a SQL statement, passing required and optional fields as columns and values.
- [Keywords](https://stackql.io/language-spec/keywords.md): StackQL keywords: the reserved words of the StackQL grammar, which can be written in any case and must be quoted when used as identifiers.
- [Lexical Structure](https://stackql.io/language-spec/lexical-structure.md): The lexical structure of StackQL: how statements, identifiers, quoting, literals, comments and whitespace are tokenised by the parser.
- [REFRESH VIEW](https://stackql.io/language-spec/refreshview.md): REFRESH VIEW in StackQL: rebuild the stored results of a materialized view from its defining query.
- [REGISTRY](https://stackql.io/language-spec/registry.md): REGISTRY in StackQL: list the providers and versions in the provider registry and pull the latest or a specific version into your installation.
- [REPLACE](https://stackql.io/language-spec/replace.md): REPLACE in StackQL: replace every field of a resource instance, equivalent to an HTTP PUT, as opposed to the partial update performed by UPDATE.
- [SELECT](https://stackql.io/language-spec/select.md): SELECT in StackQL: query cloud and SaaS resources with SQL, with WHERE filters that map to API parameters, joins, grouping, ordering and JSON field access.
- [SHOW](https://stackql.io/language-spec/show.md): SHOW in StackQL: list providers, services, resources and methods, generate INSERT templates, and inspect the running binary's version, contributors and dependencies.
- [UPDATE](https://stackql.io/language-spec/update.md): UPDATE in StackQL: change specified fields of a resource instance, equivalent to an HTTP PATCH, with the target identified by the WHERE clause.
- [Utility Commands](https://stackql.io/language-spec/utility-commands.md): StackQL shell utility commands such as clear and sleep, with their syntax and when to use them in interactive sessions and scripts.
- [Window Functions](https://stackql.io/language-spec/windowing_functions.md): Window functions in StackQL: ranks, running totals, offsets and distributions across related rows, with PARTITION BY, ORDER BY and frame clauses.
- [WITH (CTEs)](https://stackql.io/language-spec/with.md): WITH in StackQL: define common table expressions (CTEs), temporary named result sets scoped to a single SELECT, INSERT, UPDATE or DELETE statement.
- [MCP Tools](https://stackql.io/mcp.md): All tools exposed by the StackQL MCP server, grouped by purpose
- [describe_method](https://stackql.io/mcp/describe_method.md): MCP tool returning the full I/O contract for one StackQL access method
- [Embedded MCP Servers](https://stackql.io/mcp/embedded.md): Embed the StackQL MCP server directly in compiled applications across Go, Rust, Swift, and Kotlin
- [.NET / C#](https://stackql.io/mcp/embedded/dotnet.md): Embed the StackQL MCP server in a .NET application as a sidecar or vendored bundle
- [Gleam](https://stackql.io/mcp/embedded/gleam.md): Embed the StackQL MCP server in a Gleam application on the Erlang/BEAM target
- [Go](https://stackql.io/mcp/embedded/go.md): Embed the StackQL MCP server in a Go application via go:embed or sidecar
- [Kotlin / JVM](https://stackql.io/mcp/embedded/kotlin.md): Embed the StackQL MCP server in a Kotlin/JVM application as a library or Gradle plugin
- [Rust](https://stackql.io/mcp/embedded/rust.md): Embed the StackQL MCP server in a Rust application via sidecar or include_bytes! vendoring
- [Swift](https://stackql.io/mcp/embedded/swift.md): Bundle the notarised StackQL MCP server binary inside a signed macOS app
- [list_methods](https://stackql.io/mcp/list_methods.md): MCP tool listing access methods for a StackQL resource
- [list_providers](https://stackql.io/mcp/list_providers.md): MCP tool listing cloud and SaaS providers available to the StackQL MCP server
- [list_registry](https://stackql.io/mcp/list_registry.md): MCP tool listing providers and versions available in the StackQL provider registry
- [list_resources](https://stackql.io/mcp/list_resources.md): MCP tool listing resources under a StackQL provider.service
- [list_services](https://stackql.io/mcp/list_services.md): MCP tool listing services under a StackQL provider
- [pull_provider](https://stackql.io/mcp/pull_provider.md): MCP tool installing a StackQL provider from the registry into the local cache
- [reload_credentials](https://stackql.io/mcp/reload_credentials.md): MCP tool re-sourcing credentials from the --env.file dotenv file and reporting per-provider resolution status
- [run_lifecycle_operation](https://stackql.io/mcp/run_lifecycle_operation.md): MCP tool executing a StackQL EXEC lifecycle operation
- [run_mutation_query](https://stackql.io/mcp/run_mutation_query.md): MCP tool executing INSERT, UPDATE, REPLACE, or DELETE against a provider via StackQL
- [run_select_query](https://stackql.io/mcp/run_select_query.md): MCP tool executing a StackQL SELECT against a provider
- [server_info](https://stackql.io/mcp/server_info.md): MCP tool returning StackQL MCP server identity and runtime
- [validate_select_query](https://stackql.io/mcp/validate_select_query.md): MCP tool parsing and planning a StackQL SELECT without executing it
- [Available Providers](https://stackql.io/providers.md): The StackQL provider catalog: every cloud and SaaS provider you can query and manage with SQL, grouped by category, each linking to its own reference site.
- [StackQL in AWS Cloud Shell](https://stackql.io/quick-starts/aws/aws-cloud-shell.md): Run StackQL in AWS CloudShell as the logged-in user: download the Linux package, use the stackql shell, assume an IAM role and run batch queries with exec.
- [AWS Global Inventory](https://stackql.io/quick-starts/aws/aws-global-inventory.md): Inventory every AWS resource across all regions with StackQL: asynchronous queries, excluded resource types and filters for AWS-managed defaults.
- [Cross Region Queries](https://stackql.io/quick-starts/aws/cross-region-queries.md): Query and aggregate AWS resources across multiple regions in one StackQL statement, with region lists and asynchronous execution instead of per-region loops.
- [Monitoring Azure Activity](https://stackql.io/quick-starts/azure/azure-activity-monitor.md): Query and Deploy Azure Cloud Infrastructure and Resources using SQL
- [Repo Activity Monitor](https://stackql.io/quick-starts/github/oss-activity-monitor.md): Real-Time Insights for OSS Maintainers using StackQL
- [IAM Bindings Framework](https://stackql.io/quick-starts/google/iam-bindings-framework.md): Query and Deploy Google Cloud Infrastructure and Resources using SQL

## Blog - Product Announcements

- [Builtin Parallel Query Execution in StackQL](https://stackql.io/blog/product/builtin-parallel-query-execution-in-stackql.md): stackql is a dev tool that allows you to query and manage cloud and SaaS resources using SQL, which developers and analysts can use for CSPM, assurance, user access management reporting, IaC, XOps and more.
- [Introducing Materialized Views with StackQL](https://stackql.io/blog/product/introducing-materialized-views-with-stackql.md): Materialized Views are now available in StackQL.  Materialized Views can be used to improve performance for dependent or repetetive queries within StackQL provisioning or analytics routines.
- [Introducing model-driven IaC with stackql-deploy](https://stackql.io/blog/product/introducing-model-driven-iac-with-stackql-deploy.md): Provision, test, update and tear down multi-cloud infrastructure using SQL models with stackql-deploy, a framework inspired by dbt.
- [Introducing Table Valued Functions in StackQL](https://stackql.io/blog/product/introducing-table-valued-functions-in-stackql.md): Many provider query responses include columns which are arrays, the iam policy related resources in google are a classic example of this.  for example, this query:
- [Introducing the StackQL Provider Registry](https://stackql.io/blog/product/introducing-the-stackql-provider-registry.md): The StackQL provider registry allows contributors to add support for different providers (major cloud, alt cloud and SaaS providers) using a no-code approach.
- [Linux arm64 StackQL Binary Available](https://stackql.io/blog/product/linux-arm64-build-available.md): ARM64 architecture build available for StackQL.
- [Markdown-KV Output Format Available in pystackql](https://stackql.io/blog/product/markdownkv-output-format-available-in-pystackql.md): New output format in pystackql optimizes cloud infrastructure data for LLM processing based on research showing accuracy improvement over CSV.
- [Run the StackQL MCP Server Anywhere Your Agent Does](https://stackql.io/blog/product/run-the-stackql-mcp-server-anywhere.md): The StackQL MCP server now ships via npm, PyPI, Docker, GitHub Actions, prebuilt Claude Desktop bundles, and the Official MCP Registry - one server, every runtime, signed and SHA-pinned.
- [Using the setup-stackql Github Action](https://stackql.io/blog/product/setup-stackql-github-action.md): This is a how-to article demonstrating the use of setup-stackql github action to run stackql with github actions
- [stackql-deploy 2.0 - Rewritten in Rust](https://stackql.io/blog/product/stackql-deploy-2-0-rust-rewrite.md): stackql-deploy 2.0 is a full rewrite in Rust - single static binary, no Python runtime, embedded StackQL server, and same CLI interface.
- [stackql-deploy Docs Site Live](https://stackql.io/blog/product/stackql-deploy-docs-site-live.md): Use stackql-deploy to deploy and test cloud resource deployments.
- [GitHub Action available for stackql-deploy](https://stackql.io/blog/product/stackql-deploy-github-action-available.md): Use stackql-deploy in a GitHub Actions workflow to provision, update and test infrastructure.
- [StackQL Joins the Linux Foundation and Agentic AI Foundation](https://stackql.io/blog/product/stackql-joins-linux-foundation-agentic-ai-foundation.md): StackQL Studios joins the Linux Foundation and Agentic AI Foundation as a Silver Member.
- [StackQL update: MCP protocol revision 2026-07-28 and OpenTelemetry output](https://stackql.io/blog/product/stackql-mcp-2026-07-28-and-opentelemetry.md): StackQL v0.11 brings the MCP server up to protocol revision 2026-07-28, and adds an OpenTelemetry (OTLP/JSON) output format for the agent audit log so any OTel collector can consume it without a custom parser.
- [StackQL MCP server now available in the Anthropic MCP Directory](https://stackql.io/blog/product/stackql-mcp-anthropic-directory.md): The StackQL MCP server is listed in the Anthropic MCP Directory. It is now discoverable and installable directly from Claude Desktop, with future releases flowing through automatically from GitHub.
- [StackQL MCP Server Now Available](https://stackql.io/blog/product/stackql-mcp-server-now-available.md): Enable AI agents to query and manage cloud infrastructure using the Model Context Protocol.
- [StackQL Middleware and Playground Available](https://stackql.io/blog/product/stackql-middleware-and-playground-available.md): The StackQL Middleware Server along with the StackQL Playground App allow users to explore and query resources from API providers using SQL.
- [StackQL Provider Development Skill for Claude](https://stackql.io/blog/product/stackql-provider-development-skill-for-claude.md): A Claude Skill for developing StackQL providers, covering OpenAPI extensions, resource definitions, SQL verb mappings, and more.
- [StackQL PyPI Package is Now Available](https://stackql.io/blog/product/stackql-pypi-package-available.md): This how-to article demonstrates how to use stackql with Python using the pystackql package
- [Support for Outer Joins Released for StackQL](https://stackql.io/blog/product/support-for-outer-joins-released.md): Announcing the addition of support for OUTER JOIN operations in StackQL queries.
- [Window Functions and CTEs Now Available in StackQL](https://stackql.io/blog/product/window-functions-and-ctes-now-available.md): Window functions and Common Table Expressions (CTEs) are now available in StackQL for advanced analytics across cloud and SaaS resources.
- [StackQL now runs natively on Windows ARM64](https://stackql.io/blog/product/windows-arm64-build-available.md): Native Windows ARM64 builds are now available for the StackQL CLI and MCP server, with MSI, ZIP and MCPB downloads.

## Blog - Provider Announcements

- [Anthropic Provider for StackQL Available](https://stackql.io/blog/providers/anthropic-provider-for-stackql-available.md): Query and interact with Anthropic Claude using SQL.
- [Anthropic Providers Update - July 2026](https://stackql.io/blog/providers/anthropic-providers-update-july-2026.md): Latest release of the StackQL Anthropic providers - anthropic for the Claude API (messages, agents, sessions, skills, files, vaults and more) and anthropic_admin for enterprise organization management, usage and cost reporting, and Claude Code analytics - are available in the StackQL Provider Registry now.
- [Anthropic Providers Update - September 2026](https://stackql.io/blog/providers/anthropic-providers-update-september-2026.md): Update to the StackQL anthropic provider regenerated from the current Claude API spec - a new dreams service for memory consolidation jobs, files and skills on their GA endpoints, and workspace-scoped queries through the anthropic-workspace-id parameter. The anthropic_admin provider is unchanged.
- [AWS Provider Update - August 2026](https://stackql.io/blog/providers/aws-provider-update-august-2026.md): Update to the StackQL AWS provider adding nine new services including Resilience Hub V2, Lambda MicroVMs, Agent Registry and Support AuthZ, expanded coverage across EC2, ACM, QuickSight, Bedrock AgentCore and more, plus full S3 object content lifecycles - read, write, replace and delete object contents with SQL.
- [StackQL provider for Azure is now available](https://stackql.io/blog/providers/azure-provider-for-stackql-released.md): The StackQL provider for Azure provides key visibility across the Azure estate for CSPM, asset inventory and analysis, finops and more, as well as our IaC and ops (lifecycle management) functionality.
- [Azure Provider Update - July 2026](https://stackql.io/blog/providers/azure-provider-update-july-2026.md): Major update to the StackQL Azure provider - 268 services covering the ARM control plane and Azure data planes in one provider, with expanded AI coverage including Azure AI Foundry, AI Language, Document Intelligence, Content Safety and more, available in the StackQL Provider Registry now.
- [Confluent provider for stackql released](https://stackql.io/blog/providers/confluent-provider-for-stackql-released.md): Query and interact with Confluent Cloud resources using SQL.
- [Confluent Provider Update - May 2026](https://stackql.io/blog/providers/confluent-provider-may-2026-update.md): Update to the StackQL Confluent provider adding eight new services including ccl, ccpm, endpoints, pipelines, share_group, streams_group, tableflow, and usm, along with 40 additional resources across existing services.
- [Databricks Provider for StackQL Available](https://stackql.io/blog/providers/databricks-provider-for-stackql-available.md): Query and interact with Databricks resources using SQL.
- [Databricks Providers Update - July 2026](https://stackql.io/blog/providers/databricks-providers-update-july-2026.md): Update to the StackQL Databricks providers adding four new services including disaster recovery, AI Search, bundle deployments and supervisor agents, a major expansion of Lakebase (Postgres) and identity coverage, and improved SQL statement execution semantics including DELETE to cancel running statements.
- [Deno Deploy Provider Available](https://stackql.io/blog/providers/deno-deploy-provider-available.md): Query and interact with Deno Deploy resources using SQL.
- [Digital Ocean provider for StackQL Available](https://stackql.io/blog/providers/digitalocean-provider-for-stackql-released.md): The Digital Ocean provider for StackQL enables you to provision, query and manage Digital Ocean assets using StackQL SQL.
- [GitHub Provider Update - April 2026](https://stackql.io/blog/providers/github-provider-april-2026-update.md): Update to the StackQL GitHub provider adding six new services including agent_tasks, campaigns, classroom, hosted_compute, private_registries, and enterprise_teams, along with resource additions across existing services.
- [GitHub Provider for StackQL Released](https://stackql.io/blog/providers/github-provider-for-stackql-released.md): The StackQL provider for GitHub is now available, you can use this provider to query public and protected resources in GitHub.
- [GoDaddy Provider for StackQL Now Available](https://stackql.io/blog/providers/godaddy-provider-for-stackql-now-available.md): Give us a ⭐ on GitHub
- [Google Provider Update - December 2025](https://stackql.io/blog/providers/google-provider-december-2025-update.md): Major update to the StackQL Google provider featuring a new Speech-to-Text v2 service, enhanced Vertex AI with RAG capabilities, and significant improvements across BigQuery, Spanner, and 15+ other Google Cloud services.
- [Google Provider Update - August 2026](https://stackql.io/blog/providers/google-provider-update-august-2026.md): Update to the StackQL Google provider adding eleven new services including Agent Registry, Agent Identity, Cluster Director, Database Center and Google Threat Intelligence, a major expansion of Compute Engine and Vertex AI coverage, and removal of APIs retired by Google.
- [Kubernetes Provider for StackQL Released](https://stackql.io/blog/providers/kubernetes-provider-for-stackql-released.md): The StackQL provider for Kubernetes has been released, you can use this to query node, namespaces, pods, services and more in a k8s cluster.
- [New AWS Provider Available (Jan 2025)](https://stackql.io/blog/providers/latest-aws-provider-for-stackql-released.md): Query and interact with AWS resources using SQL.
- [Latest Datadog Provider for StackQL Available](https://stackql.io/blog/providers/latest-datadog-provider-available.md): Query and interact with Datadog resources using SQL.
- [Latest DigitalOcean Provider Available](https://stackql.io/blog/providers/latest-digitalocean-provider-available.md): Query and interact with DigitalOcean resources using SQL.
- [Updated Google Provider Available](https://stackql.io/blog/providers/latest-google-provider-available.md): Deploy, configure and query GCP resources using SQL.
- [Latest Linode Provider for StackQL Available](https://stackql.io/blog/providers/latest-linode-provider-available.md): Query and interact with Linode resources using SQL.
- [StackQL Linode provider Released](https://stackql.io/blog/providers/linode-provider-for-stackql-released.md): The Linode provider for StackQL enables you to provision, query and manage Linode resources using StackQL SQL.
- [Netlify Provider for StackQL Released](https://stackql.io/blog/providers/netlify-provider-for-stackql-released.md): The StackQL provider for Netlify has been released, you can use this to query sites, builds and more in Netlify.
- [New Dedicated AWS Cloud Control Provider Released](https://stackql.io/blog/providers/new-awscc-provider-available.md): Introducing the standalone StackQL AWS Cloud Control provider with full CRUDL support, optimized resource naming, and comprehensive coverage of AWS Cloud Control API resources.
- [New Azure Providers for StackQL Available](https://stackql.io/blog/providers/new-azure-providers-for-stackql-available.md): The StackQL provider for Azure provides key visibility across the Azure estate for CSPM, asset inventory and analysis, finops and more, as well as our IaC and ops (lifecycle management) functionality.
- [New ClickHouse Cloud Provider Available](https://stackql.io/blog/providers/new-clickhouse-provider-available.md): A new StackQL provider for the ClickHouse Cloud API - query and provision organizations, services, API keys, members and roles, backups, ClickPipes, ClickStack dashboards and alerts, UDFs and Managed Postgres, and report usage cost by day and entity, using SQL - available in the StackQL Provider Registry now.
- [New Databricks Providers for StackQL Released](https://stackql.io/blog/providers/new-databricks-providers-available.md): Updated providers for Databricks released covering account and workspace operations, with over 30 services, 300 resources, and nearly 1,000 operations queryable using SQL.
- [New Functions and Azure Provider Available](https://stackql.io/blog/providers/new-functions-and-azure-provider-available.md): The StackQL provider for Azure provides key visibility across the Azure estate for CSPM, asset inventory and analysis, finops and more, as well as our IaC and ops (lifecycle management) functionality.
- [New Google Gemini Provider Available](https://stackql.io/blog/providers/new-gemini-provider-available.md): A new StackQL provider for the Google Gemini API - run Gemini inference, count tokens, generate embeddings, and manage models, tuned models, files, cached contents, corpora, file search stores and batches using SQL - available in the StackQL Provider Registry now.
- [New GitLab Provider Available](https://stackql.io/blog/providers/new-gitlab-provider-available.md): A new read-only StackQL provider for GitLab, generated from the GitLab GraphQL schema - projects, groups, members, issues, merge requests, pipelines, jobs, runners, releases, environments, packages, vulnerabilities and more as SQL, with transparent Relay pagination and pushed-down filters - available in the StackQL Provider Registry now.
- [Updated google provider for StackQL available](https://stackql.io/blog/providers/new-google-provider-available.md): Deploy, configure and query GCP resources using SQL.
- [New Kubernetes Provider Available](https://stackql.io/blog/providers/new-kubernetes-provider-available.md): A ground-up rebuild of the StackQL k8s provider - every built-in Kubernetes control plane API group as SQL, with subresources, server-side filtering, transparent pagination, and a full write lifecycle, pointable at any conformant cluster - available in the StackQL Provider Registry now.
- [New Oracle Cloud Infrastructure Provider Available](https://stackql.io/blog/providers/new-oci-provider-available.md): A new StackQL provider for Oracle Cloud Infrastructure - compute, networking, storage, database, identity, budgets, usage and audit as SQL, with OCI request signing built into the engine - completing multicloud inventory and FinOps coverage across oci, aws, azure and google.
- [New Okta Provider Released](https://stackql.io/blog/providers/new-okta-provider-released.md): Query and interact with Okta resources using SQL.
- [New Railway Provider Available](https://stackql.io/blog/providers/new-railway-provider-available.md): A new StackQL provider for Railway - query and manage workspaces, projects, environments, services, deployments, variables, domains, volumes and usage using SQL - available in the StackQL Provider Registry now.
- [New Azure Providers Available](https://stackql.io/blog/providers/new-stackql-azure-providers-jun-2024.md): The StackQL provider for Azure provides key visibility across the Azure estate for CSPM, asset inventory and analysis, finops and more, as well as our IaC and ops (lifecycle management) functionality.
- [New Supabase Provider Available](https://stackql.io/blog/providers/new-supabase-provider-available.md): A new StackQL provider for Supabase - query and manage organizations, projects, branches, edge functions, secrets, auth and Postgres configuration, network restrictions and the project database itself using SQL - available in the StackQL Provider Registry now.
- [New TypeSafe Provider Available](https://stackql.io/blog/providers/new-typesafe-provider-available.md): A new StackQL provider for TypeSafe AI that brings Jev, TypeSafe's System One decision model, into StackQL agent routines over MCP - rows from aws, k8s, okta or github become the state, Jev returns a typed decision with a probability or confidence, and a StackQL mutation runs only when the decision clears the routine's threshold. Tagging hygiene, rightsizing, incident triage, access review, public ingress review and audit findings, as SQL.
- [OpenAI Provider for StackQL Available](https://stackql.io/blog/providers/openai-provider-for-stackql-available.md): Deploy, configure and query openai resources using SQL.
- [OpenAI Providers Update - July 2026](https://stackql.io/blog/providers/openai-providers-update-july-2026.md): Latest release of the StackQL OpenAI providers - openai for the platform API (models, files, fine-tuning, batches, vector stores, evals and more) and openai_admin for organization management, usage and cost reporting, projects, RBAC and audit logs - are available in the StackQL Provider Registry now.
- [Snowflake Provider for StackQL Released](https://stackql.io/blog/providers/snowflake-provider-for-stackql-released.md): Query and interact with Snowflake resources using SQL.
- [StackQL Provider for AWS Released](https://stackql.io/blog/providers/stackql-aws-provider-released.md): The StackQL provider for AWS provides key visibility across the AWS estate for CSPM, asset inventory and analysis, finops and more, as well as our IaC and ops (lifecycle management) functionality.
- [StackQL Providers for DataDog and PagerDuty Now Available](https://stackql.io/blog/providers/stackql-providers-for-datadog-and-pagerduty-now-available.md): stackql is a dev tool that allows you to query and manage cloud and SaaS resources using SQL, which developers and analysts can use for CSPM, assurance, user access management reporting, IaC, XOps and more.
- [Sumologic Provider for StackQL Now Available](https://stackql.io/blog/providers/sumologic-provider-for-stackql-now-available.md): The StackQL provider for Sumologic is now available, allowing you to query, create, update and delete Sumologic collectors, sources, and more.
- [Cloudflare Provider - May 2026](https://stackql.io/blog/providers/updated-cloudflare-provider-available.md): Initial release of the StackQL Cloudflare provider with 108 services, 1259 resources, and 2840 operations spanning Zero Trust, Workers, R2, DNS, Zones, Radar, AI, Stream, Magic Transit, and more.
- [Datadog Provider - August 2026](https://stackql.io/blog/providers/updated-datadog-provider-available.md): The StackQL Datadog provider now covers the v1 and v2 REST APIs together - monitors, dashboards, synthetics, SLOs, downtimes, incidents, cases, on-call, logs configuration, metrics, security monitoring, cloud cost, users, roles and keys, integrations, RUM, LLM Observability and fleet automation.
- [Updated Google Providers for StackQL Available](https://stackql.io/blog/providers/updated-google-providers-available.md): Query and interact with Google resources using SQL.
- [Vercel provider for StackQL available](https://stackql.io/blog/providers/vercel-provider-for-stackql-available.md): stackql is a dev tool that allows you to query and manage cloud and SaaS resources using SQL, which developers and analysts can use for CSPM, assurance, user access management reporting, IaC, XOps and more.

## Blog - Tutorials

- [From finding to fix: cloud auto-remediation with AI and StackQL](https://stackql.io/blog/tutorials/ai-remediation-pull-requests.md): An audit tells you what is wrong. This is the other half - a GitHub Actions loop that opens one pull request per finding, checks live state before it mutates, and applies on merge. OIDC only, no agents in the estate, GitHub as the audit trail.
- [Enable Logging for Google Cloud Storage Buckets and Analyzing Logs in Big Query (Part II)](https://stackql.io/blog/tutorials/analyze-gcs-usage-logs-in-bigquery.md): This post demonstrates how to enable logging for a Google Cloud Storage bucket and analyze usage logs in Big Query using StackQL - a new, SQL based approach to deploying and querying cloud resources.
- [Analyzing IAM in the GCP Resource Hierarchy](https://stackql.io/blog/tutorials/analyzing-iam-in-the-gcp-resource-heirarchy.md): Data-centric approach to understanding entitlements across a GCP org with a complex hierarchy.
- [Auditing three clouds without writing three scripts](https://stackql.io/blog/tutorials/auditing-three-clouds-without-writing-three-scripts.md): A hands-on walkthrough of the StackQL multi-cloud bucket audit. One Docker command, one SQL query, and you get a normalised table of AWS, GCP, and Azure storage buckets with encryption class, public flag, and HTTPS enforcement side by side.
- [Autonomous Edge Defense with AI Agents and SQL](https://stackql.io/blog/tutorials/autonomous-edge-defense-ai-agents-sql.md): An agentic loop that observes Cloudflare edge traffic, tightens rate limits in response, and writes an auditable decision trail to Kafka - all through one SQL interface.
- [Big Query Cost Analysis using StackQL](https://stackql.io/blog/tutorials/big-query-cost-analysis-using-stackql.md): This article demonstrates how to use StackQL to summarize or drill down into detail Big Query billing data for analysis into billing spikes or anomalies.
- [Cloud and SaaS Visibility with StackQL and PowerBI](https://stackql.io/blog/tutorials/cloud-and-saas-visibility-with-stackql-and-powerbi.md): stackql is a dev tool that allows you to query and manage cloud and SaaS resources using SQL, which developers and analysts can use for CSPM, assurance, user access management reporting, IaC, XOps and more.
- [Cloud security and inventory analysis with StackQL and Jupyter](https://stackql.io/blog/tutorials/cloud-security-and-inventory-analysis-with-stackql-and-jupyter.md): StackQL can be used with Jupyter to provide valuable insights into your cloud and SaaS estates, whether for security posture management, cross-cloud entitlements reporting, cost optimization, or asset/inventory management.
- [Add continuous cloud audit to your CI/CD in ten minutes](https://stackql.io/blog/tutorials/continuous-cloud-audit-github-actions.md): Cloud security reviews are usually quarterly. Configuration drift happens daily. Between review cycles, buckets get created, firewall rules get loosened, service accounts get reused, and a bucket that was locked down last quarter might not be locked down today. Nothing about the review cadence catches any of it.
- [Cross Cloud Queries with StackQL](https://stackql.io/blog/tutorials/cross-cloud-queries-with-stackql.md): This is a how-to article demonstrating the use of stackql to query across AWS and Google cloud environments and combine data in real-time.
- [Declarative cloud stacks in SQL: an intro to stackql-deploy](https://stackql.io/blog/tutorials/declarative-cloud-stacks-stackql-deploy.md): Tutorial 2 in this series showed the query-before-mutation pattern by hand. Query live state, apply a policy gate, mutate what's out of policy, verify convergence. Every step was a SQL statement typed into a shell. The pattern held, but the shape was low-level. One resource at a time. One session at a time. No structure for repeating it across environments or holding it right over time.
- [Delete Default AWS VPCs with StackQL](https://stackql.io/blog/tutorials/delete-default-aws-vpcs-with-stackql.md): Use StackQL to delete default AWS VPCs across all regions to improve your cloud security posture.
- [Deploying and Querying GCS Buckets using StackQL](https://stackql.io/blog/tutorials/deploying-and-querying-gcs-buckets-using-stackql.md): StackQL is a simple way to automate the deployment, configuration, management, and removal of Google Cloud Storage buckets, as well as to query buckets.
- [Enable Logging for Google Cloud Storage Buckets and Analyzing Logs in Big Query (Part I)](https://stackql.io/blog/tutorials/enable-google-cloud-storage-logging.md): This post demonstrates how to enable logging for a Google Cloud Storage bucket and analyze usage logs in Big Query using StackQL - a new, SQL based approach to deploying and querying cloud resources.
- [Exploring GCP Roles with StackQL](https://stackql.io/blog/tutorials/exploring-gcp-roles-with-stackql.md): This article provides a primer on roles in GCP with demonstrations of creating and querying roles using StackQL.
- [Exploring GCP services and resources using StackQL](https://stackql.io/blog/tutorials/exploring-gcp-services-and-resources-using-stackql.md): This article will walk through examples of exploring services and resources in GCP using StackQL - a SQL based language for working with cloud and SaaS assets.
- [Exploring the Google Cloud Asset API](https://stackql.io/blog/tutorials/exploring-the-google-cloud-asset-api.md): This article shows how to use the Google Cloud Asset Inventory service using SQL.
- [5 Minute Dashboards with StackQL](https://stackql.io/blog/tutorials/five-minute-dashboards-with-stackql.md): Five minute dashboards with StackQL and Superset, check it out!
- [Using StackQL to find changed files in a commmit using GitHub Actions](https://stackql.io/blog/tutorials/getting-files-changed-in-a-github-commit.md): This article demonstrates how to use stackql with github actions to get details about changed files in a commit.
- [GKE Autopilot - the easy way](https://stackql.io/blog/tutorials/gke-autopilot-the-easy-way.md): This article shows how to use StackQL to deploy a GKE Autopilot cluster in a Shared VPC in GCP.
- [Google Firewall Analysis using StackQL](https://stackql.io/blog/tutorials/google-firewall-analysis-using-stackql.md): Deploy, configure and query GCP resources using SQL.
- [One manifest, two clouds: multi-cloud infrastructure with stackql-deploy](https://stackql.io/blog/tutorials/multi-cloud-stackql-deploy.md): Tutorial 3 introduced stackql-deploy against a single Google Cloud project. One manifest, one provider, one VPC. The framework proved its shape: declarative resources described as SQL-anchored files, an exists-create-statecheck-exports loop that runs idempotently against live cloud APIs, no state file to maintain.
- [Preventing Public Access for GCS Buckets](https://stackql.io/blog/tutorials/preventing-public-access-for-gcs-buckets.md): This article shows how to enable public access prevention on Google Cloud Storage (GCS) buckets using StackQL - a SQL based approach to deploying and querying cloud assets.
- [Query and Create GitHub Releases using StackQL](https://stackql.io/blog/tutorials/query-and-create-github-releases-using-stackql.md): StackQL and the StackQL GitHub provider can be used to query objects in GitHub, including releases, tags, forks, commits, and much more.  This article shows how you can automate releases using StackQL.
- [Query and Manage Google Workspace Users and Groups with StackQL](https://stackql.io/blog/tutorials/query-and-manage-google-workspace-users-and-groups-with-stackql.md): Announcing the release of the StackQL provider for the Google Workspace Admin API.
- [Query before you mutate: how agents should touch your infrastructure](https://stackql.io/blog/tutorials/query-before-you-mutate-agents-infrastructure.md): The problem with plan, review, apply
- [Query Resources Across AWS Regions Asynchronously](https://stackql.io/blog/tutorials/query-resources-across-aws-regions-asynchronously.md): stackql is a dev tool that allows you to query and manage cloud and SaaS resources using SQL, which developers and analysts can use for CSPM, assurance, user access management reporting, IaC, XOps and more.
- [Querying Big Query Errors and Load Stats](https://stackql.io/blog/tutorials/querying-bigquery-errors-and-load-stats.md): This article demonstrates some queries you can run using StackQL to bring back live statistics from Big Query as well as detail regarding encountered during the loading of data into Big Query.
- [(Quickly) Identify Old Node Runtimes in AWS Lambda](https://stackql.io/blog/tutorials/quickly-identify-old-node-runtimes-in-aws-lambda.md): Query and interact with AWS resources using SQL.
- [StackQL Superset Dashboards Quickstart](https://stackql.io/blog/tutorials/stackql-dashboards-with-superset.md): This quick start guide lays out how to create a StackQL dashboard using Apache Superset.
- [StackQL GitHub Actions Tutorial](https://stackql.io/blog/tutorials/stackql-github-actions.md): This is a demonstration of how to use stackql with github actions.
- [Run StackQL Queries from the Databricks Web Terminal](https://stackql.io/blog/tutorials/stackql-in-databricks-web-terminal.md): Run StackQL SQL queries against your Databricks workspace directly from the Databricks web terminal.
- [The 5 Minute Global AWS Inventory](https://stackql.io/blog/tutorials/the-5-minute-global-aws-inventory.md): Inventory all resources across all regions in an AWS account.
- [Use StackQL in Codespaces](https://stackql.io/blog/tutorials/use-stackql-in-codespaces.md): GitHub Codespaces is a development environment completely hosted online, enabling seamless development without setting up local machines.  One of the great features of Codespaces is its compatibility with IPython, providing an interactive computing environment to test and prototype StackQL queries.
- [Identify Outdated TLS Versions in Azure with StackQL](https://stackql.io/blog/tutorials/use-stackql-to-identify-old-tls-versions-for-azure-services.md): Use StackQL to identify Azure resources with outdated TLS versions and ensure compliance with security best practices.
- [Using StackQL in Native Cloud Shells in AWS, Azure and GCP](https://stackql.io/blog/tutorials/using-stackql-in-native-cloud-shells-in-aws-azure-and-gcp.md): Run StackQL direct in AWS, Azure and GCP Cloud Shells.
- [Using the Jsonnet Map Function](https://stackql.io/blog/tutorials/using-the-jsonnet-map-function.md): This article demonstrates the use of the map and format functions in the Jsonnet standard library.

## Optional

- [Full text of every page](https://stackql.io/llms-full.txt): one file with the content of every page listed above