skills.rest
berkcangumusisik
berkcangumusisikCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

schema-review

Review database schemas for normalization, index, and naming issues.

11|Updated Apr 16, 2026
Search Tags:#database#schema#sql#review#indexes#normalization#prisma
One-click install
npx skills add https://github.com/berkcangumusisik/claude-code-practices --skill schema-review
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: schema-review
Source: https://github.com/berkcangumusisik/claude-code-practices/tree/main/skills/schema-review
Command: npx skills add https://github.com/berkcangumusisik/claude-code-practices --skill schema-review

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill scans and highlights normalization issues, missing indexes, and naming inconsistencies across a database schema to improve data integrity and performance.

Core Features & Use Cases

  • Automated schema review: Detect denormalization, missing junction tables, and inconsistent naming across Prisma/SQL schemas.
  • Index and integrity checks: Identify foreign keys without indexes, missing NOT NULL constraints, and potential data integrity gaps.
  • Use Case: When optimizing an evolving data model, run this to produce a prioritized list of fixes with actionable recommendations.

Quick Start

Run the schema-review skill against your Prisma or SQL schema to generate a prioritized remediation plan.

Frequently Asked Questions about schema-review

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

FAQPage Schema
How do I check my database schema for normalization issues and missing indexes?▼

To check your database schema for normalization issues and missing indexes, run an automated schema review against your Prisma or SQL files to detect denormalization, missing junction tables, and unindexed foreign keys.

What problems can a database schema review identify in my SQL scripts?▼

A database schema review identifies normalization flaws, missing indexes, naming inconsistencies, and missing NOT NULL constraints in your SQL scripts to help improve overall data integrity and query performance.

Can I audit a Prisma schema for missing indexes and naming inconsistencies?▼

Yes, you can audit a Prisma schema to identify missing indexes, foreign keys without indexes, data integrity gaps, and naming convention problems, producing a prioritized list of actionable fixes.

What is the best way to find foreign keys without indexes in my database schema?▼

The best way to find foreign keys without indexes is to perform an automated integrity check on your database schema, which surfaces unindexed foreign keys and potential data integrity gaps with remediation steps.

How do I get actionable remediation steps for database naming problems and normalization errors?▼

To get actionable remediation steps for database naming problems and normalization errors, run a schema review that reports prioritized findings directly against your Prisma schemas, SQL scripts, or migration histories.

Related Skills

Explore More Software Engineering Skills→
Camilo8902Camilo8902

schema-consistency-checker

Audit database schemas for naming, type, nullability, and constraint violations.

Community
Advanced
patricio0312revpatricio0312rev
5

schema-consistency-checker

Audit relational database schemas and generate violations reports.

Community
Advanced
Veloxia-agencyVeloxia-agency

sql-database-assistant

Write and optimize SQL queries with EXPLAIN-driven performance analysis.

Community
Advanced
Friend09Friend09

python-lint-style

Check Python code for docstrings, naming conventions, and import order.

Community
Intermediate