database-operations

What problem does it solve?

This Skill helps you manage Neon PostgreSQL migrations, Drizzle ORM schema design, and query optimization, reducing manual DB toil and risk.

Core Features & Use Cases

• Migration rules: Idempotent migrations, enum existence checks with conditional blocks, and safe index creation.
• Schema design: Drizzle ORM schema definitions and migration planning.
• Migration execution: Apply migrations with predictable results and quick rollback planning.
• Use Case: When evolving the course catalog, create migration scripts to add new tables and indices and verify integrity with a local Neon instance.

Quick Start

Run the initial Neon connection test and push the first migration to establish the core schema; review with Drizzle Studio.