---

name: database-management description: Handles database schema design, Drizzle ORM queries, and Expo SQLite migrations.

Database Management Skill

This skill provides instructions for managing the SQLite database using Drizzle ORM within an Expo environment.

🗄️ Core Responsibilities

• Schema Design: Define tables, relationships, and constraints in src/db/schema.ts.
• Migrations: Generate and apply migrations using drizzle-kit.
• Query Optimization: Write efficient queries for fetching payments, transactions, and installments.
• Data Integrity: Ensure cascade deletes and updates are handled correctly (e.g., deleting a payment should handle linked transactions).

🛠️ Tools & Patterns

Drizzle ORM Usage

Always use the db client from src/db/client.ts.

Copyimport { db } from '~/db/client';
import { payments } from '~/db/schema';

Async Operations

Always wrap database calls in try/catch blocks and handle loading/error states in the UI.

Period Calculations

When querying by month, use the period_key (YYYY-MM) format as defined in the data model.

⚠️ Safety Rules

1. Never delete data without user confirmation or a clear logical reason.
2. Always check for existing records before insertion if uniqueness is required.
3. Draft migrations before applying them to ensure no data loss occurs.