Create ",(0,e.jsx)(i.code,{children:".env"})," in the project root (you can copy from ",(0,e.jsx)(i.code,{children:".env.local.example"}),") with at least:"]}),(0,e.jsx)(e.Fragment,{children:(0,e.jsx)(i.pre,{className:"shiki shiki-themes github-light github-dark",style:{"--shiki-light":"#24292e","--shiki-dark":"#e1e4e8","--shiki-light-bg":"#fff","--shiki-dark-bg":"#24292e"},tabIndex:"0",icon:'',children:(0,e.jsxs)(i.code,{children:[(0,e.jsx)(i.span,{className:"line",children:(0,e.jsx)(i.span,{style:{"--shiki-light":"#6A737D","--shiki-dark":"#6A737D"},children:"# Local development / Vercel / Docker"})}),` `,(0,e.jsxs)(i.span,{className:"line",children:[(0,e.jsx)(i.span,{style:{"--shiki-light":"#24292E","--shiki-dark":"#E1E4E8"},children:"DATABASE_CONNECTION_STRATEGY"}),(0,e.jsx)(i.span,{style:{"--shiki-light":"#D73A49","--shiki-dark":"#F97583"},children:"="}),(0,e.jsx)(i.span,{style:{"--shiki-light":"#032F62","--shiki-dark":"#9ECBFF"},children:'"database_url_first"'})]}),` `,(0,e.jsxs)(i.span,{className:"line",children:[(0,e.jsx)(i.span,{style:{"--shiki-light":"#24292E","--shiki-dark":"#E1E4E8"},children:"DATABASE_URL"}),(0,e.jsx)(i.span,{style:{"--shiki-light":"#D73A49","--shiki-dark":"#F97583"},children:"="}),(0,e.jsx)(i.span,{style:{"--shiki-light":"#032F62","--shiki-dark":"#9ECBFF"},children:'"postgresql://:@:5432/"'})]})]})})}),(0,e.jsx)(i.p,{children:"Then run:"}),(0,e.jsx)(e.Fragment,{children:(0,e.jsx)(i.pre,{className:"shiki shiki-themes github-light github-dark",style:{"--shiki-light":"#24292e","--shiki-dark":"#e1e4e8","--shiki-light-bg":"#fff","--shiki-dark-bg":"#24292e"},tabIndex:"0",icon:'',children:(0,e.jsxs)(i.code,{children:[(0,e.jsxs)(i.span,{className:"line",children:[(0,e.jsx)(i.span,{style:{"--shiki-light":"#6F42C1","--shiki-dark":"#B392F0"},children:"pnpm"}),(0,e.jsx)(i.span,{style:{"--shiki-light":"#032F62","--shiki-dark":"#9ECBFF"},children:" drizzle:generate"})]}),` `,(0,e.jsxs)(i.span,{className:"line",children:[(0,e.jsx)(i.span,{style:{"--shiki-light":"#6F42C1","--shiki-dark":"#B392F0"},children:"pnpm"}),(0,e.jsx)(i.span,{style:{"--shiki-light":"#032F62","--shiki-dark":"#9ECBFF"},children:" drizzle:push"})]})]})})}),(0,e.jsx)(l,{type:"warning",title:"Local development note",children:(0,e.jsxs)(i.p,{children:["Do not use ",(0,e.jsx)(i.code,{children:"hyperdrive_first"})," for local Node.js development; use ",(0,e.jsx)(i.code,{children:"database_url_first"}),"."]})}),(0,e.jsx)(l,{type:"tip",title:"Cloudflare Worker deployment",children:(0,e.jsxs)(i.p,{children:["When deploying to Cloudflare Worker, you can switch to ",(0,e.jsx)(i.code,{children:'DATABASE_CONNECTION_STRATEGY="hyperdrive_first"'})," and configure Hyperdrive; ",(0,e.jsx)(i.code,{children:"DATABASE_URL"})," can be used as a fallback connection."]})}),(0,e.jsx)(i.p,{children:"Verify the connection:"}),(0,e.jsx)(e.Fragment,{children:(0,e.jsx)(i.pre,{className:"shiki shiki-themes github-light github-dark",style:{"--shiki-light":"#24292e","--shiki-dark":"#e1e4e8","--shiki-light-bg":"#fff","--shiki-dark-bg":"#24292e"},tabIndex:"0",icon:'

Database Configuration

On this page