Description:
CLI utility for manipulating SQLite databases
|
|
Type: Formula
|
Latest Version: 3.39@0
|
Tracked Since: Oct 12, 2025
|
|
Links:
Homepage |
formulae.brew.sh
|
|
Category: Databases
|
|
Tags:
sqlite
database
cli
data-processing
etl
|
|
Install:
brew install sqlite-utils
|
About:
sqlite-utils is a powerful command-line interface (CLI) tool and Python library designed for creating, querying, and manipulating SQLite databases. It allows users to inspect databases, insert data from JSON and CSV files, and run queries with output in various formats. The tool simplifies data wrangling tasks by providing intuitive commands for common database operations without requiring SQL expertise.
|
Key Features:
- Insert data from JSON, CSV, and other formats into SQLite databases
- Inspect database schemas and table details with easy-to-read output
- Query databases and output results in JSON, CSV, or table formats
- Python library API for programmatic database manipulation
- Support for full-text search and advanced SQLite features
|
Use Cases:
- Quickly exploring and analyzing datasets by converting CSV/JSON files to queryable SQLite databases
- Data pipeline automation where SQLite serves as an intermediate storage format
- Creating portable, serverless databases for small applications or prototypes
|
Alternatives:
-
sqlite3
– Built-in SQLite CLI is more limited; sqlite-utils provides richer import/export and inspection features
-
Datasette
– Datasette focuses on publishing and visualizing data; sqlite-utils focuses on manipulation and ETL tasks
|
| Detected |
Version |
Rev |
Change |
Commit |
| Oct 12, 2025 10:20am |
|
0 |
VERSION_BUMP |
c56e90b3 |
| Sep 15, 2025 12:11pm |
|
0 |
VERSION_BUMP |
72a557b9 |
| Nov 23, 2024 11:23pm |
|
0 |
VERSION_BUMP |
52dbeb8a |
| Oct 10, 2024 2:28pm |
|
0 |
VERSION_BUMP |
a709a86e |
| Sep 10, 2024 11:24pm |
|
0 |
VERSION_BUMP |
7d1c17db |
| Sep 25, 2023 2:17am |
|
0 |
VERSION_BUMP |
50f78edd |
| May 22, 2023 4:56am |
|
0 |
VERSION_BUMP |
03a1baf9 |
| May 22, 2023 3:19am |
|
0 |
VERSION_BUMP |
36771de5 |
| Nov 28, 2022 10:13pm |
|
1 |
VERSION_BUMP |
c1116d9b |
| Nov 19, 2022 9:20pm |
|
0 |
VERSION_BUMP |
15f3a96c |
|