---
title: influxdb3 query
description: The influxdb3 query command executes a query against a running InfluxDB 3 server.
url: https://docs.influxdata.com/influxdb3/core/reference/cli/influxdb3/query/
estimated_tokens: 4140
product: InfluxDB 3 Core
version: core
---

# influxdb3 query

The `influxdb3 query` command executes a query against a running InfluxDB 3 Core 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 Core 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

<!-- Tabbed content: Select one of the following options -->

**string:**

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

**file:**

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

**stdin:**

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

<!-- End tabbed content -->

### Query data using InfluxQL

<!-- Tabbed content: Select one of the following options -->

**string:**

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

**file:**

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

**stdin:**

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

<!-- End tabbed content -->

### Query data and return JSON-formatted results

<!-- Tabbed content: Select one of the following options -->

**string:**

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

**file:**

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

**stdin:**

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

<!-- End tabbed content -->

### Query data and write results to a file

<!-- Tabbed content: Select one of the following options -->

**string:**

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

**file:**

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

**stdin:**

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

<!-- End tabbed content -->