Database Health Skill
CommunityMonitor database health, verify data ingestion.
Data & Analytics#monitoring#database#data verification#MySQL#health check#data ingestion#sports data
Authorfstr21
Version1.0.0
Installs0
System Documentation
What problem does it solve?
It's challenging to quickly verify if data has been successfully ingested into the database or to assess the overall health and consistency of your data warehouse. This Skill provides a comprehensive overview, ensuring data reliability.
Core Features & Use Cases
- Data Count Verification: Checks game, player, and team counts by sport to confirm data presence and identify discrepancies.
- Recent Ingestion Tracking: Shows what data was added in the last 24 hours, confirming pipeline success and recent activity.
- Quality Issue Detection: Summarizes recent data quality issues from the
data_quality_logtable, highlighting potential problems. - Use Case: After a pipeline run, use this Skill to confirm that all expected data was ingested, check for missing records, or get a quick overview of your database's current state.
Quick Start
Check overall database health
python .claude/skills/db-health/scripts/check_db.py
Verify NFL data ingestion for a specific date
python .claude/skills/db-health/scripts/check_db.py --sport nfl --date 2025-10-23
Dependency Matrix
Required Modules
mysql-connector-pythonrichpython-dotenv
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: Database Health Skill Download link: https://github.com/fstr21/sportsbot/archive/main.zip#database-health-skill Please download this .zip file, extract it, and install it in the .claude/skills/ directory.