db-check

SkillDatabases & data

Validate database schema integrity and check for common issues

Available today. Use it from your connected AI after setup.

No other account needed.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the db-check skill

What this skill tells your AI

The instructions your AI receives, as published by faizkhairi/claude-code-blueprint in skills/db-check/SKILL.md and read by ahel’s review.

Database health check for the current project:

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
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)
Check for missing indexes on foreign keys and frequently queried columns
Scan services for N+1 query patterns (missing eager loading / includes in queries)
Verify undefined vs null usage in all ORM create/update operations
Check raw SQL queries for injection vulnerabilities (parameterized queries required)
Verify referential integrity (cascade rules, orphan prevention)
Check for date handling issues (check CLAUDE.md for system-specific date formats)
Review migration history for risky operations

Report findings with severity: CRITICAL / HIGH / MEDIUM / LOW.

Advanced