database-operations

Automate PostgreSQL/Neon migrations and Drizzle ORM schema design tasks.

Updated Aug 27, 2026

Search Tags:#indexing #database #postgresql #migrations #neon #drizzle-orm #schema-design

Ready to run

npx skills add https://github.com/kimny1143/mued_v2 --skill database-operations

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-operations
Source: https://github.com/kimny1143/mued_v2/tree/main/.claude/skills/database
Command: npx skills add https://github.com/kimny1143/mued_v2 --skill database-operations

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @neondatabase/serverless.

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.

Frequently Asked Questions about database-operations

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

FAQPage Schema

How do I create idempotent PostgreSQL migrations for Neon?▼

Idempotent migrations use IF NOT EXISTS and conditional checks to safely re-run without errors. This Skill automates migration generation with built-in guards for enum existence, object creation, and foreign key validation, ensuring predictable results across deployments.

Can I automate schema changes and index management in Neon with Drizzle ORM?▼

Yes. This Skill generates Drizzle ORM schema definitions and executes migrations against Neon PostgreSQL, handling index creation, table additions, and constraint deployment with safety checks and quick rollback planning.

How do I optimize PostgreSQL queries and manage database performance?▼

Query optimization and index management reduce latency and resource use. This Skill automates routine maintenance tasks, index creation strategies, and schema design for Neon PostgreSQL environments to improve query performance.

What's the best way to evolve a database schema without downtime?▼

Safe schema evolution uses idempotent migrations with conditional object creation and integrity validation. This Skill generates and executes versioned migrations for Neon, enabling schema changes with predictable results and minimal risk.

Do I need Drizzle ORM to use this Skill for Neon database work?▼

Drizzle ORM integration simplifies schema definition and migration planning, but the Skill's core scope covers PostgreSQL migrations, index management, and query optimization for any Neon-hosted database workflow.