Turso Quickstart (Python)

Get started with Turso and Python using the libSQL client in a few simple steps.

In this Python quickstart we will learn how to:

• Retrieve database credentials
• Install the libSQL package
• Connect to a Turso database
• Execute a query using SQL
• Sync changes to local database (optional)

1. Retrieve database credentials

   You will need an existing database to continue. If you don’t have one, create one.

   Get database URL

   turso db show <database-name> --url
   

   Create database auth token

   turso db tokens create <database-name>
   

   You will want to store these as environment variables.
2. Install

   First begin by adding libSQL to your project:

   pip install libsql-experimental
   
3. Connect

   Then import the package:

   import libsql_experimental as libsql
   

   Now connect to your local or remote database using the libSQL connector:

   Embedded Replicas

   url = os.getenv("TURSO_DATABASE_URL")
   auth_token = os.getenv("TURSO_AUTH_TOKEN")
   
   con = libsql.connect("hello.db", sync_url=url, auth_token=auth_token)
   con.sync()
   

   Local only

   con = libsql.connect("hello.db")
   cur = con.cursor()
   
4. Execute

   You can execute SQL queries against your existing database as follows:

   conn.execute("CREATE TABLE IF NOT EXISTS users (id INTEGER);")
   conn.execute("INSERT INTO users(id) VALUES (10);")
   
   print(conn.execute("select * from users").fetchall())
   
5. Sync (Embedded Replicas only)

   When using embedded replicas you should call sync() on the connector to sync your local database with the primary database.

   conn.execute("CREATE TABLE IF NOT EXISTS users (id INTEGER);")
   conn.execute("INSERT INTO users(id) VALUES (1);")
   conn.commit()
   
   conn.sync()
   
   print(conn.execute("select * from users").fetchall())