Standardize Drizzle ORM and Postgres database modeling with portable schemas and queries.
npx skills add https://github.com/TimeKast/AgendaInteligente --skill kb-db
Please help me install this Agent Skill. Skill: kb-db Source: https://github.com/TimeKast/AgendaInteligente/tree/main/.claude/skills/kb-db Command: npx skills add https://github.com/TimeKast/AgendaInteligente --skill kb-db
It prevents slow, incorrect, and non-portable database implementations by providing a repeatable Drizzle ORM + Postgres blueprint for schemas, queries, mutations, transactions, indexes, pagination, and performance checks.
$inferSelect/$inferInsert, snake_case DB columns, camelCase TS properties, and domain-based schema files.human_id generation.EXPLAIN ANALYZE before optimizing.Use kb-db to implement or review a Drizzle ORM schema and queries for a Postgres-backed feature, ensuring timezone-aware timestamps, safe soft-delete reads, correct relations, and performance-validated indexing.
High-intent search queries and answers about installing and using this skill.
Avoid N+1 queries in Drizzle ORM by using relation-based joins and parameterized query construction to fetch associated data efficiently and prevent performance regressions.
Safe soft delete and audit column implementation in a Postgres schema requires enforcing timezone-aware timestamp columns and consistent transaction usage to maintain data correctness and prevent accidental hard deletes.
Postgres index tuning requires selecting appropriate index types and ordering composite columns by query shape, validated through EXPLAIN ANALYZE before applying optimizations to prevent slow queries.
Yes, the Drizzle ORM schema design is portable and applies to any project using Neon or self-hosted Postgres, enforcing canonical shapes and safe typing.
Drizzle ORM TypeScript type mismatches occur when schemas lack $inferSelect and $inferInsert typing alongside snake_case database columns and camelCase TypeScript properties.
andrelandgrafAutomate Better Auth setup with Drizzle ORM and Neon Postgres.
lagarcessOptimize Supabase Postgres queries and schemas with SQL rewrites and EXPLAIN-based diagnosis.
lobehubDefine TypeScript database schemas and generate migrations with Drizzle ORM.
hiroto0701Optimize Prisma ORM schemas, migrations, and queries across SQL databases.