# Install sqlite with Homebrew, apk, chocolatey, dnf, Nix, pacman, scoop, winget, zypper, apt, MacPorts Command-line interface for SQLite. Version 3.53.3 via Homebrew; verified 2026-06-27. ## Install ```sh sudo av install brew:sqlite ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install sqlite ``` Evidence: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install sqlite3 ``` Evidence: MacPorts ports tree: databases/sqlite3/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - apk (92%): ```sh sudo apk add sqlite ``` Evidence: Alpine Linux edge package indexes: sqlite from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz - dnf (92%): ```sh sudo dnf install lemon ``` Evidence: Fedora Rawhide package metadata: lemon from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst - Nix (92%): ```sh nix profile install nixpkgs#sqlite ``` Evidence: nixpkgs package indexes: sqlite from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix - pacman (92%): ```sh sudo pacman -S sqlite ``` Evidence: Arch Linux sync databases: sqlite from https://geo.mirror.pkgbuild.com/core/os/x86_64/core.db.tar.gz - zypper (92%): ```sh sudo zypper install sqlite3 ``` Evidence: openSUSE Tumbleweed package metadata: sqlite3 from https://download.opensuse.org/tumbleweed/repo/oss/repodata/be8d3611d25469107f32075a1697e69ec57a2b850b42348a658cc671ad5ec2b50760d02c3e59524d50da9a11d5be799bdaffba2e166e8ca8858512e3c0bd665d-primary.xml.zst - Debian apt (92%): ```sh sudo apt install lemon ``` Evidence: Debian stable package indexes: lemon from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz ### Windows - Chocolatey (92%): ```sh choco install SQLite ``` Evidence: Chocolatey community package catalog: SQLite from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','sql2008r2.cmdline' - Scoop (92%): ```sh scoop install main/sqlite ``` Evidence: Scoop official bucket manifest trees: bucket/sqlite.json from https://api.github.com/repos/ScoopInstaller/Main/git/trees/master?recursive=1 - winget (92%): ```sh winget install --id SQLite.SQLite -e ``` Evidence: Windows Package Manager source index: SQLite.SQLite from https://cdn.winget.microsoft.com/cache/source.msix ## Package facts - **Package key:** brew:sqlite - **Package manager:** Homebrew - **Package manager page:** - **Version:** 3.53.3 - **Source summary:** Command-line interface for SQLite - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** blessing - **Source archive:** - **Last updated:** 2026-06-27T14:08:56Z - **Generated:** 2026-07-08T07:18:31+00:00 ## Executables - sqlite3 (cli) - sqlite3 (alias) ## Dependencies - readline ## Install behavior - Post-install hook: not defined - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sequoia, sonoma, tahoe, x86_64_linux ## Freshness - Page generated: 2026-07-08 - Package-manager version: 3.53.3 - Package-manager updated: 2026-06-27 - Local data: ok - Upstream repository: https://sqlite.org/index.html - info: Release/tag comparison is only available for GitHub repositories. ## Project history and usage SQLite is an embedded, serverless SQL database engine and one of the most widely deployed software components in everyday computing. In package-manager culture, the `sqlite` package is both a runtime dependency and a tiny command-line database workbench. ### Project history The SQLite project states that it began on 2000-05-09. Its design centers on a self-contained, zero-configuration, transactional SQL database engine stored in ordinary disk files, with public-domain source code and long-term support goals. The SQLite command-line program, `sqlite3`, is the officially supported interactive interface to SQLite database files. The CLI is distinct from the SQLite library: it accepts user input and passes SQL to the library, while also providing dot-commands for import, export, schema inspection, archives, recovery, parameters, extensions, and scripting. ### Adoption history SQLite's official site calls it the most used database engine in the world and says it is built into all mobile phones and most computers. The most-deployed page lists Android, iOS devices, Macs, Windows 10/11 installations, major browsers, Python, PHP, and many applications as places SQLite appears. The input shows SQLite packaged across Homebrew, Chocolatey, MacPorts, Nix, Scoop, winget, apk, pacman, and other distribution ecosystems. That breadth matches SQLite's role as a default local database layer and a basic CLI tool developers expect to be available. ### How it is used Developers use the `sqlite3` CLI to open database files, run SQL interactively, script SQL from shell pipelines, import and export CSV or TSV, inspect schemas, dump databases, recover data, load extensions, and experiment with SQL locally. SQLite is commonly used as an application file format, local cache, data-transfer container, embedded-device database, website database for modest traffic, and quick analysis database for CSV or JSON data. ### Why package nerds care Package nerds care about SQLite because it is the rare package that is simultaneously a library, a database engine, a file format, and a CLI. Installing `sqlite` gives immediate access to `sqlite3`, a portable database file format, and a common dependency shared by many higher-level tools. SQLite's public-domain status, single-file databases, cross-platform file format, and zero-admin deployment make it especially attractive in package ecosystems: it works as a dependency, debugging tool, fixture format, and data interchange tool without needing a service manager or credentials. ### Timeline - 2000: SQLite project started on 2000-05-09. - 2021: SQLite 3.37.0 added CLI support for multiple open database connections. - 2025: SQLite documentation states an intent to support the project through 2050. - 2026: SQLite homepage lists 3.53.3 as the latest release on 2026-06-26. ### Related projects - sqlite3_analyzer and sqlite3_rsync are official SQLite companion utilities. - sqlite-utils and sqlite3-to-mysql are third-party tools that build workflows around SQLite files. - SQLite's own docs compare its problem space to local file I/O rather than to client/server database engines. ### Sources - - - - - ## Security Notes doc example: bounded database tool. - **Geiger risk:** blue / high - doc example: bounded database tool ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** sqlite - **Aliases:** sqlite3 - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** yes - **URL Keys:** stable ## Other Package-Manager Records - Nix - sqlite: normalized package name match | nixpkgs package indexes: sqlite from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix - apk - sqlite - 3.53.2-r0: normalized package name match | Alpine Linux edge package indexes: sqlite from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine | https://www.sqlite.org/ - apk - sqlite-dev - 3.53.2-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-dev from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine (development files) | https://www.sqlite.org/ - apk - sqlite-doc - 3.53.2-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-doc from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine (documentation) | https://www.sqlite.org/ - apk - sqlite-libs - 3.53.2-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-libs from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine (libraries) | https://www.sqlite.org/ - apk - sqlite-static - 3.53.2-r0: normalized package name match | Alpine Linux edge package indexes: sqlite-static from https://dl-cdn.alpinelinux.org/alpine/edge/main/x86_64/APKINDEX.tar.gz | C library that implements an SQL database engine (static library) | https://www.sqlite.org/ - dnf - lemon - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: lemon from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | A parser generator | http://www.sqlite.org/ - dnf - sqlite - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Library that implements an embeddable SQL database engine | http://www.sqlite.org/ - dnf - sqlite-analyzer - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-analyzer from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | An analysis program for sqlite3 database files | http://www.sqlite.org/ - dnf - sqlite-debug - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-debug from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | SQLite shell configured for development and debugging purposes | http://www.sqlite.org/ - dnf - sqlite-devel - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-devel from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Development tools for the sqlite3 embeddable SQL database engine | http://www.sqlite.org/ - dnf - sqlite-doc - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-doc from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Documentation for sqlite | http://www.sqlite.org/ - dnf - sqlite-libs - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-libs from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Shared library for the sqlite3 embeddable SQL database engine. | http://www.sqlite.org/ - dnf - sqlite-tcl - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-tcl from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Tcl module for the sqlite3 embeddable SQL database engine | http://www.sqlite.org/ - dnf - sqlite-tools - 3.53.2-1.fc45: normalized package name match | Fedora Rawhide package metadata: sqlite-tools from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | sqlite tools | http://www.sqlite.org/ - pacman - sqlite - 3.53.2-1: normalized package name match | Arch Linux sync databases: sqlite from https://geo.mirror.pkgbuild.com/core/os/x86_64/core.db.tar.gz | A C library that implements an SQL database engine | https://www.sqlite.org/ ## Related links - [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Networking and protocol packages](https://www.automicvault.com/pkg/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata. - [adios2](https://www.automicvault.com/pkg/brew/adios2/) - Popular package that depends on this formula. - [aircrack-ng](https://www.automicvault.com/pkg/brew/aircrack-ng/) - Popular package that depends on this formula. - [amber](https://www.automicvault.com/pkg/brew/amber/) - Popular package that depends on this formula. - [aria2](https://www.automicvault.com/pkg/brew/aria2/) - Popular package that depends on this formula. - [bigloo](https://www.automicvault.com/pkg/brew/bigloo/) - Popular package that depends on this formula. - [botan](https://www.automicvault.com/pkg/brew/botan/) - Popular package that depends on this formula. - [cherrytree](https://www.automicvault.com/pkg/brew/cherrytree/) - Popular package that depends on this formula. - [codequery](https://www.automicvault.com/pkg/brew/codequery/) - Popular package that depends on this formula. - [mariadb](https://www.automicvault.com/pkg/brew/mariadb/) - Shares av.db curated category or tags: cli, data, database, relational, sql. - [lazysql](https://www.automicvault.com/pkg/brew/lazysql/) - Shares av.db curated category or tags: cli, data, database, sql, sqlite. - [berkeley-db](https://www.automicvault.com/pkg/brew/berkeley-db/) - Shares av.db curated category or tags: cli, data, database, embedded-database. - [dbxml](https://www.automicvault.com/pkg/brew/dbxml/) - Shares av.db curated category or tags: cli, data, database, embedded-database. - [derby](https://www.automicvault.com/pkg/brew/derby/) - Shares av.db curated category or tags: cli, data, database, embedded-database. - [dolt](https://www.automicvault.com/pkg/brew/dolt/) - Shares av.db curated category or tags: cli, data, database, sql. - [doltgres](https://www.automicvault.com/pkg/brew/doltgres/) - Shares av.db curated category or tags: cli, data, database, sql. - [duckdb](https://www.automicvault.com/pkg/brew/duckdb/) - Shares av.db curated category or tags: cli, data, database, sql. - [sqlite-analyzer](https://www.automicvault.com/pkg/brew/sqlite-analyzer/) - Package names and metadata indicate a similar tool family. Shared terms: cli, data, database, sqlite, sqlite3. - [sqlite-rsync](https://www.automicvault.com/pkg/brew/sqlite-rsync/) - Package names and metadata indicate a similar tool family. Shared terms: cli, data, database, sqlite, sqlite3. - [sqldiff](https://www.automicvault.com/pkg/brew/sqldiff/) - Local metadata places this package in an adjacent workflow. Shared terms: cli, database, sql, sqlite. ## Combined YAML source View the package source record on GitHub. [combined/sqlite.yml](https://github.com/automic-vault/db/blob/main/combined/sqlite.yml) ## Sources - Nucleus package database - Geiger risk classifier - package-page enrichment - curated package history - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph