postgres-drizzle

What problem does it solve?

This Skill provides best practices and guidance for efficiently working with PostgreSQL databases using the Drizzle ORM, helping developers write type-safe, performant, and maintainable database code.

Core Features & Use Cases

• Schema Design: Learn patterns for defining tables, columns, relations, and constraints.
• Querying: Master efficient data retrieval using Drizzle's SQL-like and relational query APIs.
• Migrations: Understand the workflow for managing database schema changes with drizzle-kit.
• Performance Tuning: Optimize queries, indexing, and PostgreSQL configuration.
• Use Case: When building a new API endpoint that requires fetching user data along with their associated posts, use this Skill to learn how to define the relations and write a single, efficient query to retrieve both nested data structures.

Quick Start

Use the postgres-drizzle skill to generate a SQL migration file for a new table definition.