TisQ - terminal UI for SQL databases

TisQ [tɪz-kjuː] stands for Terminal Interface for SQL Queries.

Features:

• Browse servers, databases, schemas and tables in tree view.
• Write and execute SQL queries.
• View query execution results in table.
• Switch between multiple query tabs with different connections.
• Customizable keybindings by config TOML file.
• Save query editors content on exit and restore on start.

Status

In active development. Not ready for production use, there are no tests, incomplete error handling, program can crash on some inputs.

Note that version published on crates.io is a dummy, as it is not possible to publish correct build here due to use of git dependencies. Versions published on GitHub are correct.

Database support

Only Postgres is supported at the moment and with very limited set of types.

Installation

With script

In bash shell run:

curl -s https://raw.githubusercontent.com/strowk/tisq/main/install.sh | bash

Tested on Linux bash and Windows Git Bash. Should work for MacOS too.

Disabling sudo

By default the script would try to install TisQ to /usr/local/bin and would require sudo rights for that, but you can disable this behavior by setting NO_SUDO environment variable:

curl -s https://raw.githubusercontent.com/strowk/tisq/main/install.sh | NO_SUDO=1 bash

Sudo is disabled by default for Windows Git Bash.

From sources

If your system/architecture is not supported by the script above, you can install Rust and install TisQ from sources:

git clone https://github.com/strowk/tisq
cargo install --path ./tisq

Using Docker

You can run TisQ in Docker container:

docker run -it --rm ghcr.io/strowk/tisq:main-debian
# or
docker run -it --rm ghcr.io/strowk/tisq:main-alpine

Note that the version in main-* tags would be from the latest commit in main branch. Builds are provided based on Debian and Alpine Linux with x86_64 and aarch64 architectures.

Keybindings

Some of following keybindings are configurable and could be adjusted in configuration file that is located under home folder in .tisq/config.toml.

The format for this file could be illustrated by the following example:

# Firstly specify the section for keybindings
[keybindings.globals] # word "globals" here is a name of the keybinding config section
# Then use keybinding name as a key and list of possible key presses as a value
GlobalExit = [
    # This would allow to use Esc key without any modifiers
    { modifiers = "", key = { type = "Esc" } },
    # Or, alternatively use Ctrl+C combination, both would work
    { modifiers = "Ctrl", key = { type = "Char", args = "c" } },
]

In this example it is demonstrated how to specify special keys, such as Esc, using simple type = "Esc" and how characters are specified using type = "Char" with args field that contains the character.

Global

Config section: globals.

Browser (tree view)

Config section: browser.

Query editor

Config section: editor.

Query result

Config section: result.

Snippets

Snippets are small shortcuts that can be expanded into SQL code.

Currently only standard Postgres snippets are supported, but in future it will be possible to add custom snippets.

Supported snippets

Roadmap

• Customizable keybindings by config TOML file
• Save query editors content on exit and restore on start
• Add schemas and tables to tree view
• Add standard postgres snippets expansion
• Display available snippets
• Allow to add custom snippets
• Add other objects to tree view (views, functions, etc)
• Show table columns in tree view
• status line: Show loading while executing query
• Add support for more Postgres types (from https://docs.rs/sqlx-postgres/0.7.2/sqlx_postgres/types/index.html )
• Error handling: remove all unwrap() calls and anything else that can panic
• Customize keybindings in UI
• themes: Customizeable style by config TOML file
• Add support for query parameters
• Add support for query history
• Add support for query execution plan
• Support queries with big results by paging
• Limit query result size by amount of rows
• Better limit of query result by memory size (use https://docs.rs/datasize/latest/datasize/ )
• Syntax highlighting for query editor
• databases: Add support for MySQL
• databases: Add support for SQLite
• databases: Add support for MS SQL Server (via https://github.com/prisma/tiberius )