Elysia banner

​
Prerequisites

Before you start, make sure you:
1

Install the libSQL SDK

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

Retrieve 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

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

export const turso = createClient({
  url: process.env.TURSO_DATABASE_URL,
  authToken: process.env.TURSO_AUTH_TOKEN,
});
4

Execute SQL

import { Elysia } from "elysia";
import { turso } from "./lib/turso";

const app = new Elysia().get("/items", async () => {
  const { rows } = await turso.execute("SELECT * FROM items");
  return rows;
});

​
Examples

Expenses tracker app with Elysia & Turso

See the full source code