Guides
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
Begin by installing the @libsql/client
dependency in your project:
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
.
TURSO_DATABASE_URL=
TURSO_AUTH_TOKEN=
3
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.
4
Execute SQL
---
import { turso } from './turso'
const { rows } = await turso.execute('SELECT * FROM table_name')
---