db-check
starsforks
How to install db-check?
faizkhairi/claude-code-blueprint/db-check
$npx -y skills add faizkhairi/claude-code-blueprint --skill db-checkValidate database schema integrity and check for common issues
SKILL.md
| 1 | Database health check for the current project: |
| 2 | |
| 3 | 1. Read the ORM schema file (e.g., `prisma/schema.prisma`, `drizzle/schema.ts`, SQLAlchemy models, ActiveRecord schema, Entity Framework DbContext, GORM structs, or equivalent) and analyze all models |
| 4 | 2. **CRITICAL**: Check all database tables have ORM models (unmodeled tables may be dropped on schema sync, e.g. Prisma db push; know whether your ORM's sync command is destructive) |
| 5 | 3. Check for missing indexes on foreign keys and frequently queried columns |
| 6 | 4. Scan services for N+1 query patterns (missing eager loading / includes in queries) |
| 7 | 5. Verify `undefined` vs `null` usage in all ORM create/update operations |
| 8 | 6. Check raw SQL queries for injection vulnerabilities (parameterized queries required) |
| 9 | 7. Verify referential integrity (cascade rules, orphan prevention) |
| 10 | 8. Check for date handling issues (check CLAUDE.md for system-specific date formats) |
| 11 | 9. Review migration history for risky operations |
| 12 | |
| 13 | Report findings with severity: CRITICAL / HIGH / MEDIUM / LOW. |
People who liked this also viewed
6 picksType
- azure-storageAzure Storage Services including Blob Storage, File Shares, Queue Storage, Table Storage, and Data Lake. Answers questions about storage access tiers (hot, cool, cold, archive), when to use each tier,SkillsJul 2026
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.SkillsJul 2026
- supabaseUse when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge Functions, Realtime, Storage, Vectors, Cron, Queues); client libraries and SSR integrations (supabase-js, SkillsJul 2026
- convex-quickstartCreates or adds Convex to an app. Use for new Convex projects, npm create convex@latest, frontend setup, env vars, or the first npx convex dev run.SkillsJul 2026
- convex-performance-auditAudits Convex performance for reads, subscriptions, write contention, and function limits. Use for slow features, insights findings, OCC conflicts, or read amplification.SkillsJul 2026
- convex-setup-authSets up Convex auth, identity mapping, and access control. Use for login, auth providers, users tables, protected functions, or roles in a Convex app.SkillsJul 2026
