aiosqlite
asyncio bridge to the standard sqlite3 module
Decision gist · record as of 2026-08-14
Yes. aiosqlite is actively maintained, has no dependencies, installs cleanly, carries a permissive license, and solves a real problem—letting you use SQLite in async code without blocking. It's in the top 1000 packages by download volume and has no known vulnerabilities. Install it if you're writing async Python and need a local database.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.9 or newer; intended for use within an async context (event loop running).
- Low install friction; pure Python wheel with no runtime dependencies.
- Actively maintained with recent releases and a healthy repository.
License · maintenance · safety
permissive license (permissive) — MIT license (permissive); you can use, modify, and distribute aiosqlite freely in commercial and open-source projects with minimal restrictions.
last release 2025-12-23 (234 days) · last repo commit 2026-03-01 · 1,570 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 77,088,949 downloads/mo, #442 on PyPI
Alternatives
Verify before relying
pip install aiosqlite
import aiosqlite
async with aiosqlite.connect('db.sqlite') as db:
await db.execute('INSERT INTO table VALUES (1)')
await db.commit()
async with db.execute('SELECT * FROM table') as cursor:
async for row in cursor:
print(row)- Performance characteristics compared to synchronous sqlite3 for typical workloads.
- Thread-safety guarantees and behavior under high concurrency.
- Whether row_factory and other sqlite3 advanced features are fully replicated.
What it is and what it does
aiosqlite is an async wrapper around SQLite that lets you run database queries without blocking your AsyncIO event loop. Instead of using the standard sqlite3 module (which blocks), aiosqlite provides async versions of connection and cursor methods, so you can await database operations alongside other concurrent tasks. It uses a single shared thread per connection to serialize database access safely.
The package replicates sqlite3's API closely—connection objects, cursors, context managers, and features like row_factory all work as you'd expect, just with async/await syntax. You can use it in modern async code patterns with context managers, or in a traditional procedural style. It's compatible with current Python versions and has no external runtime dependencies.
Use it for
- Building async web applications that need to query local SQLite databases without blocking request handlers.
- Writing async data processing pipelines that read from or write to SQLite while performing other concurrent I/O.
- Testing async code that depends on persistent storage without introducing blocking calls.
- Migrating synchronous sqlite3 code to async frameworks like FastAPI or aiohttp.
- Implementing local caching or session storage in async services.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
aiosqlite is actively maintained, has no dependencies, installs cleanly, carries a permissive license, and solves a real problem—letting you use SQLite in async code without blocking. It's in the top 1000 packages by download volume and has no known vulnerabilities. Install it if you're writing async Python and need a local database.
Install
aiosqlite on PyPI
Before you install
Low install friction; pure Python wheel with no runtime dependencies. Actively maintained with recent releases and a healthy repository.
Requires Python 3.9 or newer; intended for use within an async context (event loop running).
License in practice
MIT license (permissive); you can use, modify, and distribute aiosqlite freely in commercial and open-source projects with minimal restrictions.
Quickstart
pip install aiosqlite
import aiosqlite
async with aiosqlite.connect('db.sqlite') as db:
await db.execute('INSERT INTO table VALUES (1)')
await db.commit()
async with db.execute('SELECT * FROM table') as cursor:
async for row in cursor:
print(row)Verify before relying
- Performance characteristics compared to synchronous sqlite3 for typical workloads.
- Thread-safety guarantees and behavior under high concurrency.
- Whether row_factory and other sqlite3 advanced features are fully replicated.
Package facts
| License | permissive license permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | None |
| Maintenance | Actively maintained 234 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 77,088,949 / month, #442 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableFramework :: AsyncIOIntended Audience :: DevelopersLicense :: OSI Approved :: MIT LicenseTopic :: Software Development :: Libraries |
Evidence: aiosqlite-0.22.1-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 › “asyncio sqlite3 wrapper”
- aiosqliteaiosqlite provides an async interface to SQLite databases that…
- anysqliteAnysqlite wraps SQLite with an async/await interface that works with…
- apswAPSW is a Python wrapper around SQLite's complete C API, providing…
Give your agent the search over MCP, or paste the wish link into any chat.
More Libraries packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Provides parsing, arithmetic, and recurrence rule computation for dates and times, with timezone support and iCalendar RFC compliance.
Install it if you need to parse flexible date strings, compute relative dates, handle timezones, or work with recurrence rules—it's the de facto choice for these tasks.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
See also anysqlite · sqlite-anyio · databases · aiosql · apswutils · pysqlite3-binary · dirsql · sqlitedict · libsql-client · fastlite