Installation

sqlite-utils is tested on Linux, macOS and Windows.

Using Homebrew

The sqlite-utils command-line tool can be installed on macOS using Homebrew:

brew install sqlite-utils

If you have it installed and want to upgrade to the most recent release, you can run:

brew upgrade sqlite-utils

Then run sqlite-utils --version to confirm the installed version.

Using pip

The sqlite-utils package on PyPI includes both the sqlite_utils Python library and the sqlite-utils command-line tool. You can install them using pip like so:

pip install sqlite-utils

Using pipx

pipx is a tool for installing Python command-line applications in their own isolated environments. You can use pipx to install the sqlite-utils command-line tool like this:

pipx install sqlite-utils

Setting up shell completion

You can configure shell tab completion for the sqlite-utils command using these commands.

For bash:

eval "$(_SQLITE_UTILS_COMPLETE=bash_source sqlite-utils)"

For zsh:

eval "$(_SQLITE_UTILS_COMPLETE=zsh_source sqlite-utils)"

Add this code to ~/.zshrc or ~/.bashrc to automatically run it when you start a new shell.

See the Click documentation for more details.