fastlite
A bit of extra usability for sqlite
Decision gist · record as of 2026-08-14
Yes, if you work with SQLite in Jupyter or IPython. It genuinely improves the interactive experience with auto-complete and convenient table/column access, has low install friction, is actively maintained, carries no security vulnerabilities, and uses a permissive license. Not necessary for non-interactive SQLite work or if you prefer raw sqlite-utils.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later; designed primarily for interactive environments like Jupyter or IPython.
- Low install friction with only two runtime dependencies (fastcore and apswutils).
- Actively maintained with recent commits and a stable release cadence; last update was 2026-01-12.
License · maintenance · safety
Apache Software License 2.0 (permissive) — Apache Software License 2.0 is permissive, allowing free use, modification, and distribution in both open-source and commercial projects with minimal restrictions.
last release 2026-01-12 (214 days) · last repo commit 2026-07-26 · 230 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 739,816 downloads/mo, #5,184 on PyPI
Alternatives
Verify before relying
pip install fastlite
from fastlite import *
db = database("chinook.sqlite")
dt = db.t # list all tables
artist = dt.Artist # access a table
db.q(f"select * from {artist}") # query with auto-complete-friendly syntax- Whether sqlite-utils is installed as a transitive dependency or must be installed separately
- Performance characteristics when working with large databases
- Compatibility with non-Jupyter interactive Python environments beyond IPython
What it is and what it does
fastlite is a convenience layer over sqlite-utils that makes interactive SQLite exploration smoother in Jupyter notebooks and IPython. It provides auto-complete for tables, columns, and views; lets you navigate database structure through properties like `.t` (tables), `.c` (columns), and `.v` (views); and automatically generates dataclasses that match your table schemas. You can reference tables and columns directly in f-strings for SQL queries, and call tables as functions to fetch records as dataclass instances.
The package is built for developers who want to explore and manipulate SQLite databases interactively without boilerplate. It handles common operations like create, insert, update, upsert, and lookup through a fluent API, and supports filtering via an `.xtra()` method that applies conditions to subsequent operations. It's particularly useful in notebook workflows where you're prototyping queries or building data pipelines incrementally.
Use it for
- Explore and query SQLite databases interactively in Jupyter with auto-complete for tables and columns
- Generate dataclasses from database tables for type-safe record handling in notebooks
- Prototype SQL queries and data transformations without writing raw SQL strings
- Build and manipulate SQLite tables programmatically using Python dicts or dataclass instances
- Create views and perform joins with auto-complete-friendly syntax in interactive environments
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you work with SQLite in Jupyter or IPython.
It genuinely improves the interactive experience with auto-complete and convenient table/column access, has low install friction, is actively maintained, carries no security vulnerabilities, and uses a permissive license. Not necessary for non-interactive SQLite work or if you prefer raw sqlite-utils.
Install
fastlite on PyPI
Before you install
Low install friction with only two runtime dependencies (fastcore and apswutils). Actively maintained with recent commits and a stable release cadence; last update was 2026-01-12.
Requires Python 3.10 or later; designed primarily for interactive environments like Jupyter or IPython.
License in practice
Apache Software License 2.0 is permissive, allowing free use, modification, and distribution in both open-source and commercial projects with minimal restrictions.
Quickstart
pip install fastlite
from fastlite import *
db = database("chinook.sqlite")
dt = db.t # list all tables
artist = dt.Artist # access a table
db.q(f"select * from {artist}") # query with auto-complete-friendly syntaxVerify before relying
- Whether sqlite-utils is installed as a transitive dependency or must be installed separately
- Performance characteristics when working with large databases
- Compatibility with non-Jupyter interactive Python environments beyond IPython
Package facts
| License | Apache Software License 2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagesfastcoreapswutils |
| Maintenance | Actively maintained 214 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 739,816 / month, #5,184 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseNatural Language :: EnglishProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12 |
Evidence: fastlite-0.2.4-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlite interactive jupyter”
- fastlitefastlite wraps sqlite-utils to provide interactive SQLite database…
- ipython-sqlAdds SQL magic commands to IPython and Jupyter notebooks, letting you…
- litecliA command-line client for SQLite databases with auto-completion and…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also apswutils · ipython-sql · sqlite-utils · cobble · jupysql · aiosqlite · pangres · databricks-sql · sqlite-migrate · ipykernel