sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
About sqlite-utils
sqlite-utils is a command-line utility, also usable as a Python library, for manipulating SQLite databases. You can pipe JSON, CSV or TSV straight into a new database file and it creates a table with a suitable schema automatically.
It can also run in-memory SQL queries against data files and carry out common table changes from the shell. It suits data journalists, analysts and developers who want to turn loose data into SQLite quickly.
Strengths
- Imports JSON, CSV and TSV with automatic schema creation
- In-memory SQL queries over data files
- Works as both a CLI and a Python library
Limitations
- Command-line only, no graphical interface
- Requires a Python environment
Details
- Pricing
- FreeFree and open source.
- License
- Open source, license not stated
- Developer
- Simon Willison
- Platforms
- Command line
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- Turning JSON or CSV data into SQLite databases from the shell
- Categories
- Database tools, Developer tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to sqlite-utils
Compare allSoftware that can replace sqlite-utils for an important use case, and what changes if you switch.
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 necessarily 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.
