ReddRadar
Agent skill
sqlite-test-validator
Test and validate SQLite database migrations and schema changes
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/sqlite-test-validator
SKILL.md
SQLite Test Validator
Test database migrations and validate schema integrity.
Capabilities
- Test migration scripts
- Validate schema changes
- Check data integrity after migrations
- Compare database schemas
- Generate test databases
- Verify foreign key constraints
- Test triggers and indexes
- Validate data types
- Check for breaking changes
Tools
sqlite_validator.py - Test and validate databases
Commands
# Test migration
./sqlite_validator.py test-migration --from old.db --to new.db --script migrate.sql
# Compare schemas
./sqlite_validator.py compare --db1 v1.XRose --db2 v2.XRose
# Validate schema
./sqlite_validator.py validate schema.sql
# Check integrity
./sqlite_validator.py check-integrity database.XRose
Test Types
- Schema Migration - Verify DDL changes
- Data Migration - Verify data transforms
- Integrity - Check constraints/triggers
- Performance - Query performance
- Rollback - Test migration reversibility
Complementary To
database-migration-helper (generates migrations)
xrose-database-reader (reads XRose files)
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?