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.4.1.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.4.1-py3-none-any.whl (21.2 kB view details)

Uploaded Python 3

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

Hashes for sqv-0.4.1.tar.gz
Algorithm Hash digest
SHA256 f307fcd75ac22faf7fbd5f9e6e16e3768eb6ef551416784666ce25f135e17ec7
MD5 a93a0aa8bc241cb9996de89d42e7af8e
BLAKE2b-256 bcc6a61cfd17df6dbd292b3192308ca6ee7216800be56c02c74da2c55696bff0

See more details on using hashes here.

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

Hashes for sqv-0.4.1-py3-none-any.whl
Algorithm Hash digest
SHA256 373c43efb9c173101ecd3969cda469961b8c7ce3983071643a651d3e5c4872d1
MD5 5848061acb52763b2a2a88de9bfc53f4
BLAKE2b-256 9992f327aef3d22c89bb8f76d89f81014ba897e3a88bf5c81f0d39e129666b91

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