Guides
Loading documentation…
Preparing this guide.
Loading page content
Write and run type-safe Drizzle and Prisma Client queries directly inside Dora, with schema-aware autocomplete and a SQL preview before execution.
Prefer your ORM over raw SQL? Dora has runners for both Drizzle and Prisma Client. Write a query in the ORM's own syntax, get schema-aware autocomplete as you type, preview the SQL it compiles to, and run it against the connected database with results in the standard table view.
This is Dora's most differentiated feature. No other desktop client treats ORMs as a first-class way to query.
Write Drizzle queries against the connected database:
db
.select()
.from(users)
.where(eq(users.plan, 'pro'))users. offers the real columns.Write Prisma Client queries the same way:
prisma.user.findMany({
where: { plan: 'pro' },
})The Prisma runner mirrors the Drizzle experience: completions come from your models, and Dora previews the SQL the Prisma query translates to before execution.
The runners and the cockpit are complementary: