Turso Database for Python

About

Turso Database runs in production today at multiple organizations. It has not yet reached 1.0, so as with any database we recommend keeping backups — see the FAQ for where the project stands.

Features

SQLite compatible: SQLite query language and file format support (status).
In-process: No network overhead, runs directly in your Python process
Cross-platform: Supports Linux, macOS, Windows
Remote partial sync: Bootstrap from a remote database, pull remote changes, and push local changes when online — all while enjoying a fully operational database offline.
Asyncio support: Built-in integration with asyncio to ensure queries won’t block your event loop

Installation

uv pip install pyturso

Database driver

A minimal DB‑API 2.0 example using an in‑memory database:

import turso

# Standard DB-API usage
conn = turso.connect(":memory:")
cur = conn.cursor()

cur.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, username TEXT)")
cur.execute("INSERT INTO users VALUES (1, 'alice'), (2, 'bob')")

cur.execute("SELECT * FROM users ORDER BY id")
rows = cur.fetchall()
print(rows)  # [(1, 'alice'), (2, 'bob')]

conn.close()

Database driver (asyncio)

Non-blocking access with asyncio:

import asyncio
import turso.aio

async def main():
    # Connect and use as an async context manager
    async with turso.aio.connect(":memory:") as conn:
        # Executes multiple statements
        await conn.executescript("""
            CREATE TABLE t (id INTEGER PRIMARY KEY, name TEXT);
            INSERT INTO t(name) VALUES ('alice'), ('bob');
        """)

        # Use a cursor for parameterized queries
        cur = conn.cursor()
        await cur.execute("SELECT COUNT(*) FROM t WHERE name LIKE ?", ("a%",))
        count = (await cur.fetchone())[0]
        print(count)  # 1

        # JSON and generate_series also available
        cur = conn.cursor()
        await cur.execute("SELECT SUM(value) FROM generate_series(1, 10)")
        print((await cur.fetchone())[0])  # 55

asyncio.run(main())

Synchronization driver

Use a remote Turso database while working locally. You can bootstrap local state from the remote, pull remote changes, and push local commits.

Note: You need a Turso remote URL. See the Turso docs for provisioning and authentication.

import turso.sync

# Connect a local database to a remote Turso database
conn = turso.sync.connect(
    ":memory:",                          # local db path (or a file path)
    remote_url="https://<db>.<region>.turso.io"  # your remote URL
)

# Read data (fetched from remote if not present locally yet)
rows = conn.execute("SELECT * FROM t").fetchall()
print(rows)

# Pull new changes from remote into local
changed = conn.pull()
print("Pulled:", changed)  # True if there were new remote changes

# Make local changes
conn.execute("INSERT INTO t VALUES ('push works')")
conn.commit()

# Push local commits to remote
conn.push()

# Optional: inspect and manage sync state
stats = conn.stats()
print("Network received (bytes):", stats.network_received_bytes)
conn.checkpoint()  # compact local WAL after many writes

conn.close()

Partial bootstrap to reduce initial network cost:

import turso.sync

conn = turso.sync.connect(
    "local.db",
    remote_url="https://<db>.<region>.turso.io",
    # fetch first 128 KiB upfront
    partial_sync_experimental=turso.sync.PartialSyncOpts(
      bootstrap_strategy=turso.sync.PartialSyncPrefixBootstrap(length=128 * 1024),
    ),
)

Synchronization driver (asyncio)

The same sync primitives, but fully async:

import asyncio

async def main():
    conn = await turso.aio.sync.connect(":memory:", remote_url="https://<db>.<region>.turso.io")

    # Read data
    rows = await (await conn.execute("SELECT * FROM t")).fetchall()
    print(rows)

    # Pull and push
    await conn.pull()
    await conn.execute("INSERT INTO t VALUES ('hello from asyncio')")
    await conn.commit()
    await conn.push()

    # Stats and maintenance
    stats = await conn.stats()
    print("Main WAL size:", stats.main_wal_size)
    await conn.checkpoint()

    await conn.close()

asyncio.run(main())

License

This project is licensed under the MIT license.

Support

Release files for pyturso 0.8.0rc8

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pyturso 0.8.0rc8
File	Size	Uploaded
pyturso-0.8.0rc8.tar.gz	3.2 MB	Sep 4, 2026	Details

