Database Schema Reviewer

Identify normalization, indexing, naming, and scalability issues in database schemas.

9|1|Updated Mar 15, 2026
One-click install
npx skills add https://github.com/Notysoty/openagentskills --skill database-schema-reviewer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Database Schema Reviewer
Source: https://github.com/Notysoty/openagentskills/tree/main/skills/database-schema-reviewer
Command: npx skills add https://github.com/Notysoty/openagentskills --skill database-schema-reviewer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

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.

Core Features & Use Cases

  • Checks normalization levels (1NF/2NF/3NF) and flags anomalies, missing constraints, or transitive dependencies.
  • Recommends indexing strategies and constraint improvements to improve integrity and query performance.
  • Use cases include code reviews of migrations, auditing schemas during growth, and ensuring scalable designs before production.

Quick Start

Share your database schema (SQL DDL, ORM model, or plain description) and ask the skill to review it for normalization, indexing, and naming issues.

Frequently Asked Questions about Database Schema Reviewer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I review a database schema for normalization and indexing issues?

To review a database schema for normalization and indexing issues, provide your SQL DDL, ORM model, or plain description to generate a prioritized list of problems with concrete SQL or ORM fixes. It checks 1NF/2NF/3NF, missing foreign keys, and indexing strategies.

Can I audit ORM models like Prisma or Drizzle for missing constraints?

Yes, you can audit ORM models like Prisma, Drizzle, SQLAlchemy, and ActiveRecord for missing constraints. The review identifies missing foreign keys and nullable columns, returning actionable remediation guidance and specific ORM fixes to improve data integrity.

What is the best way to check database naming conventions and scalability?

The best way to check database naming conventions and scalability is to audit the schema design before production. This process flags inconsistent naming and scalability bottlenecks, providing a prioritized list of issues with concrete fixes for robust growth.

How do I fix transitive dependencies and normalization anomalies in SQL?

To fix transitive dependencies and normalization anomalies in SQL, analyze your schema against 1NF/2NF/3NF standards. The review flags these anomalies and returns concrete SQL fixes to restructure tables and enforce constraints for better data integrity.

Does database schema review work with plain text descriptions of my tables?

Yes, database schema review works with plain text descriptions of your tables. You can share a plain description instead of SQL DDL or ORM models, and it will still return a prioritized list of normalization, indexing, and naming issues with actionable guidance.