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

sql-create

Generate CUBRID CTP SQL testcase files (.sql/.answer from bug descriptions.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps developers and QA engineers quickly produce well-formed CUBRID CTP SQL testcase drafts from bug reports or feature requests, eliminating repetitive formatting, naming, and structural errors that slow down test authoring.

Core Features & Use Cases

  • Structured Test Generation: Produce .sql files with the required header block, numbered evaluate labels, paired server-message markers when needed, and setup/cleanup sections following CTP conventions.
  • Directory & Naming Guidance: Recommend correct placement under sql/_13_issues or feature directories and filename patterns for bug fixes and new features.
  • Answer File Workflow: Explain how to generate .answer files using the sql-runone skill or create a placeholder answer when execution is not possible.
  • Self-Review Checklist: Validate presence of header, evaluate labels, DROP TABLE IF EXISTS, server-message pairing, and queryPlan guidance for optimizer tests.

Quick Start

Create a draft SQL testcase for CBRD-12345 in the appropriate sql/*/cases directory including header, evaluate labels, DROP/CREATE setup and cleanup, and instructions to generate the .answer via sql-runone.

Frequently Asked Questions about sql-create

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

FAQPage Schema
How do I generate CUBRID CTP SQL testcases from an issue description?▼

Generate CUBRID CTP SQL testcases by providing an issue brief to produce .sql files with header blocks, numbered evaluate labels, and DROP TABLE IF EXISTS setup sections following CTP conventions.

What is the correct directory placement and naming pattern for CUBRID CTP bug fix testcases?▼

CUBRID CTP bug fix testcases require correct directory placement under sql/_13_issues or feature directories, using specific filename patterns for bug fixes and new features to maintain CTP structural conventions.

How do I create .answer files for CTP SQL testcases?▼

Create .answer files for CTP SQL testcases by using the sql-runone skill to execute queries and generate outputs, or manually create placeholder answer files when direct execution is not possible.

Does CTP SQL testcase generation enforce server-message marker pairing?▼

CTP SQL testcase generation enforces conventions like paired server-message markers and DROP TABLE IF EXISTS cleanup, validating these through a self-review checklist to ensure correct CTP formatting.

Can I generate queryPlan files for CUBRID CTP optimizer tests?▼

You can generate optional queryPlan files for CUBRID CTP optimizer tests, with the testcase generation providing specific guidance on structuring these files alongside the standard .sql and .answer outputs.

Related Skills

Explore More Software Engineering Skills→
tw-kangtw-kang

sql-runone

Run a single CUBRID SQL testcase via CTP interactive mode and report PASS/FAIL with diff analysis.

Community
Intermediate
tw-kangtw-kang

cci-create

Generate CCI testcase scaffolds with shell scripts, C sources, and answer files.

Community
Intermediate
tw-kangtw-kang

cdc_repl-create

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

Community
Intermediate
tw-kangtw-kang

jdbc-create

Generate JDBC JUnit 4 Java testcase templates for CUBRID CTP tests.

Community
Intermediate