# 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

```sh
sudo av install brew:stackql
```

Additional install commands:

### macOS

- Homebrew (100%):

```sh
brew install stackql
```

  Evidence: local Homebrew formula metadata

### Linux

- Nix (92%):

```sh
nix profile install nixpkgs#stackql
```

  Evidence: nixpkgs package indexes: pkgs/by-name/st/stackql/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

## Package facts

- **Package key:** brew:stackql
- **Package manager:** Homebrew
- **Package manager page:** <https://formulae.brew.sh/formula/stackql>
- **Version:** 0.10.582
- **Source summary:** SQL interface for arbitrary resources with full CRUD support
- **Homepage:** <https://stackql.io/>
- **Repository:** <https://github.com/stackql/stackql>
- **Upstream docs:** <https://stackql.io/>
- **License:** MIT
- **Source archive:** <https://github.com/stackql/stackql/archive/refs/tags/v0.10.582.tar.gz>
- **Last updated:** 2026-07-31T09:52:03Z
- **Generated:** 2026-08-04T22:13:35+00:00

## Executables

- stackql (cli)
- stackql (alias)

## Build dependencies

- go

## Install behavior

- Post-install hook: not defined
- Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux

## Freshness

- Page generated: 2026-08-04
- Package-manager version: 0.10.582
- Package-manager updated: 2026-07-31
- Local data: ok
- Upstream repository: https://github.com/stackql/stackql
- Upstream latest detected: v0.10.582 (current)
## 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

- <https://raw.githubusercontent.com/stackql/stackql/main/README.md>
- <https://stackql.io/docs>
- <https://stackql.io/docs/getting-started/using-stackql>
- <https://stackql.io/docs/installing-stackql>


## Security Notes

No matching local secret-handling manifest was found for stackql. Package metadata is still published here so future coverage has a stable package URL.



## 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

- Unix: ./.stackqlrc, path passed with --configfile
## Source Database Details

- **Source Database:** Homebrew formula API
- **Tap:** homebrew/core
- **Full Name:** stackql
- **Version Scheme:** 0
- **Revision:** 0
- **Head Version:** HEAD
- **Bottle Stable Root URL:** <https://ghcr.io/v2/homebrew/core>
- **Deprecated:** no
- **Disabled:** no
- **Keg Only:** no
- **URL Keys:** head, stable

## Other Package-Manager Records

- Nix - stackql: normalized package name match | nixpkgs package indexes: pkgs/by-name/st/stackql/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1


## Related links

- [Cloud CLI packages](https://pkg.so/cloud-clis/) - Belongs to a cloud or infrastructure command family.
- [Terminal utility packages](https://pkg.so/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Networking and protocol packages](https://pkg.so/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata.
- [Database and data packages](https://pkg.so/database-data-tools/) - Matched database, SQL, migration, or data-store metadata.
- [go](https://pkg.so/brew/go/) - Build dependency declared by Homebrew.
- [awscli](https://pkg.so/brew/awscli/) - Shares pkgdb curated category or tags: automation, cli, cloud, cloud-infrastructure.
- [ansible](https://pkg.so/brew/ansible/) - Shares pkgdb curated category or tags: automation, cli, cloud, cloud-infrastructure.
- [pulumi](https://pkg.so/brew/pulumi/) - Shares pkgdb curated category or tags: automation, cli, cloud, cloud-infrastructure.
- [awscli@1](https://pkg.so/brew/awscli-1/) - Shares pkgdb curated category or tags: automation, cli, cloud, cloud-infrastructure.
- [gcx](https://pkg.so/brew/gcx/) - Shares pkgdb curated category or tags: automation, cli, cloud, cloud-infrastructure.
- [azure-cli](https://pkg.so/brew/azure-cli/) - Shares pkgdb curated category or tags: cli, cloud, cloud-infrastructure.
- [flyctl](https://pkg.so/brew/flyctl/) - Shares pkgdb curated category or tags: cli, cloud, cloud-infrastructure.
- [firebase-cli](https://pkg.so/brew/firebase-cli/) - Shares pkgdb curated category or tags: cli, cloud, cloud-infrastructure.

## Combined YAML source

View the package source record on GitHub. [combined/stackql.yml](https://github.com/mxcl/pkgdb/blob/main/combined/stackql.yml)


## Sources

- pkg.so package database
- Geiger risk classifier
- package-page enrichment
- curated configuration and credential file locations
- curated package history
- package version freshness
- pkgdb category and tag curation
- package relationship graph
- external package-manager database matches
- cross-ecosystem install command graph
