Home

Awesome

SQLTUI - A terminal UI to operate sql and nosql databases

sqltui provides a terminal UI to interact with your sql or nosql databases. The aim of this project is to make it easier to navigate, observe and manage your databases in the wild.

Screenshots

  1. mysql login

  2. mysql tables tree

  3. mysql show records

  4. mysql auto complete query

  5. msql show error message

  6. redis keys

  7. redis result

  8. redis auto complete and command tip

install

1. install with go

go install github.com/LinPr/sqltui@latest

quick start

help

$ sqltui -h

sqltui is a tui tool to operate sql and nosql databases

Usage:
  sqltui [command]

Available Commands:
  completion  Generate the autocompletion script for the specified shell
  help        Help about any command
  mysql       start a mysql tui
  redis       start a redis tui

Flags:
  -h, --help   help for sqltui

Use "sqltui [command] --help" for more information about a command.

connect to mysql

$ sqltui mysql

connect to redis

$ sqltui redis

Keybindings

Login

kEYfUNCTION
EnterConfirm Login Information
Ctrl+sSave Login Information to file (defeault to ~/.sqltui)
Ctrl+cQuit
TabSwitch to next object
Ctrl+TabSwitch to previous object

Mysql Dashboard

kEYfUNCTION
EnterSelect Tree Node
TabSwitch Widget Focus

TODO list

  1. supprt sqlight(current working on)
  2. support others...

references

this project used two main opensorce projects