Define Drizzle ORM schemas and execute safe reads and writes against Neon Postgres.
npx skills add https://github.com/TimeKast/AgendaInteligente --skill db-timekast
Please help me install this Agent Skill. Skill: db Source: https://github.com/TimeKast/AgendaInteligente/tree/main/.agent/skills/domains/db Command: npx skills add https://github.com/TimeKast/AgendaInteligente --skill db-timekast
It standardizes how your application defines database schemas, writes safe queries and mutations, and delivers consistent migrations so your Drizzle + Neon Postgres data layer stays reliable as it evolves.
lib/db/schema/*.ts and generate $inferSelect/$inferInsert types instead of duplicating interfaces....auditFields, prefer soft delete with deletedAt, and keep timestamps in UTC with withTimezone: true.with relations.Use case example: creating a new domain entity (e.g., an order) with related rows (e.g., order tags) while recording audit fields, ensuring atomicity through db.transaction(), and generating a migration safely from schema changes.
Update your entity schema in lib/db/schema/*.ts, then generate and apply the migration using the Drizzle commands recommended by this skill while following the audit fields, timezone, transaction, and anti-N+1 rules.
High-intent search queries and answers about installing and using this skill.
You generate safe Drizzle ORM migrations by updating entity schemas in `lib/db/schema/*.ts` and running Drizzle commands to apply changes while enforcing audit fields, timezone, transaction, and anti-N+1 rules.
You derive TypeScript types from a Drizzle schema by defining a single source of truth in `lib/db/schema/*.ts` and generating `$inferSelect` and `$inferInsert` types instead of duplicating interfaces manually.
The best way to handle multi-step database writes in Drizzle is to use `db.transaction()` for multi-write workflows, ensuring atomicity and preventing partial data updates if an operation fails midway.
You implement soft delete and audit fields in a Drizzle Postgres schema by spreading `...auditFields` for traceability, using `deletedAt` for soft deletes, and keeping timestamps in UTC with `withTimezone: true`.
Yes, this database schema approach works with Neon Postgres, standardizing how Drizzle ORM executes safe database reads and writes specifically against the Neon Postgres data layer as it evolves.
You avoid N+1 queries when using Drizzle ORM by utilizing joins or Drizzle `with` relations to fetch related rows efficiently, adhering to performance guardrails without relying on unsafe raw SQL for user inputs.
act70255Optimize Neon Postgres performance with PgBouncer connection pooling and Prisma/Drizzle integration.
PlazaCCGenerate and apply Drizzle ORM migration scripts for Supabase Postgres.
findinfinitelabsBuild a Flask API backend with authentication, database integration, and deployment patterns.
johinsDevBuild type-safe SQL schemas and queries in TypeScript with Drizzle ORM.