sqlite-utils
Verified for current stable LTS
Sqlite Utils Commands
Sqlite Utils command syntax with verified terminal examples.
Commands
8 commands for Sqlite Utils
sqlite-utils Operations
Sqlite Utils Command: Create Database Sqlite
sqlite-utils create-database <path/to/database.db> sqlite-utils Operations
Sqlite Utils Command: Create Table Sqlite
sqlite-utils create-table <path/to/database.db> <table_name> <id integer name text height float photo blob --pk id> sqlite-utils Operations
Sqlite Utils Command: Delete Record Sqlite
sqlite-utils query <path/to/database.db> "<delete from table_name where name = 'Tony Hoare'>" sqlite-utils Operations
Sqlite Utils Command: Display Help Sqlite
sqlite-utils -h sqlite-utils Operations
Sqlite Utils Command: Drop Table Sqlite
sqlite-utils drop-table <path/to/database.db> <table_name> sqlite-utils Operations
Sqlite Utils Command: List Tables Sqlite
sqlite-utils tables <path/to/database.db> sqlite-utils Operations
Sqlite Utils Command: Select Records Sqlite
sqlite-utils rows <path/to/database.db> <table_name> sqlite-utils Operations
Sqlite Utils Command: Upsert Record Sqlite
{{echo '[ {"id": 1, "name": "Linus Torvalds"}, {"id": 2, "name": "Steve Wozniak"}, {"id": 3, "name": "Tony Hoare"} ]'}} | sqlite-utils upsert <path/to/database.db> <table_name> - <--pk id> Suggest a Sqlite Utils Command
Submit missing workflows, corrections, or verified alternatives for this tool.
FAQ
Coverage: Focused examples for common Sqlite Utils workflows.
Verified version: current stable LTS.
Verification: Test commands in a disposable workspace and submit notes for edge cases.