Astro + Turso

Set up Turso in your Astro project in minutes.

Prerequisites

To get the most out of this guide, you’ll need to:

• Install the Turso CLI
• Sign up or login to Turso
• Have an Astro project — learn more

1. Install the libSQL SDK

   npm

   npm install @libsql/client
   
2. Configure database credentials

   Get the database URL.

   turso db show --url <database-name>
   

   Get the database authentication token.

   turso db tokens create <database-name>
   

   Assign credentials to the environment variables inside .env.local:

   TURSO_DATABASE_URL="..."
   TURSO_AUTH_TOKEN="..."
   
3. Configure LibSQL client

   src/turso.ts

   import { createClient } from "@libsql/client/web";
   
   export const turso = createClient({
     url: process.env.TURSO_DATABASE_URL!,
     authToken: process.env.TURSO_AUTH_TOKEN,
   });
   
4. Execute SQL

   ---
   import { turso } from './turso'
   
   const { rows } = await turso.execute('SELECT * FROM table_name')
   ---
   

Examples

Blog

See the full source code