ClickHouse
Connect to a ClickHouse analytics database. ClickHouse support is currently partial.
Usage
sql-studio clickhouse [URL] [USER] [PASSWORD] [DATABASE]Arguments
| Argument | Description | Default | Env Var |
|---|---|---|---|
URL | ClickHouse server address | http://localhost:8123 | URL |
USER | Username | default | USER |
PASSWORD | Password | (empty) | PASSWORD |
DATABASE | Database name | default | DATABASE |
Notes
- All arguments have sensible defaults, so you can connect to a local ClickHouse instance with just
sql-studio clickhouse. - SQL Studio uses
rustlsfor TLS connections.
Examples
# Connect to a local ClickHouse with defaults
sql-studio clickhouse
# Connect to a remote ClickHouse
sql-studio clickhouse https://ch.example.com:8443 admin secret mydb
# Using environment variables
export URL="https://ch.example.com:8443"
export USER="admin"
export PASSWORD="secret"
export DATABASE="mydb"
sql-studio clickhouse