Astro + Turso

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

Install the libSQL SDK

Begin by installing the @libsql/client dependency in your project:

npm install @libsql/client

pnpm install @libsql/client

yarn add @libsql/client

deno add npm:@libsql/client

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.

TURSO_DATABASE_URL=
TURSO_AUTH_TOKEN=

Configure libSQL client

src/turso.ts

import { createClient } from "@libsql/client/web";

export const turso = createClient({
  url: import.meta.env.TURSO_DATABASE_URL!,
  authToken: import.meta.env.TURSO_AUTH_TOKEN,
});

Astro will soon introduce a new ENV API. Take a look.

Execute SQL

---
import { turso } from './turso'

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

Examples

Blog

See the full source code

Turso Cloud

SDKs

CLI

API Reference

Integrations

Astro + Turso

Prerequisites

Examples

Blog

​Prerequisites

​Examples

Blog

Prerequisites

Examples