Database Schema Reviewer

What this skill does

This skill directs the agent to review a database schema — provided as SQL DDL, an ORM model file (Drizzle, Prisma, SQLAlchemy, ActiveRecord, etc.), or a plain description — and produce a prioritized list of issues. It checks normalization, indexes, constraints, naming conventions, nullable columns, and overall scalability. Every issue includes a concrete SQL or ORM fix.

Use this before deploying a new schema to production, during code review of a migration file, or when a database is growing and you're starting to feel query pain.

How to use

Claude Code / Cline

Copy this file to .agents/skills/database-schema-reviewer/SKILL.md in your project root.

Then share your schema and ask:

• "Use the Database Schema Reviewer skill on shared/schema.ts."
• "Review this SQL migration file for schema issues using the Database Schema Reviewer skill."

Provide the full schema file, a SQL DDL dump, or paste the relevant CREATE TABLE statements.