---
title: influxdb3 query
description: The influxdb3 query command executes a query against a running InfluxDB 3 server.
url: https://docs.influxdata.com/influxdb3/enterprise/reference/cli/influxdb3/query/
estimated_tokens: 1463
product: InfluxDB 3 Enterprise
version: enterprise
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/enterprise/reference/cli/influxdb3/query/
date: '2025-01-13T07:21:11-07:00'
lastmod: '2025-01-13T07:21:11-07:00'
---

The `influxdb3 query` command executes a query against a running
InfluxDB 3 Enterprise server.

## Usage

```bash
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 InfluxDB 3 Enterprise server (default is `http://127.0.0.1:8181`)          |
| `-d` |  `--database`   |                               *(Required)* Name of the database to operate on                               |
|      |    `--token`    |                                      *(Required)* 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)             |
|      |`--tls-no-verify`|Disable TLS certificate verification (**Not recommended in production**, useful for 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`    |
|`INFLUXDB3_TLS_NO_VERIFY`|`--tls-no-verify`|

## Examples

* [Query data using SQL](#query-data-using-sql)
* [Query data using InfluxQL](#query-data-using-influxql)
* [Query data and return JSON-formatted results](#query-data-and-return-json-formatted-results)
* [Query data and write results to a file](#query-data-and-write-results-to-a-file)

In the examples below, replace`DATABASE_NAME`:
with the name of the database to query.

### Query data using SQL

#### string ####

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

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

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

### Query data using InfluxQL

#### string ####

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

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

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

### Query data and return JSON-formatted results

#### string ####

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

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

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

### Query data and write results to a file

#### string ####

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

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

```bash
cat ./query.sql | influxdb3 query \
  --output /path/to/results.txt \
  --database DATABASE_NAME \
  --token AUTH_TOKEN
```
| Option |  | Description |
| --- | --- | --- |
| Option |  | Description |
| -H | --host | Host URL of the running InfluxDB 3 Enterprise server (default is  http://127.0.0.1:8181 ) |
| -d | --database | ( Required )  Name of the database to operate on |
|  | --token | ( Required )  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) |
|  | --tls-no-verify | Disable TLS certificate verification ( Not recommended in production , useful for self-signed certificates) |
| -h | --help | Print help information |
|  | --help-all | Print detailed help information |

| Environment Variable | Option |
| --- | --- |
| Environment Variable | Option |
| INFLUXDB3_HOST_URL | --host |
| INFLUXDB3_DATABASE_NAME | --database |
| INFLUXDB3_AUTH_TOKEN | --token |
| INFLUXDB3_TLS_NO_VERIFY | --tls-no-verify |