sqlite-utils ☆
« Back to VersTracker
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
Version History
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
« Back to VersTracker  |  Browse Packages  |  About