/usr/bin/sqlite-utils

Usage: sqlite-utils [OPTIONS] COMMAND [ARGS]...

  Commands for interacting with a SQLite database

Options:
  --version   Show the version and exit.
  -h, --help  Show this message and exit.

Commands:
  query*                Execute SQL query and return the results as JSON
  add-column            Add a column to the specified table
  add-foreign-key       Add a new foreign key constraint to an existing...
  add-foreign-keys      Add multiple new foreign key constraints to a...
  add-geometry-column   Add a SpatiaLite geometry column to an existing...
  analyze               Run ANALYZE against the whole database, or...
  analyze-tables        Analyze the columns in one or more tables
  bulk                  Execute parameterized SQL against the provided...
  convert               Convert columns using Python code you supply.
  create-database       Create a new empty database file
  create-index          Add an index to the specified table for the...
  create-spatial-index  Create a spatial index on a SpatiaLite geometry...
  create-table          Add a table with the specified columns.
  create-view           Create a view for the provided SELECT query
  disable-fts           Disable full-text search for specific table
  disable-wal           Disable WAL for database files
  drop-index            Drop an index by index name from the specified table
  drop-table            Drop the specified table
  drop-view             Drop the specified view
  dump                  Output a SQL dump of the schema and full contents...
  duplicate             Create a duplicate of this table, copying across...
  enable-counts         Configure triggers to update a _counts table with...
  enable-fts            Enable full-text search for specific table and...
  enable-wal            Enable WAL for database files
  extract               Extract one or more columns into a separate table
  index-foreign-keys    Ensure every foreign key column has an index on it
  indexes               Show indexes for the whole database or specific...
  insert                Insert records from FILE into a table, creating...
  insert-files          Insert one or more files using BLOB columns in...
  install               Install packages from PyPI into the same...
  memory                Execute SQL query against an in-memory database,...
  migrate               Apply pending database migrations.
  optimize              Optimize all full-text search tables and then run...
  plugins               List installed plugins
  populate-fts          Re-populate full-text search for specific table...
  rebuild-fts           Rebuild all or specific full-text search tables
  rename-table          Rename this table.
  reset-counts          Reset calculated counts in the _counts table
  rows                  Output all rows in the specified table
  schema                Show full schema for this database or for...
  search                Execute a full-text search against this table
  tables                List the tables in the database
  transform             Transform a table beyond the capabilities of...
  triggers              Show triggers configured in this database
  uninstall             Uninstall Python packages from the sqlite-utils...
  upsert                Upsert records based on their primary key.
  vacuum                Run VACUUM against the database
  views                 List the views in the database