skills.rest
aliepratama
aliepratamaCOMMUNITY
Explore all skills by this author →
GitHub

drizzle-best-practices

Define Drizzle ORM schemas, queries, relations, and migrations for PostgreSQL.

Updated Apr 16, 2026
Search Tags:#database#postgresql#drizzle#schema#migration#orm#query
One-click install
npx skills add https://github.com/aliepratama/ecofin --skill drizzle-best-practices-aliepratama
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: drizzle-best-practices
Source: https://github.com/aliepratama/ecofin/tree/main/.agents/skills/drizzle-best-practices
Command: npx skills add https://github.com/aliepratama/ecofin --skill drizzle-best-practices-aliepratama

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill provides comprehensive best practices for using Drizzle ORM with PostgreSQL, helping developers write correct, efficient, and maintainable database code.

Core Features & Use Cases

  • Schema Design: Guidance on defining tables, indexes, and constraints for robust schemas.
  • Query Optimization: Techniques for building performant select, insert, update, and delete queries.
  • Relations & Joins: Best practices for defining and querying table relationships without manual joins.
  • Migrations & Versioning: Instructions for managing schema changes safely using drizzle-kit.
  • Type Safety & Inference: Strategies for leveraging TypeScript to ensure data consistency and prevent errors.
  • Advanced Features: Handling JSONB, arrays, enums, full-text search, and custom types in PostgreSQL with Drizzle.

Quick Start

Use the Drizzle ORM best practices to define your schema, write queries, and structure migrations for PostgreSQL.

Frequently Asked Questions about drizzle-best-practices

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define relations and query joins in Drizzle ORM without manual SQL?▼

To define relations in Drizzle ORM, you use the relations() function to map table connections, enabling the query builder to automatically construct and execute joins without writing manual SQL join clauses.

What is the best way to manage PostgreSQL schema migrations using drizzle-kit?▼

Managing PostgreSQL schema migrations with drizzle-kit involves generating versioned SQL migration files from your schema definitions and applying them safely to ensure structured database versioning without data loss.

How do I ensure type safety and inference for PostgreSQL queries in Drizzle ORM?▼

Type safety in Drizzle ORM is ensured by inferring TypeScript types directly from your PostgreSQL schema definitions, which guarantees data consistency and prevents type errors during select, insert, update, and delete queries.

Can I handle advanced PostgreSQL features like JSONB and full-text search with Drizzle ORM?▼

Yes, Drizzle ORM supports advanced PostgreSQL features including JSONB, arrays, enums, and full-text search, providing specialized query patterns and schema definitions to handle these custom data types efficiently.

Does Drizzle ORM work with complex PostgreSQL schema constraints and indexes?▼

Yes, Drizzle ORM works with complex PostgreSQL schema constraints and indexes by providing a structured framework to define robust schemas, ensuring database integrity and improving query performance optimization.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
openmeterioopenmeterio
2.2k

db-migration

Generate SQL migrations for ent framework schema changes on PostgreSQL.

Official
Intermediate
djankiesdjankies

configuring-connection-pools

Configure Prisma Client connection pools for PostgreSQL deployments.

Community
Advanced
flybirdxxflybirdxx

prisma-expert

Diagnose and resolve Prisma ORM schema, migration, and query issues.

Community
Advanced