Connection guide

Connect Cloudflare D1 to Dora

D1 is SQLite at the edge with no local file and no connection string. Create a scoped API token, paste it into Dora, and pick a database from your account.

Cloudflare D1 is SQLite running on Cloudflare's edge. There is no local database file and no libpq connection string — D1 is reached over an HTTP API. Dora ships a native HTTP query engine that speaks that API directly, so you connect with an account ID and a scoped API token instead of a URL.

Once authorized, Dora lists the D1 databases in your account and you pick one. The token is encrypted and stored only on your machine, and queries run against Cloudflare's API, not through Dora's servers.

Cloudflare D1 credentials

Account ID: [CLOUDFLARE_ACCOUNT_ID] API token: [D1_API_TOKEN] (D1 read/write) Database: picked from your account inside Dora

Steps

  1. 1.Find your account ID

    In the Cloudflare dashboard, open Workers & Pages. Your Account ID is shown in the right-hand sidebar. Copy it.

  2. 2.Create a scoped API token

    Go to My Profile → API Tokens → Create Token. Use a custom token with the "D1" permission set to Read and Write for the account that owns your databases.

  3. 3.Choose Cloudflare D1 in Dora

    In Dora, create a new connection and pick Cloudflare D1 from the provider grid. Paste your account ID and API token.

  4. 4.Pick a database and connect

    Dora calls the D1 API and lists the databases in your account. Select one and connect — its tables load into the sidebar like any other database.

Good to know

  • D1 has no connection string and no SSL toggle — all traffic goes over HTTPS to Cloudflare's API automatically.
  • The API token only needs the D1 permission. Scope it to read-only if you want a safe, browse-only connection.
  • Because D1 is SQLite, expect SQLite types and SQL dialect rather than Postgres or MySQL behavior.