A fast, lightweight SQLite database viewer TUI
Project description
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
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:
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file sqv-0.4.1.tar.gz.
File metadata
- Download URL: sqv-0.4.1.tar.gz
- Upload date:
- Size: 1.7 MB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.9.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
f307fcd75ac22faf7fbd5f9e6e16e3768eb6ef551416784666ce25f135e17ec7
|
|
| MD5 |
a93a0aa8bc241cb9996de89d42e7af8e
|
|
| BLAKE2b-256 |
bcc6a61cfd17df6dbd292b3192308ca6ee7216800be56c02c74da2c55696bff0
|
File details
Details for the file sqv-0.4.1-py3-none-any.whl.
File metadata
- Download URL: sqv-0.4.1-py3-none-any.whl
- Upload date:
- Size: 21.2 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.9.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
373c43efb9c173101ecd3969cda469961b8c7ce3983071643a651d3e5c4872d1
|
|
| MD5 |
5848061acb52763b2a2a88de9bfc53f4
|
|
| BLAKE2b-256 |
9992f327aef3d22c89bb8f76d89f81014ba897e3a88bf5c81f0d39e129666b91
|