# Sqlite Test Validator

> Test and validate SQLite database migrations and schema changes Use when this capability is needed.

- Skill: `tomevault-io/sqlite-test-validator` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add tomevault-io/sqlite-test-validator`
- Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/sqlite-test-validator/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: tomevault-io (https://skillmd.com/u/tomevault-io)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/tomevault-io/sqlite-test-validator

---


# 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
```bash
# 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)

---
> Converted and distributed by [TomeVault](https://tomevault.io/claim/paleoterra) — claim your Tome and manage your conversions.
<!-- tomevault:4.0:skill_md:2026-04-13 -->