Skip to main content

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

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

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

sqv-0.5.0.tar.gz (1.7 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

sqv-0.5.0-py3-none-any.whl (22.9 kB view details)

Uploaded Python 3

File details

Details for the file sqv-0.5.0.tar.gz.

File metadata

  • Download URL: sqv-0.5.0.tar.gz
  • Upload date:
  • Size: 1.7 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.9.2

File hashes

Hashes for sqv-0.5.0.tar.gz
Algorithm Hash digest
SHA256 2e13f4a8fcaeaa2edd5e39cff72f2fd9569454613312cb794b0caf9b6f52c3f4
MD5 07a2547f951504b4cfa078b440e4b3e6
BLAKE2b-256 966a2e174a10bd0bcf27ced1f128eb4d8abc00b5ea463c9273ea6166ab582422

See more details on using hashes here.

File details

Details for the file sqv-0.5.0-py3-none-any.whl.

File metadata

  • Download URL: sqv-0.5.0-py3-none-any.whl
  • Upload date:
  • Size: 22.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.9.2

File hashes

Hashes for sqv-0.5.0-py3-none-any.whl
Algorithm Hash digest
SHA256 aec1c724dd2a0238a1edab2fde73649e3d4b201566c3d257ea96038a0ac568eb
MD5 7c84fd70989cf59af8f5e7f74eba567e
BLAKE2b-256 c0a5133d6613c651d9448f6d2d233079713b2a72821a741756d8325dc1cec27f

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page