database-changes

What problem does it solve?

This Skill simplifies and standardizes the process of making database schema changes in the IdeaForge backend, ensuring consistency, preventing errors, and accelerating development.

Core Features & Use Cases

• Migration Creation: Generate new SQL migration files with sequential numbering and idempotent patterns.
• Schema Modification: Easily add tables, columns, modify column types, and create indexes.
• Specialized Column Types: Implement JSONB for flexible, evolving data structures and pgvector for advanced semantic search capabilities.
• Use Case: "Add a new JSONB column named user_settings to the users table to store flexible user preferences without requiring a new migration for every small change, then update the TypeScript types."

Quick Start

Use the database-changes skill to create a new migration that adds a status column of type VARCHAR(50) to the ideas table.