database-schema-reviewer

# 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. ### Cursor Add the "Prompt / Instructions" section to your `.cursorrules` file. Open your schema or migration file and ask Cursor to review it. ### Codex Paste the schema DDL or ORM model definitions into the chat along with the instructions below. Include any known query patterns if you want index recommendations tailored to your workload. ## The Prompt / Instructions for the Agent When asked to review a database schema, follow these steps: 1. **Parse the schema.** Accept...