Define schemas, run type-safe queries, and manage migrations with Drizzle ORM and Neon Postgres.
npx skills add https://github.com/echarabati/adi-capital-admin --skill db-echarabati
Please help me install this Agent Skill. Skill: db Source: https://github.com/echarabati/adi-capital-admin/tree/main/.agent/skills/domains/db Command: npx skills add https://github.com/echarabati/adi-capital-admin --skill db-echarabati
This Skill streamlines database interactions by providing clear guidelines and helpers for defining schemas, writing queries, and managing migrations, ensuring data integrity and efficient development.
users table with audit fields and create a server action to insert new users.Use the db skill to create a new user in the database with the provided email and name.
High-intent search queries and answers about installing and using this skill.
To define a database schema with audit fields and soft deletes, use Drizzle ORM to structure your tables with specific audit columns, dual IDs, enums, and relationship mappings, which ensures data integrity and clear schema boundaries.
The best way to manage type-safe queries and pagination in Postgres is by using an ORM like Drizzle to structure efficient querying patterns, including joins and transactional mutations, ensuring data consistency.
You generate and apply database migrations for a Neon Postgres schema by running dedicated workflow commands that translate your Drizzle ORM schema definitions into applied database changes.
Yes, you can use Drizzle ORM to handle relationships and enums in your Postgres database, allowing you to define structured table relations and enumerated types for strict data validation.
Database transactions work by grouping multiple insert or update mutations into a single atomic operation, ensuring that all changes apply successfully or roll back entirely to maintain data integrity.
You need to add indexes for query performance optimization in Postgres when your querying patterns involve large datasets, complex joins, or specific filtering that would benefit from faster data retrieval.
neondatabase-labsAutomates Drizzle ORM integration with Neon Postgres, including migrations and type-safe schemas.
TimeKastDefine Drizzle ORM schemas and execute safe reads and writes against Neon Postgres.
lciacciBuild Next.js App Router apps with Supabase auth and Drizzle ORM.
pascallammersGuide Neon Serverless Postgres usage for branching, pooling, optimization, and CI/CD.