{"repo":"hatarist/clickhouse-cli","free":true,"listed":false,"github":"https://github.com/hatarist/clickhouse-cli","clone":"git clone https://github.com/hatarist/clickhouse-cli.git","description":"A third-party client for the Clickhouse DBMS server.","language":"Python","stars":265,"topics":["clickhouse"],"license":null,"category":"cli-tools","readme_excerpt":"clickhouse-cli An unofficial command-line client for the ClickHouse DBMS. It implements some common and awesome things, such as: - Autocompletion (work in progress) - Syntax highlighting for the queries & data output (Pretty formats) - Multiquery & multiline modes by default - paste anything as much as you want! - Pager support ( less ) for the data output - Custom, PostgreSQL-like commands like \\d+ table name or \\ps . See \\? - User-defined functions But it works over the HTTP port, so there are some limitations for now: - Doesn't fully support sessions. SET options are stored locally and are sent with every request. Install Python 3.7+ is required. $ pip3 install clickhouse-cli Options $ clickhouse-cli --help Usage: clickhouse-cli [OPTIONS] [SQLFILE] A third-party client for the ClickHouse DBMS. Options: -h, --host TEXT Server host (hostname, or URL) -p, --port INTEGER Server HTTP port -u, --user TEXT User -P, --password Password -d, --database TEXT Database -s, --settings TEXT Query string to be appended to every query -c, --cookie TEXT Cookie header to be sent with every query -f, --format TEXT Data format for the interactive mode -F, --format-stdin TEXT Data format for stdin/file queries -m, --multiline Enable multiline shell -k, --insecure Allow insecure server connections when using SSL --stacktrace Print stacktraces received from the server. --version Show the version and exit. --help Show this message and exit. Configuration file /.clickhouse-cli.rc is here for your s","default_branch":null,"files":null,"tree":[],"storefront":"/r/hatarist","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/hatarist/clickhouse-cli/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}