# Db Check

> Validate database schema integrity and check for common issues

- **Type:** Skill
- **Install:** `agentstack add skill-faizkhairi-claude-code-blueprint-db-check`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [faizkhairi](https://agentstack.voostack.com/s/faizkhairi)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [faizkhairi](https://github.com/faizkhairi)
- **Source:** https://github.com/faizkhairi/claude-code-blueprint/tree/main/skills/db-check
- **Website:** https://github.com/faizkhairi/claude-code-blueprint#readme

## Install

```sh
agentstack add skill-faizkhairi-claude-code-blueprint-db-check
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

Database health check for the current project:

1. Read the ORM schema file (e.g., `prisma/schema.prisma`, `drizzle/schema.ts`, or equivalent) and analyze all models
2. **CRITICAL**: Check all database tables have ORM models (unmodeled tables may be dropped on schema sync)
3. Check for missing indexes on foreign keys and frequently queried columns
4. Scan services for N+1 query patterns (missing eager loading / includes in queries)
5. Verify `undefined` vs `null` usage in all ORM create/update operations
6. Check raw SQL queries for injection vulnerabilities (parameterized queries required)
7. Verify referential integrity (cascade rules, orphan prevention)
8. Check for date handling issues (check CLAUDE.md for system-specific date formats)
9. Review migration history for risky operations

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

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [faizkhairi](https://github.com/faizkhairi)
- **Source:** [faizkhairi/claude-code-blueprint](https://github.com/faizkhairi/claude-code-blueprint)
- **License:** MIT
- **Homepage:** https://github.com/faizkhairi/claude-code-blueprint#readme

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-faizkhairi-claude-code-blueprint-db-check
- Seller: https://agentstack.voostack.com/s/faizkhairi
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.