macOS
Homebrewverified · 100%
brew install stackqllocal Homebrew formula metadata
brew / rank 6911
Install stackql with Homebrew, Nix
SQL interface for arbitrary resources with full CRUD support. Version 0.10.582 via Homebrew; verified 2026-07-31. Also installable with nix: nix profile install nixpkgs#stackql.
install
Additional install commands
Linux
Nixverified · 92%
nix profile install nixpkgs#stackqlnixpkgs package indexes · pkgs/by-name/st/stackql/package.nix · source: api.github.com
overview
Package summary
SQL interface for arbitrary resources with full CRUD support
Project links
Commands and aliases
- stackql
history
Project history and usage
StackQL is an open-source SQL interface for querying, provisioning, and operating cloud, SaaS, API, and MCP resources.
Project history
The official README describes StackQL as a Go application that turns SQL statements into provider API requests using provider definitions generated from OpenAPI extensions. The documentation presents it as a standalone CLI with exec, shell, and server modes rather than as a database.
Adoption history
StackQL's official installation docs emphasize multiple distribution channels: Homebrew and signed macOS installers, Linux binaries, Chocolatey and signed Windows installers, Docker images, GitHub Actions, and MCP bundles. Its newer documentation also positions StackQL as infrastructure context for AI agents and publishes a StackQL MCP server through the Official MCP Registry plus npm, PyPI, Docker, GitHub Actions, and bundle artifacts.
How it is used
Common usage is either interactive or batch-oriented. Users run stackql shell for a REPL, stackql exec for one statement or an input file, or stackql srv for Postgres wire protocol access, then query or change provider resources with SQL-like SELECT, INSERT, and other statements.
Why package nerds care
Package nerds care about StackQL because it makes cloud APIs look like a portable CLI database surface without requiring a local database or state file. Its packaging story is also broad: native installers, Homebrew, Docker, CI actions, and MCP server distributions all carry the same command-line core into different automation environments.
Timeline
- 2025: Official docs documented interactive shell, exec mode, input files, and .stackqlrc initialization behavior.
- 2026: Official docs positioned StackQL as a universal interface for agents and humans, with MCP packaging and registry distribution.
- 2026: Official GitHub releases and docs show continuing 0.9.x development with MCP-focused distribution assets.
Related projects
- The official README links StackQL to the StackQL Provider Registry, any-sdk, Docker images, GitHub Actions, MCP server packaging, OpenAPI provider specifications, and the Postgres wire protocol.
Sources
security posture
No protected-tool coverage found yet
No matching local secret-handling manifest was found for stackql. Nucleus package metadata is still published here so future coverage has a stable package URL.
Install behavior
- No Homebrew bottle metadata was recorded.
Recommended review
Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.
local files
Configuration and credential file locations
These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.
Configuration files
Config paths the tool may read or write during local use.
- Unix
./.stackqlrcpath passed with --configfile
executables
Installed executables
| Command | Kind | Exposure | Note |
|---|---|---|---|
stackql | executable | indexed executable | Discovered from the local executable index. |
freshness
Version and freshness
These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.
page generated2026-08-03
manager version0.10.582
manager updated2026-07-31
local dataunknown
upstreamnot available
latest detectednot detected
- okNo freshness warnings were generated.
install metadata
Package metadata
| Package key | brew:stackql |
|---|---|
| Version | 0.10.582 |
| Package manager | Homebrew |
| Homepage | https://stackql.io/ |
| Repository | https://github.com/stackql/stackql |
| Last updated | 2026-07-31T09:52:03Z |
| Pulse | updated |
| Bottle | not recorded |
| Service | none declared |
source database matches
Other package-manager records
Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.
Nix95%
stackql
nix profile install nixpkgs#stackql- normalized package name match
- Matched by: Stackql
source trail
Generated from repository data
This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.
Combined YAML source
View the package source record on GitHub.
Used sources
- Geiger risk classifier
- cross-ecosystem install command graph
- curated configuration and credential file locations
- curated package history
- external package-manager database matches
- pkg.so package database
- pkgdb category and tag curation