db_cli_tools

Description

This is an interactive command line tool for working with databases. It is a wrapper around the clickhouse client, pgcli, mycli, mongosh CLIs. It provides a simple interface for running queries and viewing results.

Installation

git clone https://github.com/feel2code/db_cli_tools.git && cd db_cli_tools && chmod +x install.sh && ./install.sh

Then you will need to prepare URIs for database connections in .env file. There is an example env-template file exists in this repo.

Keyboard shortcuts for clickhouse client

Alt (Option) + Shift + e - open editor with the current query. It is possible to specify the editor to use with the environment variable EDITOR. By default, vim is used.

Alt (Option) + # - comment line.

Ctrl + r - fuzzy history search.

Usage

./db.sh --help

License

This project is licensed under the MIT License - see the LICENSE file for details.