--- title: influx query description: The influx query command executes a literal Flux query provided as a string or a literal Flux query contained in a file. url: https://docs.influxdata.com/influxdb/v2/reference/cli/influx/query/ estimated_tokens: 1726 product: InfluxDB OSS v2 version: v2 publisher: InfluxData canonical: https://docs.influxdata.com/influxdb/v2/reference/cli/influx/query/ date: '2025-04-02T15:54:32-06:00' lastmod: '2025-04-02T15:54:32-06:00' --- * influx CLI 2.0.0+ * InfluxDB 2.0.0+ * Updated in CLI v2.0.5 This page documents an earlier version of InfluxDB OSS.[InfluxDB 3 Core](/influxdb3/core/) is the latest stable version. #### API token hashing is enabled by default in InfluxDB OSS 2.9.0 Stronger token security: tokens are stored as hashes on disk, so a copy of the database file doesn’t expose usable tokens. Existing tokens are hashed on first startup and the original strings can’t be recovered afterward — **capture any plaintext tokens you still need before you upgrade**. For more information, see [Token hashing](/influxdb/v2/admin/tokens/#token-hashing). The `influx query` command executes a literal Flux query provided as a string or a literal Flux query contained in a file. ## Usage ``` influx query [query literal] [flags] ``` #### Remove unnecessary columns in large datasets When using the `influx query` command to query and download large datasets, drop columns such as `_start` and `_stop` to optimize the download file size. ```js // ... |> drop(columns: ["_start", "_stop"]) ``` ## Flags |Flag| | Description |Input type|Maps to [?](/influxdb/v2/reference/cli/influx/#view-mapped-environment-variables)| |----|-----------------|---------------------------------------------------------------------|----------|---------------------------------------------------------------------------------| |`-c`|`--active-config`| CLI configuration to use for command | string | | | |`--configs-path` |Path to `influx` CLI configurations (default `~/.influxdbv2/configs`)| string | `INFLUX_CONFIGS_PATH` | |`-f`| `--file` | Path to Flux script file | string | | |`-h`| `--help` | Help for the `query` command | | | | | `--host` | HTTP address of InfluxDB (default `http://localhost:8086`) | string | `INFLUX_HOST` | | | `--http-debug` | Inspect communication with InfluxDB servers. | string | | |`-o`| `--org` | Organization name (mutually exclusive with `--org-id`) | string | `INFLUX_ORG` | | | `--org-id` | Organization ID (mutually exclusive with `--org`) | string | `INFLUX_ORG_ID` | |`-p`| `--profilers` | Flux query profilers to enable (comma-separated) | string | | |`-r`| `--raw` | Output raw query results (annotated CSV) | | | | | `--skip-verify` | Skip TLS certificate verification | | `INFLUX_SKIP_VERIFY` | |`-t`| `--token` | API token | string | `INFLUX_TOKEN` | ## Examples #### Authentication credentials The examples below assume your InfluxDB **host**, **organization**, and **token** are provided by either the [active `influx` CLI configuration](/influxdb/v2/reference/cli/influx/#provide-required-authentication-credentials) or by environment variables (`INFLUX_HOST`, `INFLUX_ORG`, and `INFLUX_TOKEN`). If you do not have a CLI configuration set up or the environment variables set, include these required credentials for each command with the following flags: * `--host`: [InfluxDB host](/influxdb/v2/reference/urls/) * `-o, --org` or `--org-id`: InfluxDB organization name or ID * `-t, --token`: InfluxDB API token * [Query InfluxDB with a Flux string](#query-influxdb-with-a-flux-string) * [Query InfluxDB using a Flux file](#query-influxdb-with-a-flux-file) * [Query InfluxDB and return annotated CSV](#query-influxdb-and-return-annotated-csv) * [Query InfluxDB and append query profile data to results](#query-influxdb-and-append-query-profile-data-to-results) ##### Query InfluxDB with a Flux string ```sh influx query 'from(bucket:"example-bucket") |> range(start:-1m)' ``` ##### Query InfluxDB with a Flux file ```sh influx query --file /path/to/example-query.flux ``` ##### Query InfluxDB and return annotated CSV ```sh influx query 'from(bucket:"example-bucket") |> range(start:-1m)' --raw ``` ##### Query InfluxDB and append query profile data to results *For more information about profilers, see [Flux profilers](/flux/v0/stdlib/profiler/#available-profilers).* ```sh influx query \ --profilers operator,query \ 'from(bucket:"example-bucket") |> range(start:-1m)' ``` #### Related * [Query data in InfluxDB](/influxdb/v2/query-data/) * [Use the influx query command](/influxdb/v2/query-data/execute-queries/influx-query/) * [influx CLI—Provide required authentication credentials](/influxdb/v2/reference/cli/influx/#provide-required-authentication-credentials) * [influx CLI—Flag patterns and conventions](/influxdb/v2/reference/cli/influx/#flag-patterns-and-conventions) [query](/influxdb/v2/tags/query/) | Flag | | Description | Input type | Maps to ? | | --- | --- | --- | --- | --- | | Flag | | Description | Input type | Maps to ? | | -c | --active-config | CLI configuration to use for command | string | | | | --configs-path | Path to influx CLI configurations (default ~/.influxdbv2/configs ) | string | INFLUX_CONFIGS_PATH | | -f | --file | Path to Flux script file | string | | | -h | --help | Help for the query command | | | | | --host | HTTP address of InfluxDB (default http://localhost:8086 ) | string | INFLUX_HOST | | | --http-debug | Inspect communication with InfluxDB servers. | string | | | -o | --org | Organization name (mutually exclusive with --org-id ) | string | INFLUX_ORG | | | --org-id | Organization ID (mutually exclusive with --org ) | string | INFLUX_ORG_ID | | -p | --profilers | Flux query profilers to enable (comma-separated) | string | | | -r | --raw | Output raw query results (annotated CSV) | | | | | --skip-verify | Skip TLS certificate verification | | INFLUX_SKIP_VERIFY | | -t | --token | API token | string | INFLUX_TOKEN |