​
Prerequisites

Before you start, make sure you:

1

Install the libSQL SDK

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

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

4

Execute SQL

import { Hono } from "hono";
import { turso } from "./lib/turso";

const app = new Hono();

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

  return c.json({ rows });
});

​
Examples

Expenses tracker app with Hono & Turso

See the full source code

Was this page helpful?

ElysiaDrizzle