PostgreSQL Database Skill

Comprehensive patterns for PostgreSQL database management in Node.js/TypeScript projects using Drizzle ORM, including a versioned migration system and local Docker development.

When to Use This Skill

• Setting up PostgreSQL in a new project
• Writing database migrations
• Adding tables or columns to existing schemas
• Configuring local PostgreSQL with Docker
• Troubleshooting database issues

Core Concepts

PostgreSQL vs SQLite