charge-test-data-generator

Generate deterministic SQL test data for billing patterns like D-01 and K-02.

Updated Aug 23, 2026

Search Tags:#automation #invoices #sql #pattern #billing #test-data #data-generation

Ready to run

npx skills add https://github.com/octkp/dotfiles --skill charge-test-data-generator

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: charge-test-data-generator
Source: https://github.com/octkp/dotfiles/tree/main/claude/skills/charge-test-data-generator
Command: npx skills add https://github.com/octkp/dotfiles --skill charge-test-data-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill generates SQL data to emulate various billing patterns for testing, enabling safe and reproducible test scenarios without touching production data.

Core Features & Use Cases

Pattern-based SQL generation for monthly and annual billing scenarios, including renewals and plan changes.
Supports test data for a wide range of billing timing and transition patterns (e.g., contract expiries, changes in charge_type, and multiple environments).
Facilitates deterministic data creation aligned with common pattern IDs (D-01, B-02, X-04, K-02) to validate downstream billing workflows.

Quick Start

Generate the test data SQL for a requested pattern (e.g., D-01 or K-02) to produce charges and invoices for verification.

Frequently Asked Questions about charge-test-data-generator

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

FAQPage Schema

How do I generate SQL test data for billing patterns like renewals and plan changes?▼

To generate SQL test data for billing patterns, specify a pattern ID such as D-01 or K-02 to produce deterministic charges and invoices simulating renewals, plan changes, and timing variations without touching production data.

What are the billing pattern IDs like D-01 and B-02 used for in test data generation?▼

Billing pattern IDs like D-01, B-02, X-04, and K-02 represent specific timing and transition scenarios such as contract expiries and charge_type changes, used to deterministically create SQL test data that validates downstream billing workflows.

Can I use generated SQL test data to simulate both monthly and annual billing cycles?▼

Yes, you can generate SQL test data to simulate both monthly and annual billing scenarios. The generated data covers renewals, plan changes, and timing variations to safely test billing workflows across multiple environments.

What's the best way to safely test billing workflows without affecting production data?▼

The best way to safely test billing workflows is by generating deterministic SQL test data locally. This approach emulates various billing patterns and timing transitions for verification without manipulating or touching live production data.

Do I need any specific database dependencies to run the generated SQL test data?▼

No specific database dependencies are required to run the generated SQL test data. The skill operates independently to produce deterministic SQL statements that can be safely manipulated locally in your testing environment.