simonw/sqlite-utils

Health v2 · maintenance only

Adoption not part of the score

2159 stars · 167 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

sqlite-utils is a Python CLI utility and library for creating, querying, and manipulating SQLite databases. It supports piping JSON/CSV/TSV data into tables, running SQL against files, configuring full-text search, schema transformations, migrations, and plugins.

Use cases

• load a csv file into a sqlite database
• run sql queries against files
• add full-text search to a sqlite table
• change a column type in sqlite
• normalize data by extracting columns into lookup tables
• manage sqlite schema migrations from python
• convert to sqlite

When to choose

• you work with SQLite from the command line or Python
• you need to import/export JSON, CSV, or TSV data into SQLite
• you want full-text search or schema changes SQLite doesn't support natively

When to avoid

• you need a full GUI database browser
• you're working with a database other than SQLite

Facets

cli-tool · maturity stable

cli database search-engine etl csv plugin-system databases developer-tools files cli python cross-platform sqlite datasette full-text-search data-import schema-migrations command-line data-engineering

Member repositories

For agents

markdown · JSON · MCP: product_card(name="simonw/sqlite-utils")