> ## Documentation Index
> Fetch the complete documentation index at: https://astronomer.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# astro env connection get

<Info>
  This command is only available on Astro.
</Info>

Get a single Airflow connection by its ID or key.

## Usage

```bash wrap theme={null}
astro env connection get <id-or-key>
```

## Options

| Option              | Description                                                                                                              | Possible Values                |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------ | ------------------------------ |
| `<id-or-key>`       | The ID or key of the connection to get.                                                                                  | Any valid connection ID or key |
| `--format`          | The output format. Defaults to `table`.                                                                                  | `table`, `json`, or `yaml`     |
| `--include-secrets` | Surface secret values in the output. Requires an Organization policy that allows it.                                     | None                           |
| `--workspace-id`    | Set the Workspace scope. Mutually exclusive with `--deployment-id`. Defaults to your current Workspace from CLI context. | Any valid Workspace ID         |
| `--deployment-id`   | Set the Deployment scope. Mutually exclusive with `--workspace-id`.                                                      | Any valid Deployment ID        |

## Examples

```bash wrap theme={null}
# Get a Workspace connection by key
astro env connection get db_main --workspace-id <workspace-id>

# Get a connection as JSON
astro env connection get db_main --workspace-id <workspace-id> --format json
```

## Related commands

* [`astro env connection list`](/docs/cli/v1.43/astro-env-connection-list)
* [`astro env connection update`](/docs/cli/v1.43/astro-env-connection-update)