import Knex from 'knex';
import ClientD1 from 'knex-cloudflare-d1';

export interface Env {
  DB: D1Database;
}

export default {
  fetch: (req: Request, env: Env) => {
    // ...

    const knex = Knex({
      client: ClientD1,
      connection: {
        database: env.DB
      },
      useNullAsDefault: true,
    });

    // ...
  }
}

import Knex from 'knex';
import ClientD1 from 'knex-cloudflare-d1';
import RemoteClient from 'knex-cloudflare-d1/remote-client';

const DB = new RemoteClient({
  accountId: 'your-account-id',
  databaseId: 'your-database-id',
  apiToken: 'your-api-token',
  fetch: fetch, // Optional, default to globalThis.fetch
});

const knex = Knex({
  client: RemoteClient,
  connection: {
    database: DB
  },
  useNullAsDefault: true,
});