sqlite-utils-shell

An interactive shell for sqlite-utils

Alternative: sqlite-utils-litecli is similar to this but better, because it includes full autocompletion against table and column names.

Installation

Install this plugin in the same environment as sqlite-utils.

sqlite-utils install sqlite-utils-shell

To start a new interactive shell session against a database:

sqlite-utils shell data.db

Type quit or exit to end the session.

Omit the filename to run against an in-memory database.

To load additional SQLite extensions pass their paths as one or more --load-extension arguments:

sqlite-utils shell data.db \
  --load-extension /path/to/extension.so

To set up this plugin locally, first checkout the code. Then create a new virtual environment:

cd sqlite-utils-shell
python3 -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest