aiskillstore/marketplace / skills/aayushbaniya2006/db-handler
db-handler
VerifiedManage database schemas, Drizzle ORM, migrations, and data modeling. Use when creating tables, modifying columns, or planning database changes.
Database Handler
Instructions
1. Creating a New Table
- Draft: Create the
pgTabledefinition insrc/db/schema/{domain}.ts. - Columns: Add ID (UUID), timestamps, and data columns.
- Mandatory: Use Zod schema for any JSONB columns.
- Relations: Define
relationsand Foreign Keys. - Verification: Ask the user: "Is this structure correct? Are there any missing relations?"
- Migration:
- DO NOT generate migration files (e.g.,
drizzle-kit generate). - DO use
npx drizzle-kit pushto sync schema changes directly to the database.
- DO NOT generate migration files (e.g.,
2. Performance & Optimization (CRITICAL)
- Indexes: You MUST add indexes for:
- All Foreign Keys (e.g.,
userId,planId). - Columns frequently used in
WHEREclauses (e.g.,status,email). - Columns used for sorting (e.g.,
createdAt).
- All Foreign Keys (e.g.,
- N+1 Prevention:
- NEVER allow fetching data inside a loop.
- Use Drizzle's Relational Query API (
with: { ... }) or explicit.leftJoin()to fetch related data in a single query.
3. Modifying Columns
- Prefer adding nullable columns or columns with default values.
- Avoid breaking changes without explicit confirmation.
4. Types & Enums
- Enums: Export as constants (
export const roleEnum = ...). - Types: Do NOT export inferred types. Let consumers infer them.
Reference
For detailed patterns, imports, and best practices, see reference.md.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |