Skip to content

RhetTbull/sqv

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

40 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

sqv - SQLite Viewer TUI

A fast, lightweight SQLite database viewer TUI built with Python and Textual.

Features

  • Database Structure Tab: Browse tables, indices, views, and triggers with their SQL definitions
  • Data Tab: View table data with sorting and filtering
  • Execute SQL Query Tab: Execute arbitrary SQL queries

Screenshots

sqv structure screenshot

sqv data screenshot

sqv sql screenshot

sqv sql screenshot

Installation

I recommend installation with uv.

uv tool install sqv

Or to run without installing:

uv tool run sqv <database.db>

To install from source:

git clone git@github.com:RhetTbull/sqv.git
uv sync

Usage

sqv <database.db>

Key Bindings

Key Action
d Go to Database Structure tab
b Go to Browse Data tab
e Go to Execute SQL tab
Ctrl+q Quit
Ctrl+Enter Execute SQL (in SQL tab)
? Show help

See Also

sqv is not intended to be a full SQL IDE. I built it to do exactly the things I wanted and nothing else. If you find sqv doesn't suit your needs, you might find one of these more full featured alternatives does:

  • harlequin: The SQL IDE for your terminal
  • sqlit: A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL, SQLite, Turso and more.
  • litecli: CLI for SQLite Databases with auto-completion and syntax highlighting

About

SQLite database viewer terminal/text user interface (TUI) for exploring SQLite databases.

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Contributors

Languages