Skip to content

devops-ia/steampipe

steampipe

CI GitHub release Docker Hub Docker Pulls License: MIT Context7

Community Docker image for Steampipe — use SQL to instantly query cloud services (AWS, Azure, GCP and more).

Why this image? Turbot stopped publishing official Docker images after Steampipe v0.22.0. This project provides multi-arch container images built from official pre-compiled binaries.

Quick start

# Run Steampipe as a service (PostgreSQL endpoint on port 9193)
docker run -d --name steampipe \
  -p 9193:9193 \
  ghcr.io/devops-ia/steampipe:2.4.1 \
  steampipe service start --foreground --database-listen network

# Install a plugin
docker exec steampipe steampipe plugin install aws

# Connect with any PostgreSQL client
psql -h localhost -p 9193 -U steampipe -d steampipe

Image details

Property Value
Base image debian:bookworm-slim
Architectures linux/amd64, linux/arm64
User steampipe (UID 9193, GID 0)
Port 9193 (PostgreSQL)
Default CMD steampipe service start --foreground

Registries

# GitHub Container Registry
docker pull ghcr.io/devops-ia/steampipe:2.4.1

# Docker Hub
docker pull devopsiaci/steampipe:2.4.1

Documentation

Topic Description
Getting Started Docker, Docker Compose, plugin install, first query
Configuration Environment variables, .spc plugin configs, memory tuning
Plugins Install, configure, and manage plugins (AWS, Azure, GCP, Kubernetes, GitHub, Terraform…)
Integrations Grafana, Superset, Metabase, dbt, Python, Node.js, Go
Kubernetes Helm chart, OpenShift, Secrets, health checks
Examples AWS queries, multi-cloud, Python/Node/Go clients, security audits
Troubleshooting Connection errors, permissions, OOM, debug mode

Versioning

Image versions track upstream Steampipe releases 1:1. New versions are detected automatically via updatecli and published after merge.

Common use cases

# Security: find AWS IAM users without MFA
docker exec steampipe steampipe query "
  SELECT user_name, create_date FROM aws_iam_user
  WHERE password_enabled = true AND mfa_enabled = false"

# Cost: list unattached EBS volumes
docker exec steampipe steampipe query "
  SELECT volume_id, size, volume_type, region FROM aws_ebs_volume
  WHERE state = 'available'"

# Compliance: find Azure storage accounts without HTTPS
docker exec steampipe steampipe query "
  SELECT name, resource_group, location FROM azure_storage_account
  WHERE enable_https_traffic_only = false"

# Operations: list Kubernetes pods not running
docker exec steampipe steampipe query "
  SELECT name, namespace, phase FROM kubernetes_pod
  WHERE phase NOT IN ('Running','Succeeded')"

# Inventory: count EC2 instances by region
docker exec steampipe steampipe query "
  SELECT region, count(*) FROM aws_ec2_instance GROUP BY region ORDER BY count DESC"

Contributing

See CONTRIBUTING.md.

License

MIT — see LICENSE.

About

Docker image for Steampipe - Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.

Topics

Resources

License

Code of conduct

Contributing

Security policy

Stars

Watchers

Forks

Packages

 
 
 

Contributors