Steampipe

steampipe

Use SQL to instantly query your cloud services

Runs as steampipe|macOS, Linux, Windows|steampipe.io

Open form in Otty otty.toml

Command form

ai-draft · 2 tasks · 6 fields

Run SQL against cloud services with steampipe query: one query string or SQL files, with output format, timeout and search path. Snapshots, Turbot Pipes and the other subcommands are left out.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui steampipe

`steampipe query`

Run a query

Leave the query empty to open the interactive shell.

Run a queryExample values, fixed in this page — nothing here reaches a terminal

TasksEach one presets the form for one job

Interactive shell

Query as JSON

queryoutput

ParametersOnly these flags are editable in the form

SQL query or file

A SQL string, or one or more .sql files.
string · positional 0 · repeatable

Output format

enum

--outputtablejsoncsvlinesnapshot

Query timing

enum

--timingoffonverbose

Timeout (seconds)

integer

--query-timeout

Search path

Comma-separated connection names.
string

--search-path

CSV separator

string

--separator

SourcesEvery flag above is checked against these

docs

Execute SQL queries interactively, or by a query argument. To open the interactive query shell, run steampipe query with no arguments. `--header string` Specify whether to include column headers in csv and table output (default `true`). `--output string` Select the console output format. Possible values are `line, csv, json, table, snapshot` (default `tabl…

manual2026-10-27

steampipe.io

Before it fills your prompt, Otty checks the installed steampipe against its version. A form that does not match your version is not offered.