feat: add data validation tool for database quality checks #33

New issue

Open

opened 2026-02-21 01:03:21 +00:00 by Clotho · 0 comments

Clotho commented

2026-02-21 01:03:21 +00:00

Member

Summary

Agents need to verify data quality before relying on query results. A dedicated validation tool would check for common data quality issues.

Features

`validate_data` tool

Check for NULL values in specified columns
Detect duplicate rows
Validate foreign key integrity
Check value ranges (e.g. all prices > 0)
Report orphaned records
Generate a data quality score

Files

src/Mcp/Tools/Validation/ValidateData.php (new)
src/Mcp/Services/DataValidationService.php (new)

Notes

Also noted in TODO.md under Medium Priority. Estimated effort: 4-5 hours.

## Summary Agents need to verify data quality before relying on query results. A dedicated validation tool would check for common data quality issues. ## Features ### `validate_data` tool - Check for NULL values in specified columns - Detect duplicate rows - Validate foreign key integrity - Check value ranges (e.g. all prices > 0) - Report orphaned records - Generate a data quality score ## Files - `src/Mcp/Tools/Validation/ValidateData.php` (new) - `src/Mcp/Services/DataValidationService.php` (new) ## Notes Also noted in TODO.md under Medium Priority. Estimated effort: 4-5 hours.