Does this skill help with data pipeline failures?

Yes, it implements circuit breakers and idempotent upserts to prevent data corruption or duplication during batch updates and source failures.

How does it manage cache correctness?

The skill mandates that 'use cache' functions must throw errors on failed results to prevent caching nulls, and uses rotated cache tags to clear stale data.

What is the difference between BIGINT and NUMERIC in this skill?

It prescribes BIGINT for whole units like share counts and dollar amounts at ingestion, while using NUMERIC for ratios, percentages, and fractional per-share values to maintain precision.

How does this skill handle null or NaN values in the UI?

It enforces strict null-guarding rules, requiring fallback values like '-' and specialized formatters such as formatDollar to ensure invalid data never reaches the frontend.

Data Integrity & Financial Accuracy

Name: Data Integrity & Financial Accuracy
Author: Undercurrent-Studio

byUndercurrent-Studio

0•

数据库管理

Enforces strict accuracy and traceability standards for data display, transformation, and storage within financial applications.

The Data Integrity skill provides a comprehensive framework for maintaining data reliability across the entire application lifecycle, specifically tailored for financial and metric-heavy environments. It implements ten core rules covering source traceability, null-safe formatting, and type-specific storage discipline (BIGINT vs. NUMERIC) to ensure every number is auditable and precise. This skill is essential for developers building data-intensive tools, as it automates best practices for idempotent pipelines, cache correctness, and graceful degradation during source failures.

主要功能

01Circuit breaker logic and idempotent upsert patterns for pipelines

02Tier-based data gating and cache-busting for stale errors

030 GitHub stars

04Financial-grade type discipline for BIGINT and NUMERIC values

05Null-safe formatting and fallback handling for currency and metrics

06Strict source-to-UI traceability mapping for every data point

使用场景

01Implementing reliable financial dashboards with traceable metrics

02Designing robust data ingestion pipelines that handle failures gracefully

03Debugging and fixing stale data or null value errors in the UI

主要功能

01Circuit breaker logic and idempotent upsert patterns for pipelines

02Tier-based data gating and cache-busting for stale errors

030 GitHub stars

04Financial-grade type discipline for BIGINT and NUMERIC values

05Null-safe formatting and fallback handling for currency and metrics

06Strict source-to-UI traceability mapping for every data point

使用场景

01Implementing reliable financial dashboards with traceable metrics

02Designing robust data ingestion pipelines that handle failures gracefully

03Debugging and fixing stale data or null value errors in the UI