canonic connection

canonic connection manages the entries under connections: in canonic.yaml, the same file canonic setup writes to during onboarding.

`connection list`

List configured connections.

canonic connection list

Shows each connection’s id, type, whether it’s the project default, and its params. With --json, returns {"connections": [...]} including full param dicts.

`connection test`

Test connectivity for one or all connections.

canonic connection test
canonic connection test --connection warehouse

Flag	Description
`--connection`, `-c`	Connection id to test (default: all).

Exits non-zero if any tested connection fails to connect.

`connection add`

Add a new source connection to canonic.yaml.

canonic connection add --id warehouse --type postgres \
  --param host=localhost --param database=analytics \
  --credentials-ref env:WAREHOUSE_PASSWORD --set-default

Flag	Description
`--id`	Unique connection identifier.
`--type`	Connector type (`sqlite`, `postgres`, `mysql`, `clickhouse`, `redshift`, `snowflake`, `databricks`, …).
`--param`, `-p`	Connector param as `KEY=VALUE` (repeatable).
`--credentials-ref`	Credential reference (`env:VAR`, `keyring:service`, `file:path`).
`--set-default`	Make this the project default connection.

A Snowflake connection with key-pair auth needs no --credentials-ref unless the private key is encrypted, in which case the reference points at its passphrase:

canonic connection add --id warehouse --type snowflake \
  --param account=xy12345.eu-central-1 --param user=CANONIC \
  --param warehouse=COMPUTE_WH --param database=ANALYTICS \
  --param private_key_path=~/.snowflake/rsa_key.p8 --set-default

read_only_role and list-valued params such as schemas are not flags. Add them by editing canonic.yaml, see the config reference.

`connection remove`

Remove a configured connection from canonic.yaml.

canonic connection remove warehouse

Takes the connection id as a positional argument. If it was the project default, the default is cleared.

Getting Started

Concepts

CLI Reference

MCP / Agent Integration

Guides

Reference

canonic connection

`connection list`

`connection test`

`connection add`

`connection remove`

​connection list

​connection test

​connection add

​connection remove

`connection list`

`connection test`

`connection add`

`connection remove`