skills.rest
fstr21
fstr21COMMUNITY
Explore all skills by this author →
GitHub

Database Health Skill

Monitor MySQL database ingestion and verify sports data counts.

Updated Aug 27, 2026
Search Tags:#monitoring#database#data verification#MySQL#health check#data ingestion#sports data
One-click install
npx skills add https://github.com/fstr21/sportsbot --skill database-health-skill
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Health Skill
Source: https://github.com/fstr21/sportsbot/tree/main/.claude/skills/db-health
Command: npx skills add https://github.com/fstr21/sportsbot --skill database-health-skill

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires mysql-connector-python, rich, python-dotenv, and includes scripts (resource) components.

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_log table, 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

Frequently Asked Questions about Database Health Skill

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I verify data was ingested into my MySQL database after a pipeline run?▼

Data verification checks game, player, and team counts by sport to confirm successful ingestion. This Skill queries your MySQL database using credentials from .env.local and displays structured table outputs showing what data is present and any discrepancies.

Can I check recent database ingestion for a specific sport or date?▼

Yes, you can monitor recent ingestion by sport and date. The Skill tracks data added in the last 24 hours and accepts optional --sport and --date parameters to filter results for specific sports or dates, confirming pipeline success for targeted timeframes.

How do I detect data quality issues in my database?▼

Data quality issue detection summarizes recent problems from the data_quality_log table, highlighting missing or orphaned records. The Skill returns plain-English explanations with ET timezone display to help you quickly identify and address data reliability problems.

What database monitoring approach works for sports data pipelines?▼

Sports data pipeline monitoring combines count verification for games, players, and teams with recent ingestion tracking and quality issue detection. This comprehensive approach ensures your data warehouse remains consistent and confirms each pipeline run succeeded.

Do I need Python and MySQL connector to use this monitoring Skill?▼

Yes, this Skill requires Python with mysql-connector-python, rich for table formatting, and python-dotenv for credential management. You also need read-only database credentials stored in .env.local to connect and monitor your MySQL database.

Related Skills

Explore More Data & Analytics Skills→
knishiokaknishioka
7

daily-report-generator

Generate daily and weekly reports from Git commit logs and calendar data.

Community
Intermediate
nahisahonahisaho
69

slo-sli-guide

Define SLIs and SLOs with monitoring, alerting, and incident-response runbooks.

Community
Advanced
dlt-hubdlt-hub
53

view-data

Query and explore dlt pipeline data using Python and ibis expressions.

Official
Intermediate
Prorise-coolProrise-cool
24

data-specialist

Design databases and build ETL pipelines using SQL, Spark, Airflow, and Kafka.

Community
Advanced