POWERPIPE_DATABASE

Important

As of Powerpipe 1.0.0, POWERPIPE_DATABASE has been deprecated and will be removed in a future version of Powerpipe. See Setting the Database for the new syntax.

Sets the database that Powerpipe will connect to. By default, Powerpipe will use a locally installed Steampipe database.

Usage

Use a Powerpipe cloud remote database:

export PIPES_TOKEN=tpt_c6f5tmpe4mv9appio5rg_3jz0a8fakekeyf8ng72qr646
export POWERPIPE_DATABASE=acme/prod

Use a remote PostgreSQL database via connection string:

export POWERPIPE_DATABASE='postgresql://myusername:mypassword@acme-prod.apse1.db.cloud.turbot.io:9193/aaa000'

Use a MySQL database via connection string:

export POWERPIPE_DATABASE='mysql://root:my_pass@tcp(myhost.com)/mydb'

Use a SQLite database via connection string:

export POWERPIPE_DATABASE='sqlite:./my_sqlite_db.db'

Use a DuckDB database via connection string:

export POWERPIPE_DATABASE='duckdb:./my_ducks.db'