@flowpanel/adapter-drizzle

Drizzle ORM adapter for FlowPanel.

Most users import from flowpanel/drizzle (umbrella subpath).

Use

import { drizzleAdapter } from "flowpanel/drizzle";
import { db } from "@/db/client";
import * as schema from "@/db/schema";

export default defineAdmin({
  adapter: drizzleAdapter({ db, schema }),
  // ...
});

dialect is auto-inferred from the schema. Pass it explicitly to disambiguate:

drizzleAdapter({ db, schema, dialect: "mysql" })   // "pg" | "mysql" | "sqlite"

What it implements

The full Adapter contract from @flowpanel/core:

• introspect(ref) — column meta from drizzle's getTableColumns
• inferSchema(ref) — Zod create / update / select via drizzle-zod
• list / get / create / update / delete / restore — with soft-delete (ctx.softDelete?.column)

Dialect support

• Postgres — full support, uses RETURNING for create / update
• MySQL 8 — RETURNING not supported; insert-then-select-by-pk
• SQLite — same as MySQL; :memory: works for tests

Documentation

https://flowpanel.dev

License

MIT