skills.rest
danny0926
danny0926COMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-health-check

Diagnose data quality issues in local SQLite databases and output a health score.

Updated Feb 27, 2026
Search Tags:#data integrity#data quality#sqlite#health check#deduplication#database health#orphan records
One-click install
npx skills add https://github.com/danny0926/NLP-data-for-trading --skill db-health-check
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-health-check
Source: https://github.com/danny0926/NLP-data-for-trading/tree/main/.claude/skills/db-health-check
Command: npx skills add https://github.com/danny0926/NLP-data-for-trading --skill db-health-check

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

深度資料庫健康檢查，驗證資料品質、新鮮度、一致性。當使用者想檢查系統狀態、 資料是否正常、有無異常時使用。觸發詞: 資料健康, db health, 資料品質, data quality, health check, 資料檢查, 資料庫狀態, 系統狀態, 資料診断

Core Features & Use Cases

  • 進行全面的資料庫健康檢查，涵蓋 row counts、資料新鮮度、NULL 率、孤立紀錄、重複偵測與表間一致性。
  • 適用於本地部署的 SQLite 資料庫與資料管道，產出健康分數與問題清單，便於排錯與監控。
  • Use Case: 當資料品質或一致性成為風險來源時， 即時檢查並產出修復建議。

Quick Start

Run the health check against the SQLite database at data/data.db to generate a health report.

Frequently Asked Questions about db-health-check

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

FAQPage Schema
How do I run a SQLite health check to verify data quality and consistency?▼

A SQLite health check evaluates row counts, data freshness, NULL rates, duplicates, orphan records, and cross-table integrity. It outputs a summarized health score and actionable remediation guidance for identified issues.

What specific data quality issues can I diagnose in a local SQLite database?▼

You can diagnose NULL rates, duplicate records, orphan records, and cross-table integrity issues. The health check evaluates these metrics to produce a comprehensive health score and a detailed issue list for remediation.

Does this database health check work with any SQLite deployment or only specific data pipelines?▼

This database health check applies specifically to local SQLite deployments and data pipelines storing data in data/data.db. It targets local environments to verify database health, consistency, and data quality.

How do I identify orphan records and duplicates when checking database health?▼

Apply the database health check to your SQLite database to identify orphan records and duplicates. The process scans for cross-table integrity violations and redundant rows, summarizing them in an actionable issue list.

What is the best way to monitor data freshness and consistency in a SQLite database?▼

Perform a comprehensive database health check to monitor data freshness and consistency. This process evaluates timestamps and cross-table integrity to ensure local SQLite data remains fresh and consistent.

Related Skills

Explore More Data & Analytics Skills→
pinion05pinion05
3

browsing-history

Query and summarize Chrome history from a local SQLite database.

Community
Intermediate
heximaoheximao

transaction-verification

Validate transaction record filenames, YAML frontmatter, and trade value calculations.

Community
Advanced
timequitytimequity
6

data-quality

Detect data quality issues in dbt and Great Expectations pipelines.

Official
Advanced
clawpod-appclawpod-app
46

explore-data

Profile datasets to assess shape, quality, and patterns.

Community
Intermediate