docs-v2/content/shared/influxdb3-cli/query.md

The influxdb3 query command executes a query against a running {{< product-name >}} server.

Usage

influxdb3 query [OPTIONS] --database <DATABASE_NAME> [QUERY]...

Aliases

query, q

Arguments

• QUERY: The query to execute. Provide the query in one of the following ways:

  • a string
  • a path to a file that contains the query using the --file option
  • from stdin

Options

Option		Description
-H	--host	Host URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181)
-d	--database	({{< req >}}) Name of the database to operate on
	--token	({{< req >}}) Authentication token
-l	--language	Query language of the query string (sql (default) or influxql)
	--format	Output format (pretty (default), json, jsonl, csv, parquet)
-o	--output	Output query results to the specified file
-f	--file	A file that contains the query to execute
	--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

• Query data using SQL
• Query data using InfluxQL
• Query data and return JSON-formatted results
• Query data and write results to a file

In the examples below, replace {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}}: with the name of the database to query.

{{% code-placeholders "DATABASE_NAME" %}}

Query data using SQL

{{< code-tabs-wrapper >}} {{% code-tabs %}} string file stdin {{% /code-tabs %}} {{% code-tab-content %}}

influxdb3 query \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  'SELECT * FROM home'

{{% /code-tab-content %}} {{% code-tab-content %}}

influxdb3 query \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  --file ./query.sql

{{% /code-tab-content %}} {{% code-tab-content %}}

cat ./query.sql | influxdb3 query \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

Query data using InfluxQL

{{< code-tabs-wrapper >}} {{% code-tabs %}} string file stdin {{% /code-tabs %}} {{% code-tab-content %}}

influxdb3 query \
  --language influxql \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  'SELECT * FROM home'

{{% /code-tab-content %}} {{% code-tab-content %}}

influxdb3 query \
  --language influxql \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  --file ./query.influxql

{{% /code-tab-content %}} {{% code-tab-content %}}

cat ./query.influxql | influxdb3 query \
  --language influxql \
  --database DATABASE_NAME \
  --token AUTH_TOKEN

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

Query data and return JSON-formatted results

{{< code-tabs-wrapper >}} {{% code-tabs %}} string file stdin {{% /code-tabs %}} {{% code-tab-content %}}

influxdb3 query \
  --format json \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  'SELECT * FROM home'

{{% /code-tab-content %}} {{% code-tab-content %}}

influxdb3 query \
  --format json \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  --file ./query.sql

{{% /code-tab-content %}} {{% code-tab-content %}}

cat ./query.sql | influxdb3 query \
  --format json \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

Query data and write results to a file

{{< code-tabs-wrapper >}} {{% code-tabs %}} string file stdin {{% /code-tabs %}} {{% code-tab-content %}}

influxdb3 query \
  --output /path/to/results.txt \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  'SELECT * FROM home'

{{% /code-tab-content %}} {{% code-tab-content %}}

influxdb3 query \
  --output /path/to/results.txt \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  --file ./query.sql

{{% /code-tab-content %}} {{% code-tab-content %}}

cat ./query.sql | influxdb3 query \
  --output /path/to/results.txt \
  --database DATABASE_NAME \
  --token AUTH_TOKEN

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

{{% /code-placeholders %}}