Claude-code-blueprint db-check

Name: db-check
Author: faizkhairi

Validate database schema integrity and check for common issues

install

source · Clone the upstream repo

git clone https://github.com/faizkhairi/claude-code-blueprint

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/faizkhairi/claude-code-blueprint "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/db-check" ~/.claude/skills/faizkhairi-claude-code-blueprint-db-check && rm -rf "$T"

manifest: skills/db-check/SKILL.md

source content

Database health check for the current project:

Read the ORM schema file (e.g.,
```
prisma/schema.prisma
```
,
```
drizzle/schema.ts
```
, or equivalent) and analyze all models
CRITICAL: Check all database tables have ORM models (unmodeled tables may be dropped on schema sync)
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.