skills.rest
tw-kang
tw-kangCOMMUNITY
Explore all skills by this author →
GitHub

cdc_repl-create

Generate CDC replication CTP SQL testcase drafts with CTP file format and CDC markers.

1|Updated Apr 2, 2026
Search Tags:#sql#replication#test-generation#cdc#testcase#ctp#cubrid
One-click install
npx skills add https://github.com/tw-kang/skills --skill cdc-repl-create
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cdc_repl-create
Source: https://github.com/tw-kang/skills/tree/main/cdc_repl-create
Command: npx skills add https://github.com/tw-kang/skills --skill cdc-repl-create

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps engineers and QA contributors quickly produce well-formed CDC replication CTP SQL testcases for CUBRID by enforcing CTP formatting rules and CDC-specific constraints so tests are consistent, deterministic, and review-ready.

Core Features & Use Cases

  • Structured testcase scaffolding: Produces .sql files with the required header, Coverage section, setup and teardown blocks, --test and --check markers, and COMMIT placement.
  • CDC-specific validation guidance: Emphasizes explicit PRIMARY KEYs, deterministic ORDER BY in check queries, avoidance of LOBs, and proper use of cdc_test_helper and conf/cdc_repl.conf.
  • Examples and checklist: Includes example testcases and a self-review checklist to ensure CTP compliance for bug fixes and new feature tests.

Quick Start

Create a draft CDC replication SQL testcase for CBRD-12345 that includes a header with Coverage, setup DDL, INSERT/UPDATE/DELETE test blocks with COMMITs, deterministic check queries with ORDER BY, and cleanup.

Frequently Asked Questions about cdc_repl-create

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

FAQPage Schema
How do I generate CTP SQL testcases for CUBRID CDC replication?▼

To generate CTP SQL testcases for CUBRID CDC replication, use this skill to scaffold .sql files with required headers, setup blocks, DML --test blocks, and --check queries following CDC-specific formatting constraints.

What is the CTP file format for CDC replication test drafts?▼

The CTP file format for CDC replication test drafts requires a structured header with Coverage, setup and teardown blocks, --test and --check markers, explicit COMMIT placement after DML batches, and deterministic ORDER BY in check queries.

Does CUBRID CDC replication testing require explicit PRIMARY KEYs in test files?▼

Yes, CUBRID CDC replication testing requires explicit PRIMARY KEYs in DDL setup to ensure proper replication tracking, alongside avoiding LOBs unless specifically required and using cdc_test_helper for compatibility.

How do I add deterministic --check queries to a CDC replication SQL testcase?▼

To add deterministic --check queries to a CDC replication SQL testcase, include explicit ORDER BY clauses in your verification SELECT statements to ensure consistent result ordering for replication verification.

What are the limitations when writing CDC replication test files for CUBRID?▼

Limitations when writing CDC replication test files for CUBRID include avoiding LOBs unless strictly required, ensuring compatibility with conf/cdc_repl.conf, and mandating COMMIT statements after DML batches for proper replication synchronization.

Related Skills

Explore More Software Engineering Skills→
tw-kangtw-kang

cdc_repl-runone

Execute a single CUBRID CDC replication testcase via CTP and report pass/fail.

Community
Advanced
tw-kangtw-kang

ha-shell-create

Generate CUBRID CTP HA shell test scripts for replication scenarios.

Community
Advanced
tw-kangtw-kang

ha_repl-create

Create CUBRID CTP SQL testcases with --test/--check markers for HA replication.

Community
Intermediate
MarioDeFelipeMarioDeFelipe
25

datasphere-data-flows

Orchestrate SAP Datasphere replication, transformation, and task chain flows.

Community
Advanced