multiAI Summary Pending
db-handler
Manage database schemas, Drizzle ORM, migrations, and data modeling. Use when creating tables, modifying columns, or planning database changes.
231 stars
Installation
Claude Code / Cursor / Codex
$curl -o ~/.claude/skills/db-handler/SKILL.md --create-dirs "https://raw.githubusercontent.com/aiskillstore/marketplace/main/skills/aayushbaniya2006/db-handler/SKILL.md"
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/db-handler/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How db-handler Compares
| Feature / Agent | db-handler | Standard Approach |
|---|---|---|
| Platform Support | multi | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Manage database schemas, Drizzle ORM, migrations, and data modeling. Use when creating tables, modifying columns, or planning database changes.
Which AI agents support this skill?
This skill is compatible with multi.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# Database Handler
## Instructions
### 1. Creating a New Table
1. **Draft**: Create the `pgTable` definition in `src/db/schema/{domain}.ts`.
2. **Columns**: Add ID (UUID), timestamps, and data columns.
- **Mandatory**: Use Zod schema for any JSONB columns.
3. **Relations**: Define `relations` and Foreign Keys.
4. **Verification**: Ask the user: "Is this structure correct? Are there any missing relations?"
5. **Migration**:
- **DO NOT** generate migration files (e.g., `drizzle-kit generate`).
- **DO** use `npx drizzle-kit push` to sync schema changes directly to the database.
### 2. Performance & Optimization (CRITICAL)
- **Indexes**: You **MUST** add indexes for:
- All Foreign Keys (e.g., `userId`, `planId`).
- Columns frequently used in `WHERE` clauses (e.g., `status`, `email`).
- Columns used for sorting (e.g., `createdAt`).
- **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](reference.md).