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!

License