🍺 BREW Explorer

← all formulae

sqlite

brew install sqlite v3.53.2 blessing keg-only

Command-line shell and database client for SQLite, a self-contained SQL database engine.

Why you might care

SQLite is the de facto embedded database for applications, mobile platforms, and file-based persistence. This formula provides the command-line `sqlite3` tool for querying, managing, and inspecting .db files directly from your shell. Keg-only because macOS provides a system version, but Homebrew's build is often newer with additional features and bug fixes.

Categories

database-client cli

Alternatives

system sqlite3 DuckDB PostgreSQL client
333.5k
30-day installs · #3
1.1M
90-day · #4
3.7M
365-day · #3

Runtime dependencies

readline

Links

Keg-only reason

:provided_by_macos

Blurb generated by claude-haiku-4-5 on today.

Raw metadata 
{
  "aliases": [
    "sqlite3"
  ],
  "alternatives": [
    "system sqlite3",
    "DuckDB",
    "PostgreSQL client"
  ],
  "build_dependencies": [],
  "categories": [
    "database-client",
    "cli"
  ],
  "caveats": null,
  "conflicts_with": [],
  "dependencies": [
    "readline"
  ],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "Command-line interface for SQLite",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:40:36+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "sqlite",
  "github_default_branch": null,
  "github_last_commit_at": null,
  "github_readme_excerpt": null,
  "github_repo": null,
  "github_stars": null,
  "github_topics": [],
  "homepage": "https://sqlite.org/index.html",
  "homepage_og_description": null,
  "homepage_og_image": null,
  "homepage_title": "SQLite Home Page",
  "installs_30d": 333470,
  "installs_365d": 3662351,
  "installs_90d": 1118946,
  "keg_only": 1,
  "keg_only_reason": ":provided_by_macos",
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "blessing",
  "llm_generated_at": "2026-06-20T23:42:04+00:00",
  "llm_model": "claude-haiku-4-5",
  "name": "sqlite",
  "oldnames": [],
  "one_liner": "Command-line shell and database client for SQLite, a self-contained SQL database engine.",
  "optional_dependencies": [],
  "rank_30d": 3,
  "rank_365d": 3,
  "rank_90d": 4,
  "raw_hash": "f8c43d402608b376",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/s/sqlite.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [],
  "version_head": null,
  "version_stable": "3.53.2",
  "versioned_formulae": [],
  "why_use_this": "SQLite is the de facto embedded database for applications, mobile platforms, and file-based persistence. This formula provides the command-line `sqlite3` tool for querying, managing, and inspecting .db files directly from your shell. Keg-only because macOS provides a system version, but Homebrew\u0027s build is often newer with additional features and bug fixes."
}