chcli

A Terminal Client for ClickHouse with AutoCompletion and Syntax Highlighting.

This project is inspired by mycli.

Features

chcli is written using prompt_toolkit and antlr4 with grammar.

• Auto-completion as you type for SQL keywords as well as tables, views and columns in the database.
• Syntax highlighting using Pygments.
• Pretty prints tabular data.

Install

You can install just by pip.

> pip install chcli

Usage

> chcli --help
Usage: chcli [OPTIONS]

  A Terminal Client for ClickHouse with AutoCompletion and Syntax
  Highlighting.

Options:
  -v, --version       Show the version and exit.
  -h, --host TEXT     ClickHouse server host.  [default: 127.0.0.1]
  -p, --port INTEGER  ClickHouse server port.  [default: 9000]
  -u, --user TEXT     ClickHouse server user.  [default: default]
  --password TEXT     ClickHouse server password.  [default: ]
  --help              Show this message and exit.

License

This project is licensed under the Apache-2.0 License.