sqlite-bro

sqlite_bro is a tool to browse SQLite (and optionally DuckDB) databases with any basic python installation.

Features

Tabular browsing of a SQLite or DuckDB database (needs ‘pip install duckdb’)
Import/Export of .csv and .json files with auto-detection
Import/Export of clipboard Data (copy / paste)
Import/Export of .sql script
Export of database creation .sql script
Support of sql-embedded Python functions
support supports command-line scripting if Python>=3.3 (see sqlite_bro -h), with or without Graphic User Interface
Easy to distribute : 1 Python source file, Python and PyPy3 compatible
Easy to start : just launch sqlite_bro
Easy to learn : Welcome example, minimal interface
Easy to teach : Character size, SQL + SQL result export on a click

Installation

You can install, upgrade, uninstall sqlite_bro.py with these commands:

$ apt-get install python3-tk # apt-get install python-tk if you are using python2
$ pip install sqlite_bro
$ pip install --upgrade sqlite_bro
$ pip uninstall sqlite_bro

or just launch latest version from IPython with %load https://raw.githubusercontent.com/stonebig/sqlite_bro/master/sqlite_bro/sqlite_bro.py or just copy the file ‘sqlite_bro.py’ to any pc and type ‘python sqlite_bro.py’

Example usage

$ python -m sqlite_bro

$ sqlite_bro

$ sqlite_bro -h

Screenshots

https://raw.githubusercontent.com/stonebig/sqlite_bro/master/docs/sqlite_bro.GIF

https://raw.githubusercontent.com/stonebig/sqlite_bro/master/docs/sqlite_bro_command_line.GIF

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlite_bro-1.3.2.tar.gz (43.8 kB view details)

Uploaded Aug 4, 2026 Source

Built Distribution

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

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

sqlite_bro-1.3.2-py3-none-any.whl (47.5 kB view details)

Uploaded Aug 4, 2026 Python 3

File details

Details for the file sqlite_bro-1.3.2.tar.gz.

File metadata

Download URL: sqlite_bro-1.3.2.tar.gz
Upload date: Aug 4, 2026
Size: 43.8 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for sqlite_bro-1.3.2.tar.gz
Algorithm	Hash digest
SHA256	`09602d8e0272e25a94a74c3f34c19ab2bb7bc8cb4a7c021910863d561efc69b4`
MD5	`c4535243980b0b4fa177ee9db182d78f`
BLAKE2b-256	`337f902d2d49861d54c6dfc693ea6d2f739597525408a60db899054c0975a9d0`

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlite_bro-1.3.2.tar.gz:

Publisher: publish.yml on stonebig/sqlite_bro

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: sqlite_bro-1.3.2.tar.gz
- Subject digest: 09602d8e0272e25a94a74c3f34c19ab2bb7bc8cb4a7c021910863d561efc69b4
- Sigstore transparency entry: 2340628584
- Sigstore integration time: Aug 4, 2026
Source repository:
- Permalink: stonebig/sqlite_bro@63b70443bfa7bba57ab79dc7797fbb6da56d0105
- Branch / Tag: refs/tags/v1.3.2
- Owner: https://github.com/stonebig
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: publish.yml@63b70443bfa7bba57ab79dc7797fbb6da56d0105
- Trigger Event: push