Skills
.Work. You
Rest

db-referential-integrity

Community

Ensure foreign-key integrity in databases

Software Engineering#performance#database#audit#integrity#foreign key
AuthorHainrixz
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill audits foreign-key integrity in databases, identifying missing foreign keys, unsafe delete/update actions, reference cycles, and composite-FK mismatches.

Core Features & Use Cases

  • Foreign Key Integrity Audit: Checks for missing foreign keys, unsafe ON DELETE/ON UPDATE actions, reference cycles, and composite-FK mismatches.
  • Integrity on Design: Ensures that the database schema is designed with proper foreign key constraints.
  • Performance on Performance & Scale: Analyzes the impact of foreign key constraints on query performance and scale.
  • Use Case: For a database schema, use this Skill to ensure that all foreign keys are correctly defined and that the database can handle the intended operations without data integrity issues.

Quick Start

Run the db-referential-integrity skill to audit foreign-key integrity in your database.

Dependency Matrix

Required Modules

None required

Components

scripts

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: db-referential-integrity
Download link: https://github.com/Hainrixz/claude-db/archive/main.zip#db-referential-integrity

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.