jawj/zapatos

Health v2 · maintenance only

Flags: no_releases no_license

Adoption not part of the score

1402 stars · 48 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Zapatos is a TypeScript library providing zero-abstraction, fully typed access to Postgres. It generates a TypeScript schema from your database and offers typed helpers for arbitrary SQL, CRUD, nested LATERAL JOINs, and transactions.

Use cases

• write type-safe SQL queries in TypeScript against Postgres
• generate TypeScript types from a Postgres schema
• run typed CRUD queries without an ORM
• build nested JSON results from LATERAL JOINs
• manage and retry Postgres transactions in TypeScript
• avoid ORM abstractions while keeping type safety

When to choose

• you know SQL and want Postgres-first, type-safe queries in TypeScript
• you want automatic types generated from your actual database schema
• you need complex nested JSON query results without an ORM
• you find traditional ORMs too heavy or leaky

When to avoid

• you need multi-database support beyond Postgres
• you want a full ORM with migrations, models, and change tracking
• your project is not TypeScript or JavaScript with type checking
• you prefer query-builder abstractions over raw SQL

Facets

library · maturity active

database database-driver orm databases backend web-development developer-tools cli postgres type-safety sql non-orm tagged-templates schema-generation lateral-joins transactions nodejs typescript

Member repositories

For agents

markdown · JSON · MCP: product_card(name="jawj/zapatos")