dbcls 1.1.14

dbcls is a versatile client that supports various databases

DbCls

DbCls is a versatile client for multiple databases, enabling the editing and preservation of SQL queries in a file, and executing queries directly from the editor, thereby providing a convenient interface for data representation.

Briefly, this application combines the kaa editor and the visidata data visualization tool.

Installation

pip install dbcls

Run

dbcls -H 127.0.0.1 -u user -p mypasswd -E mysql -d mydb mydb.sql

Using config file rather then process arguments to configure

dbcls -c config.json mydb.sql

Where config file is:

{
    "host": "127.0.0.1",
    "port": "3306",
    "username": "user",
    "password": "mypasswd",
    "dbname": "mydb",
    "engine": "mysql"
}

or from bash file

#! /bin/bash

CONFIG='{
    "host": "127.0.0.1",
    "port": "3306",
    "username": "user",
    "password": "mypasswd",
    "dbname": "mydb",
    "engine": "mysql"
}'

dbcls -c <(echo "$CONFIG") mydb.sql

Hotkeys

• Alt + 1 - Autocompletion suggestion list
• Alt + r - Execute query under cursor or selected text
• Alt + e - Show database list, which has a submenu of .tables content
• Alt + t - Show tables list, which has submenus with functionality to show schema or load some sample data
• Ctrl + q - Quit
• Ctrl + s - Save file

Commands

.tables - Show tables list

.databases - Show databases list

.use - Change database

.schema <table> - Show table schema

Options

-H --host

Host to connect to

-u --user

Username to connect as

-p --password

Password to use when connecting to server

-E --engine

Database engine, options are: mysql, postgresql, clickhouse

-d --database

Database to use

-P --port

Port number to use for connection (optional)

-c --config

Path to a config file to use

Bugs

See github issues: https://github.com/Sets88/dbcls/issues