sqlite-utils

CLI tool for querying and manipulating SQLite databases

brewmacoslinux

Try with needOr install directly

About

CLI utility for manipulating SQLite databases

sqlite-utils

Convert a JSON file to a SQLite table$ sqlite-utils insert database.db table_name data.json

Execute a SQL query and output results as JSON$ sqlite-utils query database.db 'SELECT * FROM table_name' --json

Create a full-text search index on a table column$ sqlite-utils enable-fts database.db table_name column_name