ContextQMD
Back to Influxdb

Databases

content/shared/influxdb3-cli/show/databases.md

latest2.6 KB
Original Source

The influxdb3 show databases command lists databases in your {{< product-name >}} server.

Usage

<!--pytest.mark.skip-->
bash
influxdb3 show databases [OPTIONS]

Options

OptionDescription
-H--hostHost URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181)
--token({{< req >}}) Authentication token
--show-deletedInclude databases marked as deleted in the output
--formatOutput format (pretty (default), json, jsonl, csv, or parquet)
--tls-caPath to a custom TLS certificate authority (for testing or self-signed certificates)
--tls-no-verifyDisable TLS certificate verification (Not recommended in production, useful for self-signed certificates)
-h--helpPrint help information
--help-allPrint detailed help information

Option environment variables

You can use the following environment variables to set command options:

Environment VariableOption
INFLUXDB3_HOST_URL--host
INFLUXDB3_DATABASE_NAME--database
INFLUXDB3_AUTH_TOKEN--token
INFLUXDB3_TLS_NO_VERIFY--tls-no-verify

Examples

List all databases

<!--pytest.mark.skip-->
bash
influxdb3 show databases

List all databases, including deleted databases

<!--pytest.mark.skip-->
bash
influxdb3 show databases --show-deleted

List databases in JSON-formatted output

<!--pytest.mark.skip-->
bash
influxdb3 show databases --format json

List databases in Parquet format output

Parquet is a binary format. Use the --output option to specify the file where you want to save the Parquet data.

<!--pytest.mark.skip-->
bash
influxdb3 show databases 
  --format parquet \
  --output /Users/me/databases.parquet