Awesome SQLite

         

A curated list of tools, extensions, utilities, clients, libraries, and resources for SQLite — the world’s most widely deployed embedded database.

Contents

• Core Tools
• Extensions
• GUI Clients
• Command-Line Tools
• Libraries
• Full-Text Search & Search Extensions
• ORMs & Query Builders
• Backup, Sync & Replication
• Learning Resources
• Related Awesome Lists

Core Tools

• SQLite – Official SQLite database engine and documentation.
• DB Browser for SQLite – Open-source visual editor for SQLite databases.
• SQLiteStudio – Advanced SQLite database manager with plugin support.

Extensions

• SQLite Extensions (Official) – Core extension mechanisms and dynamic loading.
• SQLCipher – High-security encrypted SQLite database.
• SQLite JSON1 – JSON storage, querying, and manipulation.
• SQLite FTS5 – Full-text search extension.
• sqlite-vss – Vector search extension for embeddings and similarity lookup.
• sqlite-wasm – SQLite compiled to WebAssembly for browsers.
• libSQL Extensions – LSM storage engine variants.

GUI Clients

• Beekeeper Studio – Modern SQL editor supporting SQLite.
• DBeaver – Universal database client with SQLite support.
• TablePlus – Commercial, polished DB client with SQLite compatibility.
• DataGrip – JetBrains IDE for SQL and databases, supports SQLite.

Command-Line Tools

• LiteCLI – Enhanced CLI for SQLite with autocompletion and syntax highlighting.
• sqlean CLI Tools – Collection of useful SQLite extensions packaged as commands.
• sqlite-utils – Python-based utilities for manipulating SQLite databases.

Libraries

Python

• sqlite3 (Standard Library) – Built-in SQLite interface.
• apsw – Thin wrapper directly exposing SQLite’s C API.
• Dataset – Simplified database access layer.

JavaScript / Node.js

• better-sqlite3 – Fast, synchronous SQLite for Node.
• sqlite3 – Asynchronous SQLite bindings.
• wa-sqlite – SQLite in WebAssembly.

Go

• mattn/go-sqlite3 – Primary Go driver for SQLite.
• modernc.org/sqlite – Pure Go SQLite implementation.

Rust

• rusqlite – Idiomatic SQLite bindings for Rust.
• libsql-client – Client for libSQL/Turso.

Java / Kotlin

• SQLite JDBC – SQLite JDBC driver.

Full-Text Search & Search Extensions

• FTS4 / FTS5 (Official) – True full-text search extensions.
• sqlite-vss – Vector search extension.
• bm25 ranking for FTS – Built-in scoring support for ranked search.

ORMs & Query Builders

Python

• SQLModel – SQLAlchemy + Pydantic hybrid with SQLite-first support.
• Peewee – Lightweight, SQLite-friendly ORM.
• SQLAlchemy – Extensive ORM used across many SQLite projects.

JavaScript / TypeScript

• Prisma – Modern ORM with SQLite support.
• Drizzle ORM – TypeScript ORM optimized for SQLite.
• Kysely – Type-safe SQL query builder.

Go

• GORM – Popular Go ORM with SQLite support.
• sqlc – Type-safe code generation from raw SQL.

Rust

• Diesel – Type-safe ORM supporting SQLite.
• SeaORM – Async ORM with SQLite compatibility.

Backup, Sync & Replication

• Litestream – Streaming, continuous, real-time replication for SQLite.
• LiteFS – Distributed SQLite file system used in Fly.io apps.
• rqlite – Distributed SQLite over Raft for clustering.
• libSQL + Turso – Fork of SQLite with replication and HTTP-based access.

Learning Resources

• SQLite Documentation – Official, thorough documentation.
• The SQLite Handbook – Usage recommendations and guidance.
• SQLite Query Planner – Deep dive into query planning.
• SQLite Internals – Guide to understanding SQLite’s architecture.
• Designing with SQLite – Best practices for when and how to use SQLite.

Related Awesome Lists

• Awesome Databases
• Awesome SQL
• Awesome SQLite Extensions
• Awesome Rust
• Awesome Go

Contribute

Contributions are welcome. Please ensure your submission fully follows the requirements outlined in CONTRIBUTING.md, including formatting, scope alignment, and category placement.

Pull requests that do not adhere to the contribution guidelines may be closed.

License