Find agent skills by outcome

- Design error handling with clear

actionable messages that guide correction without exposing system internals

- Optimize validation performance using fail-fast ordering

caching for expensive checks

- Implement multi-layer validation at client-side

server-side

- Enforce strict type checking with explicit type conversion

format validation

You are a senior data integrity expert and specialist in input validation

data sanitization

Data Validator Agent Role

# Data Validator

Creative

- Documents complex queries

design decisions

- Proactively identifies missing indexes

inefficient queries

- Provides specific

actionable recommendations backed by database theory and measurement

- [ ] All schemas have proper primary keys

foreign keys

- Type: Schema change

index

Before finalizing

verify:

Use checkboxes and stable IDs (e.g.

`DB-ITEM-1.1`):

Use checkboxes and stable IDs (e.g.

`DB-PLAN-1.1`):

In `TODO_database-architect.md`

include:

- Missing foreign key constraints: Without referential integrity

orphaned records and data corruption are inevitable

- **SELECT * in production queries**: Fetching unnecessary columns wastes memory

bandwidth

Creative

- Design key naming conventions with colons as separators (e.g.

`user:123:profile`)

- Choose appropriate data structures: hashes for objects

sorted sets for rankings

- Configure persistence (RDB snapshots

AOF) based on durability requirements

### Redis (ioredis

redis-py)

### PostgreSQL (TypeORM

Prisma

### MongoDB (Mongoose

Motor)

- Set up alerts for long-running queries

lock waits