Skip to main content
Remix banner

​
Prerequisites

Before you start, make sure you:
1

Install the libSQL SDK

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.
TURSO_DATABASE_URL="..."
TURSO_AUTH_TOKEN="..."
3

Configure LibSQL Client.

app/lib/turso.ts
import { createClient } from "@libsql/client";

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

Execute SQL

app/routes/_index.ts
import type { LoaderFunction } from "@remix-run/node";
import { turso } from "~/lib/turso";

export const loader: LoaderFunction = async () => {
  const { rows } = await turso.execute("SELECT * from TABLE_NAME");

  return {
    items: rows,
  };
};

​
Examples

E-commerce Store

See the full source code

CRM App

See the full source code