Connect to Turso using Python

Install

Add the Turso package to your Python project:

uv pip install pyturso

Connect

Here’s how you can connect to a local SQLite database:

import turso

con = turso.connect("sqlite.db")
cur = con.cursor()

Create table

Create a table for users:

cur.execute("""
  CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL
  )
""")
con.commit()

Insert data

Insert some data into the users table:

cur.execute("INSERT INTO users (username) VALUES (?)", ("alice",))
cur.execute("INSERT INTO users (username) VALUES (?)", ("bob",))
con.commit()

Query data

Query all users from the table:

res = cur.execute("SELECT * FROM users")
users = res.fetchall()
print(users)