Skip to main content

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

Metadata

Release files for sqv 0.5.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqv 0.5.0
File Size Uploaded Provenance
sqv-0.5.0.tar.gz 1.7 MB Without provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for sqv 0.5.0
File Interpreter ABI Platform
sqv-0.5.0-py3-none-any.whl Python 3 none any Details

Total release size: 1.8 MB

Release files / sqv-0.5.0.tar.gz

Download URL sqv-0.5.0.tar.gz
Size 1.7 MB
Tags Source
SHA-256 checksum
How to use checksums
2e13f4a8fcaeaa2edd5e39cff72f2fd9569454613312cb794b0caf9b6f52c3f4
BLAKE2b-256 checksum
How to use checksums
966a2e174a10bd0bcf27ced1f128eb4d8abc00b5ea463c9273ea6166ab582422
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.9.2

Release files / sqv-0.5.0-py3-none-any.whl

Download URL sqv-0.5.0-py3-none-any.whl
Size 22.9 kB
Tags Python 3
SHA-256 checksum
How to use checksums
aec1c724dd2a0238a1edab2fde73649e3d4b201566c3d257ea96038a0ac568eb
BLAKE2b-256 checksum
How to use checksums
c0a5133d6613c651d9448f6d2d233079713b2a72821a741756d8325dc1cec27f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.9.2

Security for sqv 0.5.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page