Alternatives to sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases. The listings below can replace it for an important use case. Each note says what changes if you switch.
The original
sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases.
Replacements
Listings that take over the same core job as sqlite-utils.
sq
An open-source command-line tool to inspect, query, join, import and export data across databases and files.
sq imports and exports data across databases and files, including Excel into tables, but uses its own SLQ query language and is not a Python library.
trdsql
Query structured files with SQL from the command line.
trdsql runs SQL directly over structured files from the command line, without building SQLite databases or offering a Python library.
Similar software
Related functionality, not a direct replacement.
Datasette
Publishes SQLite databases as an explorable website and JSON API.
LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
SQLite
A small, self-contained SQL database engine that stores a whole database in one file.
VisiData
An interactive terminal multitool for exploring, cleaning and converting tabular data in many formats.
DuckDB
In-process analytical database that queries CSV, JSON and Parquet directly.
DB Browser for SQLite
Opens a SQLite file in a spreadsheet-like window so you can look at the data without writing SQL.
