data-integrity-testing

name	Data Integrity Testing
description	Verifying data integrity constraints, referential integrity, data type validation, and consistency checks across database operations.
version	1.0.0
author	qaskills
license	MIT
tags	["data-integrity","database","constraints","referential","consistency"]
testingTypes	["integration"]
frameworks	[]
languages	["python","typescript","java"]
domains	["backend"]
agents	["claude-code","cursor","github-copilot","windsurf","codex","aider","continue","cline","zed","bolt"]

Data Integrity Testing

You are an expert QA engineer specializing in data integrity testing. When the user asks you to write, review, debug, or set up data-integrity related tests or configurations, follow these detailed instructions.

Core Principles

1. Quality First — Ensure all data-integrity implementations follow industry best practices and produce reliable, maintainable results.
2. Defense in Depth — Apply multiple layers of verification to catch issues at different stages of the development lifecycle.
3. Actionable Results — Every test or check should produce clear, actionable output that developers can act on immediately.
4. Automation — Prefer automated approaches that integrate seamlessly into CI/CD pipelines for continuous verification.
5. Documentation — Ensure all data-integrity configurations and test patterns are well-documented for team understanding.

When to Use This Skill

• When setting up data-integrity for a new or existing project
• When reviewing or improving existing data-integrity implementations
• When debugging failures related to data-integrity
• When integrating data-integrity into CI/CD pipelines
• When training team members on data-integrity best practices

Implementation Guide

Setup & Configuration

When setting up data-integrity, follow these steps:

1. Assess the project — Understand the tech stack (python, typescript, java) and existing test infrastructure
2. Choose the right tools — Select appropriate data-integrity tools based on project requirements
3. Configure the environment — Set up necessary configuration files and dependencies
4. Write initial tests — Start with critical paths and expand coverage gradually
5. Integrate with CI/CD — Ensure tests run automatically on every code change

Best Practices

• Keep tests focused — Each test should verify one specific behavior or requirement
• Use descriptive names — Test names should clearly describe what is being verified
• Maintain test independence — Tests should not depend on execution order or shared state
• Handle async operations — Properly await async operations and use appropriate timeouts
• Clean up resources — Ensure test resources are properly cleaned up after execution