sqlite-anyio
Asynchronous client for SQLite using AnyIO
Decision gist · record as of 2026-08-14
Yes, if you're building an async application and need a simple, embedded database. The low install friction, active maintenance, MIT license, and zero known vulnerabilities make it a safe choice. The beta status and small user base mean you should verify that its API and performance meet your specific needs before committing to a large project.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later; anyio must be installed as a runtime dependency.
- Low friction install with only two lightweight runtime dependencies (anyio and typing-extensions).
- Actively maintained with a recent release, though the project remains in beta status and has a small user base.
License · maintenance · safety
permissive license (permissive) — MIT license permits free use, modification, and distribution with minimal restrictions—suitable for both open-source and commercial projects.
last release 2026-08-06 (8 days) · last repo commit 2026-08-06 · 6 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 625,415 downloads/mo, #5,696 on PyPI
Alternatives
Verify before relying
import anyio
from sqlite_anyio import open_sqlite
async def main():
async with open_sqlite(':memory:') as db:
await db.execute('CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT)')
await db.execute('INSERT INTO test (name) VALUES (?)', ('example',))
rows = await db.execute('SELECT * FROM test')
print(rows.fetchall())
anyio.run(main)- Whether the package supports concurrent access patterns or enforces serialization at the connection level.
- Performance characteristics compared to thread-pool-based async SQLite wrappers in real workloads.
- Completeness of SQLite API coverage and any known limitations or missing features.
What it is and what it does
sqlite-anyio wraps SQLite with an async interface built on AnyIO, allowing you to execute database queries without blocking your event loop. It works with any async framework that AnyIO supports—asyncio, Trio, or others—so you can use the same code across different async runtimes. The package is lightweight, depending only on anyio and typing-extensions, and targets modern Python versions from 3.10 onward.
The main use case is integrating SQLite into async applications where you want to avoid the overhead of thread pools or the complexity of managing blocking I/O. It's particularly useful for small to medium projects that need a simple, embedded database without the operational burden of a separate database server, while still maintaining async/await semantics throughout the application.
Use it for
- Building async web applications (FastAPI, Starlette) that need a lightweight embedded database.
- Writing async CLI tools or scripts that query SQLite without blocking the event loop.
- Testing async code that requires database fixtures without spinning up a separate database service.
- Prototyping async applications where you want to defer migration to a larger database system.
- Running async background tasks that periodically read or write to a local SQLite database.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you're building an async application and need a simple, embedded database.
The low install friction, active maintenance, MIT license, and zero known vulnerabilities make it a safe choice. The beta status and small user base mean you should verify that its API and performance meet your specific needs before committing to a large project.
Install
sqlite-anyio on PyPI
Before you install
Low friction install with only two lightweight runtime dependencies (anyio and typing-extensions). Actively maintained with a recent release, though the project remains in beta status and has a small user base.
Requires Python 3.10 or later; anyio must be installed as a runtime dependency.
License in practice
MIT license permits free use, modification, and distribution with minimal restrictions—suitable for both open-source and commercial projects.
Quickstart
import anyio
from sqlite_anyio import open_sqlite
async def main():
async with open_sqlite(':memory:') as db:
await db.execute('CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT)')
await db.execute('INSERT INTO test (name) VALUES (?)', ('example',))
rows = await db.execute('SELECT * FROM test')
print(rows.fetchall())
anyio.run(main)Verify before relying
- Whether the package supports concurrent access patterns or enforces serialization at the connection level.
- Performance characteristics compared to thread-pool-based async SQLite wrappers in real workloads.
- Completeness of SQLite API coverage and any known limitations or missing features.
Package facts
| License | permissive license permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagesanyiotyping-extensions |
| Maintenance | Actively maintained 8 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 625,415 / month, #5,696 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 :: MIT LicenseProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: DatabaseTyping :: Typed |
Evidence: sqlite_anyio-0.3.2-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 › “async sqlite client”
- sqlite-anyioProvides an asynchronous client for SQLite that works with any async…
- libsql-clientPython SDK for connecting to and querying libSQL databases,…
- anysqliteAnysqlite wraps SQLite with an async/await interface that works with…
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 anysqlite · aiosqlite · anyio · factorio-rcon-py · async-extensions · asyncer · kubernetes-asyncio · flake8-async · python-socks · libsql-client