AgentIndex icon
AgentIndex
ToolsMCP ServersHOTCategoriesTrendingNewBest ListsCompareGuides
Submit Tool
ToolsMCP ServersHOTCategoriesTrendingNewBest ListsCompareGuides
Home/
MCP Servers/
stackql
stackql logo

stackql

Active·★ 1.1k·MIT·Updated 2026-10-27

StackQL is an open-source, Go-based execution engine that lets developers and infrastructure agents query, provision, and manage cloud and SaaS resources using SQL semantics. By transpiling SQL statements (`SELECT`, `INSERT`, `UPDATE`, `DELETE`, `EXEC`) into native provider REST API calls via OpenAPI-derived schemas from the StackQL Provider Registry, it unifies multi-cloud asset inventory, Cloud Security Posture Management (CSPM), and IaC operations under a single query language. StackQL runs as an interactive shell, a CLI batch runner (`stackql exec`), or a PostgreSQL wire-protocol server (`stackql srv`) that connects directly to Python (`psycopg2`), BI tools, or AI agent workflows.

This write-up is based on the project's README and public repository data. We have not hand-tested the tool. Data as of 2026-10-26.

License
MIT
Latest release
v0.12.824 · 2026-10-22
Last commit
2026-10-26
Contributors
32
Forks
90
Open issues and PRs
110
First published
2022-01-03

Source: GitHub, npm and PyPI public APIs.

#asset-management#cloud#cloud-automation#cloud-config#cloud-operations#cloud-security#cspm#devops
$ Install
$ brew install stackql/tap/stackql
↗ Visit site★ GitHub
01

Features

01SQL interface for querying cloud resources across AWS, GCP, Azure, and 50+ providers
02Infrastructure provisioning and lifecycle management via SQL DML
03Cloud security posture management (CSPM) and asset inventory
04Extensible provider registry for adding new cloud and SaaS APIs
05Interactive shell and CI/CD pipeline integration support
02

Why choose it

+Unifies multi-cloud APIs (AWS, GCP, Azure, GitHub, Okta, etc.) behind standard SQL queries and DML statements.
+Supports both CLI/shell execution and a PostgreSQL wire-protocol server mode (`srv`) for easy programmatic integration.
+Distributed across Homebrew, Docker, Chocolatey, PyPI (`stackql-deploy`), and GitHub Actions.
03

Trade-offs

!Query performance is bound by upstream cloud provider API latency and rate limits rather than local database speeds.
!Adding unsupported custom APIs requires writing OpenAPI provider definitions for the StackQL registry.
04

Maintenance check

ActiveChecked: 2026-10-24
Last commit
2026-10-24
Commits, last 90 days
100+
Releases, last 90 days
9
Latest release
v0.12.824 (2026-10-22)
Open issues
110
Recent issues with at least one comment
3/16
Commits per week, last 12 weeks
Commits per week, last 12 weeks: 5, 5, 8, 0, 1, 17, 4, 14, 5, 9, 8, 21

Oldest week on the left; the latest four weeks are orange. Source: GitHub commit activity.

Status rule: archived on GitHub = Archived; last commit within 90 days = Active; 91 to 365 days = Slowing; older = Stale. All figures come from the GitHub API on the date shown.

Most discussed open issues

  • #224 [FEATURE] Use `goreleaser` for build workflows14 comments · 2023-10-03
  • #290 Add unit testing for package `acid_dto`8 comments · 2023-10-03
  • #390 [BUG] Can't access item in array data type5 comments · 2024-04-08
  • #293 Add unit testing for package `transact`5 comments · 2023-10-03
  • #163 [FEATURE] Syntax highlighting/color for `shell`5 comments · 2023-03-03

Issue titles are quoted from GitHub. Open the link to check whether a problem still applies to the version you use.

05

Compatibility

AWS
Provider
Verified via docs
GCP
Provider
Verified via docs
Azure
Provider
Verified via docs
macOS / Linux / Windows
All platforms
Verified via docs
06

Quick start

1
$ brew install stackql/tap/stackql
07

Use cases

↳Query and audit cloud resources across multiple providers using SQL for security and compliance
↳Automate cloud infrastructure provisioning and configuration with SQL-based scripts
↳Build cloud asset inventory and CSPM dashboards using familiar SQL queries
08

Alternatives

⚡Top VS:
VSgitlab-mcp★2.1k→VSagent-device★5.2k→VSmcp-remote★1.7k→VSflow-mcp★349→
gitlab-mcp logo
gitlab-mcp★ 2.1k
MCP server for GitLab: 100+ tools for projects, MRs, issues, pipelines, wikis and more via the GitLab REST/GraphQL API
VSCompare→
agent-device logo
agent-device★ 5.2k
Mobile app automation and verification for AI coding agents. CLI, MCP server, and typed Node.js API for iOS, Android, HarmonyOS, TV, web, macOS, and Linux.
VSCompare→
mcp-remote logo
mcp-remote★ 1.7k
Connect an MCP Client that only supports local (stdio) servers to a Remote MCP Server.
VSCompare→
flow-mcp logo
flow-mcp★ 349
Drive Google Flow from Claude, Codex or a local control panel, on Mac or Windows — using your Google AI subscription credits instead of the pay-per-use video API. No browser extension.
VSCompare→
Godot-MCP logo
Godot-MCP★ 311
Godot-MCP — Model Context Protocol (MCP) integration for the Godot Engine. AI tools for the Godot Editor in C#, with cloud connection to ai-game.dev. Apache-2.0.
VSCompare→
geo-mcp-servers logo
geo-mcp-servers★ 244
A curated, tracked list of Model Context Protocol (MCP) servers for geospatial, GIS, mapping, and earth-observation work — geocoding, routing, PostGIS, STAC/imagery, QGIS/ArcGIS, weather, and the commercial location platforms.
VSCompare→
official-mcp-servers logo
official-mcp-servers★ 397
A curated directory of 390+ official MCP servers from the companies behind the products. No unofficial forks, no abandoned projects.
VSCompare→
mcp-maigret logo
mcp-maigret★ 268
MCP server that lets AI agents run maigret, an OSINT tool that searches a username across thousands of sites
VSCompare→
See all alternatives →

Comments

Log in to leave a comment

No comments yet. Be the first!

On this page
01Features02Why choose it03Trade-offs04Maintenance check05Compatibility06Quick start07Use cases08Alternatives
stackql /
stackql
↗

SQL-based framework to query, provision, and audit cloud and SaaS resources across 50+ providers

1.1k90MIT
Last commit1d ago
StatusActive
CategoryMCP Servers
Contributors32
Latest releasev0.12.824
Links
Documentation↗Discussion↗Issues↗Releases↗
Cloud Infrastructure
Ad

Deploy on DigitalOcean

Host your MCP servers, Docker containers, and AI agents with $200 free credit over 60 days.

Claim $200 Free Credit
© 2026 AgentIndex.app|Built by a 10-year iOS Developer.
Best by use caseAboutContactAdvertisePrivacy PolicyTerms of UseQYSGitHubBuy me a coffee ☕

Browse by Category

MCP ServersCode AssistantWorkflow AutomationRAG / Knowledge BaseMulti-AgentBrowser AutomationLLM InfraDev ToolingObservability

Not affiliated with Anthropic, OpenAI or Microsoft.