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

2.5 KiB

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

Usage

influxdb3 show databases [OPTIONS]

Options

Option Description
-H --host Host URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181)
--token ({{< req >}}) Authentication token
--show-deleted Include databases marked as deleted in the output
--format Output format (pretty (default), json, jsonl, csv, or parquet)
--tls-ca Path to a custom TLS certificate authority (for testing or self-signed certificates)
-h --help Print help information
--help-all Print detailed help information

Option environment variables

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

Environment Variable Option
INFLUXDB3_HOST_URL --host
INFLUXDB3_DATABASE_NAME --database
INFLUXDB3_AUTH_TOKEN --token

Examples

List all databases

influxdb3 show databases

List all databases, including deleted databases

influxdb3 show databases --show-deleted

List databases in JSON-formatted output

influxdb3 show databases --format json

List databases in Parquet-formatted output

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

influxdb3 show databases 
  --format parquet \
  --output /Users/me/databases.parquet