Stop guessing which one. Put them side by side.

The grid says what these tools are. This says what builders did about it — one decision per person, changeable whenever you change your mind.

# Tool comparison — Xata vs Drizzle ORM vs PocketBase

Source: Kbaise, a directory of tools that work with Lovable projects.
Pick one and tell me why before writing any integration code.

## Xata (xata)
- URL: https://xata.io
- Category: Databases & backend
- Cost: mixed — Xata Cloud is pay-as-you-go from about $0.012/hr compute plus $0.28/GB-mo storage; the micro instance works out around $9/mo. Self-hosted open source is free.
- What it is: Vanilla Postgres 18 with copy-on-write branching: a branch of any size is created in seconds and stores only what changes. Idle branches hibernate and wake in about a second. Xata relaunched as a Postgres platform, replacing its earlier serverless data API product.
- Why builders pick it: A branch per coding agent or preview deploy costs cents — Xata quotes a thousand branches for a dollar. Useful when you want agents experimenting against production-sized data without any risk to it.
- Trap: The old Xata serverless platform and its 15GB free tier are gone; the current Postgres cloud has no permanently free hosted plan, only pay-as-you-go compute or self-hosting.
- Full dossier: /api/public/tools/xata

## Drizzle ORM (drizzle-orm)
- URL: https://orm.drizzle.team
- Category: Databases & backend
- Cost: free — Free and open source under Apache 2.0. Drizzle Studio and Drizzle Kit are free; Drizzle Gateway is in closed alpha.
- What it is: A headless TypeScript ORM whose query API deliberately mirrors SQL, so a Drizzle query reads like the statement it compiles to. Supports Postgres, MySQL, SQLite, SingleStore, MSSQL and CockroachDB, with dedicated drivers for Neon, Supabase, Turso, PlanetScale and Cloudflare D1. Drizzle Kit handles migrations.
- Why builders pick it: No code generation step and no separate engine binary, so it runs inside edge runtimes and whatever sandbox an agent is building in. Being close to SQL, models translate a schema idea into working queries with fewer invented helpers.
- Trap: Relational query ergonomics are thinner than Prisma's, and drizzle-kit push against production can drop columns without much ceremony. Migration tooling has churned across versions.
- Wiring: npm i drizzle-orm && npm i -D drizzle-kit
- Full dossier: /api/public/tools/drizzle-orm

## PocketBase (pocketbase)
- URL: https://pocketbase.io
- Category: Databases & backend
- Cost: free — Free and MIT-licensed. You pay only for a host — roughly $4-6/mo on Hetzner, Fly.io or a small VPS.
- What it is: One executable containing an embedded SQLite database, REST API, realtime subscriptions, email and OAuth2 authentication, file storage and an admin dashboard. Extensible through Go or JavaScript hooks. Still pre-1.0 at the v0.39 series, but widely run in production on a single small server.
- Why builders pick it: Zero cloud bill, zero vendor account, and the entire backend is one file you can copy onto a $5 VPS. Ideal when you want the code and the data to be genuinely yours with no pausing rules.
- Trap: Single node only — no horizontal scaling and no managed backups, so you own uptime, patching and disk. Pre-1.0 means occasional breaking changes between minor releases.
- Wiring: Download the binary, then run ./pocketbase serve
- Full dossier: /api/public/tools/pocketbase

## Quick read

- Free with no card: Drizzle ORM, PocketBase.

## Rules
1. Prefer the free tier when no budget was stated, and say what the ceiling is.
2. Read the full dossier before integrating.
3. Fetch /api/public/models before writing any AI model ID.

Agents can fetch the same thing: GET /api/public/compare?slugs=xata,drizzle-orm,pocketbase