aiosqlite

asyncio bridge to the standard sqlite3 module

aiosqlite Permissive license Active ★ 1,570 v0.22.1 released 2025-12-23

Install

aiosqlite on PyPI

pip

pip install aiosqlite

uv

uv add aiosqlite

poetry

poetry add aiosqlite

Package facts

License	not declared (permissive)
Python support	supports the current Python release (>=3.9)
Install friction	low — pure-Python wheel
Runtime dependencies	none
Maintenance	actively maintained — 233 days since the last release
Last repo commit	2026-03-01
First released	2017-05-25
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: aiosqlite-0.22.1-py3-none-any.whl

Development Status :: 5 - Production/StableFramework :: AsyncIOIntended Audience :: DevelopersLicense :: OSI Approved :: MIT LicenseTopic :: Software Development :: Libraries

About aiosqlite

from the package's own PyPI description — quoted content, verbatim

aiosqlite\: Sqlite for AsyncIO

.. image:: https://readthedocs.org/projects/aiosqlite/badge/?version=latest :target: https://aiosqlite.omnilib.dev/en/latest/?badge=latest :alt: Documentation Status .. image:: https://img.shields.io/pypi/v/aiosqlite.svg :target: https://pypi.org/project/aiosqlite :alt: PyPI Release .. image:: https://img.shields.io/badge/change-log-blue :target: https://github.com/omnilib/aiosqlite/blob/master/CHANGELOG.md :alt: Changelog .. image:: https://img.shields.io/pypi/l/aiosqlite.svg :target: https://github.com/omnilib/aiosqlite/blob/master/LICENSE :alt: MIT Licensed

aiosqlite provides a friendly, async interface to sqlite databases.

It replicates the standard sqlite3 module, but with async versions of all the standard connection and cursor methods, plus context managers for automatically closing connections and cursors:

.. code-block:: python

async with aiosqlite.connect(...) as db:
    await db.execute("INSERT INTO some_table ...")
    await db.commit()

    async with db.execute("SELECT * FROM some_table") as cursor:
        async for row in cursor:...

Read as markdown · JSON record · Source repository · Docs

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

aiosqlite provides an async interface to SQLite databases that mirrors the standard sqlite3 module, allowing non-blocking database queries and operations within AsyncIO event loops.

Installation is straightforward with no runtime dependencies and a pure-Python wheel distribution. The package is actively maintained with a recent release (233 days ago) and a stable repository with 1570 stars.

Licensed under the permissive MIT license, allowing commercial and private use with minimal restrictions.

Usage

pip install aiosqlite

import aiosqlite

async with aiosqlite.connect('db.sqlite') as db:
    await db.execute('INSERT INTO table VALUES (?)', (1,))
    await db.commit()

Requires Python 3.9 or newer and an async context (e.g., within an async function called by asyncio.run()).

Verdict: aiosqlite is a production-stable, well-maintained async SQLite wrapper with zero dependencies, no known vulnerabilities, and permissive licensing. It is suitable for projects needing non-blocking database access in AsyncIO applications.

Needs verification

Whether the shared-thread-per-connection model meets performance requirements for high-concurrency workloads.
Compatibility with SQLite features beyond the standard sqlite3 API that the package claims to replicate.

async sqlite databaseasyncio sqlite3 wrappernon-blocking sqlite queriesasync database connectionsqlite async context managerasyncio sql databaseasync cursor sqlite