Built distributions (wheels)

Table of built distributions (wheels) for pyturso 0.8.0rc8
File	Interpreter	ABI	Platform	Reset
pyturso-0.8.0rc8-cp310-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl 27.8 MB Sep 4, 2026	CPython 3.10	abi3	Linux glibc 2.17+ x86-64	Details
pyturso-0.8.0rc8-cp310-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl 27.3 MB Sep 4, 2026	CPython 3.10	abi3	Linux glibc 2.17+ ARM64	Details
pyturso-0.8.0rc8-cp310-abi3-macosx_11_0_arm64.whl 8.1 MB Sep 4, 2026	CPython 3.10	abi3	macOS 11.0+ ARM64	Details
pyturso-0.8.0rc8-cp310-abi3-macosx_10_12_x86_64.whl 9.3 MB Sep 4, 2026	CPython 3.10	abi3	macOS 10.12+ x86-64	Details

Total release size: 75.7 MB

Release files / pyturso-0.8.0rc8.tar.gz

Download URL	pyturso-0.8.0rc8.tar.gz
Size	3.2 MB
Tags	Source
SHA-256 checksum How to use checksums	`b362610d5a2c375929e4850a9e3689a1a75aebf02bf7b0f918c209946f673715`
BLAKE2b-256 checksum How to use checksums	`1e9123a465fc481aca94d8e5c11b87844fc1e5d4180973a398a6bf4ad96983b1`
Upload date	Sep 4, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`maturin/1.15.0`

Release files / pyturso-0.8.0rc8-cp310-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Download URL	pyturso-0.8.0rc8-cp310-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Size	27.8 MB
Tags	CPython 3.10 Linux glibc 2.17+ x86-64 abi3
SHA-256 checksum How to use checksums	`d9f10bbb285979b56e38e003cbbecfaec941aec59a68779f9b230fba557e8dca`
BLAKE2b-256 checksum How to use checksums	`8e7eeb85c9581f8188ecc30cd3a2170636881c45b7e9821a1dc6aa117cebf4bf`
Upload date	Sep 4, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`maturin/1.15.0`

Release files / pyturso-0.8.0rc8-cp310-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Download URL	pyturso-0.8.0rc8-cp310-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Size	27.3 MB
Tags	CPython 3.10 Linux glibc 2.17+ ARM64 abi3
SHA-256 checksum How to use checksums	`4959f9c857c3abb9f20cf0b46682bd7047a07d417c9ad7ec62c9c469b773d14b`
BLAKE2b-256 checksum How to use checksums	`f1dab505f621b3e6f5279d8ddcbfc4a39479e39f462e4afcba40540a5d095f41`
Upload date	Sep 4, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`maturin/1.15.0`

Release files / pyturso-0.8.0rc8-cp310-abi3-macosx_11_0_arm64.whl

Download URL	pyturso-0.8.0rc8-cp310-abi3-macosx_11_0_arm64.whl
Size	8.1 MB
Tags	CPython 3.10 abi3 macOS 11.0+ ARM64
SHA-256 checksum How to use checksums	`475805431e9a5b955322690bf8325a98988b1f9dc4c28f5ad28851503a7f8b64`
BLAKE2b-256 checksum How to use checksums	`886ed8991cbb72996d7de80c9d040fd4043966562e86b3809af55aec8c6d3f0e`
Upload date	Sep 4, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`maturin/1.15.0`

Release files / pyturso-0.8.0rc8-cp310-abi3-macosx_10_12_x86_64.whl

Download URL	pyturso-0.8.0rc8-cp310-abi3-macosx_10_12_x86_64.whl
Size	9.3 MB
Tags	CPython 3.10 abi3 macOS 10.12+ x86-64
SHA-256 checksum How to use checksums	`2a2f85e3ebc75ebf77d422d7dcc3542fe76dc5c44367821598c747ecc6666354`
BLAKE2b-256 checksum How to use checksums	`81ab3b26d83a3afe4dd7573ca5c41a7eafbac555e0c05090b64bd4c36a9b4ee9`
Upload date	Sep 4, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`maturin/1.15.0`