Skip to content

index.md

Latest commit

 

History

History
135 lines (120 loc) · 5.33 KB

index.md

File metadata and controls

135 lines (120 loc) · 5.33 KB
Raw
title SQL for cloud infrastructure, SaaS APIs and AI agents
sidebar_label Welcome to StackQL
hide_title true
hide_last_update true
hide_table_of_contents true
keywords
stackql
infrastructure-as-code
configuration-as-data
cloud inventory
description 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.
image /img/stackql-featured-image.png
slug /

import Tabs from '@theme/Tabs'; import TabItem from '@theme/TabItem'; import DocsHero from '@site/src/components/DocsHero/DocsHero'; import { FaRobot, FaCode, FaSatelliteDish } from 'react-icons/fa';

<DocsHero lightSrc="/img/stackql-logo-bold-light-mode.png" darkSrc="/img/stackql-logo-bold-dark-mode.png" alt="StackQL" title={ <> The Universal Interface
for the Agentic Era </> } byline={ <> Configuration-as-Data. Infrastructure-as-Context. </> } />

Agentic Platform Engineering

A universal surface for agents and humans to author changes side by side, at machine speed. Multiple writers, live state, and policy-bounded execution as first-class concerns - the foundation autonomous systems need to operate safely.

IaC for the Agentic Era

Code is still intent. Reality is data. StackQL gives agents and operators one declarative interface to query live state across providers, assert desired state idempotently, and traverse control and data planes through a single grammar - no state file, no per-cloud SDK.

Autonomous Observability

Treat cloud APIs as your data layer, not your deployment target. Every read is live, every change is an event, and drift becomes a signal an agent can reason about - not an alarm a human has to chase.

<Tabs defaultValue="iql" values={[ { label: 'Query', value: 'iql', }, { label: 'Results', value: 'data', }, ] }> 

SELECT state, COUNT(*) as num_instances 
FROM aws.ec2.instances 
WHERE region = 'us-west-1' 
GROUP BY state;
|---------------------------------|
|      state      | num_instances |
|---------------------------------|
|     running     |     342       |
|---------------------------------|
|     pending     |       4       |
|---------------------------------|
|     stopped     |      38       |
|---------------------------------|

Deploying resources using your cloud provider is as easy as writing an INSERT statement...

INSERT INTO google.compute.disks (project, zone, name, sizeGb) 
SELECT 'stackql-demo', 
'australia-southeast1-a', 
'test10gbdisk', 10;

Using StackQL you can develop your way: declarative or procedural. With an easy grammar to learn and no state file to manage, you can get started quickly and use StackQL interchangeably with other infrastructure as code tools, cloud native or otherwise. StackQL provides a universal interface for AI agents to interact with cloud infrastructure. Uses for StackQL include:

  • AI Agent Integration - Enable agents to provision and query cloud resources
  • Control Plane Communication - Programmatic infrastructure provisioning for agentic workflows
  • Data Plane Observability - Real-time monitoring and analytics for AI-driven operations
  • Cloud infrastructure deployment (using SQL)
  • Cloud asset inventory and reporting (using SQL)
  • Cloud compliance and control attestation (using SQL)
  • Configuration drift detection (using SQL)
  • and more, only limited by your imagination!

Get started

  • Installation - install the StackQL binary on macOS, Linux or Windows, or run it from Docker, a package manager or a cloud shell
  • Getting started - the resource hierarchy, your first queries, using a provider, output modes, variables and templating
  • Available providers - the cloud and SaaS providers you can query and manage, each with its own reference site
  • Command line usage - exec, shell, srv, mcp, registry and the global flags
  • MCP tools - the Model Context Protocol server and tools that give AI agents the same SQL interface
  • Language specification - SELECT, INSERT, UPDATE, DELETE, SHOW, DESCRIBE, functions and data types