referential_integrity_check
OfficialEnsure data consistency with reference integrity checks.
Data & Analytics#database management#data validation#data consistency#reference integrity#foreign key
Authorcas-bigdatalab
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill solves the issue of inconsistent data by checking if foreign key values exist in the referenced key set, identifying orphaned records and outputting results.
Core Features & Use Cases
- Check Foreign Key Values: Ensures that values in the foreign key column exist in the referenced key set.
- Identify Orphaned Records: Flags records that are not linked to the referenced table.
- Output Results: Provides a result file with marked inconsistent records.
- Use Case: Ideal for data validation in relational databases, ensuring the integrity of data relationships.
Quick Start
Run the referential_integrity_check skill to validate the foreign key values in 'sales_data.csv' against 'customer_data.csv'.
Dependency Matrix
Required Modules
pandas
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: referential_integrity_check Download link: https://github.com/cas-bigdatalab/piflow/archive/main.zip#referential-integrity-check Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.