sqlite3

The command-line interface to SQLite 3, which is a self-contained file-based embedded SQL engine. More information: <https://sqlite.org>.

Install

All systems
curl cmd.cat/sqlite3.sh
Debian Debian
apt-get install sqlite3
Ubuntu
apt-get install sqlite3
Alpine
apk add sqlite
Arch Arch Linux
pacman -S sqlite
image/svg+xml Kali Linux
apt-get install sqlite3
CentOS
yum install sqlite
Fedora
dnf install sqlite
Windows (WSL2)
sudo apt-get update sudo apt-get install sqlite3
OS X
brew install sqlite
Raspbian
apt-get install sqlite3
Dockerfile
dockerfile.run/sqlite3
Docker
docker run cmd.cat/sqlite3 sqlite3 powered by Commando

The command-line interface to SQLite 3, which is a self-contained file-based embedded SQL engine. More information: <https://sqlite.org>.

  • Start an interactive shell with a new database:
    sqlite3
  • Open an interactive shell against an existing database:
    sqlite3 path/to/database.sqlite3
  • Execute an SQL statement against a database and then exit:
    sqlite3 path/to/database.sqlite3 'SELECT * FROM some_table;'

© tl;dr; authors and contributors