Skip to main content

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

Metadata

Release files for sqlite-bro 1.3.2

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

Source distribution (sdist)

Source distribution for sqlite-bro 1.3.2
File Size Uploaded
sqlite_bro-1.3.2.tar.gz 43.8 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for sqlite-bro 1.3.2
File Interpreter ABI Platform
sqlite_bro-1.3.2-py3-none-any.whl Python 3 none any Details

Total release size: 91.3 kB

Release files / sqlite_bro-1.3.2.tar.gz

Download URL sqlite_bro-1.3.2.tar.gz
Size 43.8 kB
Tags Source
SHA-256 checksum
How to use checksums
09602d8e0272e25a94a74c3f34c19ab2bb7bc8cb4a7c021910863d561efc69b4
BLAKE2b-256 checksum
How to use checksums
337f902d2d49861d54c6dfc693ea6d2f739597525408a60db899054c0975a9d0
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

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.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 4, 2026.

Transparency log

Release files / sqlite_bro-1.3.2-py3-none-any.whl

Download URL sqlite_bro-1.3.2-py3-none-any.whl
Size 47.5 kB
Tags Python 3
SHA-256 checksum
How to use checksums
0ecda886fbd9c9536cbc7192662be0a0b7d963e9df506dcc788cf1e37e572034
BLAKE2b-256 checksum
How to use checksums
17ce51e2a8e3e11cfd7f8dffcdbbf080721322a1ad62533b58ebc26162a16038
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

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.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Aug 4, 2026.

Transparency log

Release history Release notifications | RSS feed

This release

1.3.2 This release

2 release files

1.3.1

2 release files

1.3.0

2 release files

1.2.0

2 release files

1.1.0

2 release files

1.0.0

2 release files

0.14.0

2 release files

0.13.1

2 release files

0.12.1

2 release files

0.9.3

2 release files

0.9.2

2 release files

0.9.1

2 release files

0.9.0

2 release files

0.8.11

1 release file

0.8.10

2 release files

0.8.8

2 release files

0.8.6

1 release file

0.8.5

1 release file

0.8.4

1 release file

0.8.3

1 release file

0.8.2

1 release file

0.8.1

1 release file

0.8.0

1 release file

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