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

sql-runone

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables executing an individual CUBRID SQL testcase through CTP interactive mode and reporting PASS/FAIL with a detailed diff analysis, saving time during targeted validation.

Core Features & Use Cases

  • Run a single SQL testcase located under cases/ and compare the actual output against the corresponding .answer file.
  • Supports sql, medium, and sql_by_cci categories by selecting the appropriate CTP workflow based on the request.
  • Use cases include quick verification of isolated SQL scripts during development or regression checks when a specific test needs isolated execution.

Quick Start

Provide the path to the .sql file and optional build URL; the skill will prepare the environment, run the test in CTP interactive mode, and report results.

Frequently Asked Questions about sql-runone

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

FAQPage Schema
How do I run a single CUBRID SQL test case in CTP interactive mode?▼

To run a single CUBRID SQL test case, provide the path to the .sql file under cases/ and an optional build URL. The skill prepares a temporary workspace, executes the test in CTP interactive mode, and reports PASS/FAIL results with diff analysis.

What is diff analysis for CUBRID SQL test cases?▼

Diff analysis for CUBRID SQL test cases compares actual test output against the corresponding .answer file. It generates diagnostic difference reports to help developers identify exact discrepancies during targeted validation or regression checks.

Does CTP interactive mode support sql_by_cci test categories?▼

Yes, CTP interactive mode supports sql_by_cci test categories. It categorizes SQL tests into sql, medium, or sql_by_cci and selects the appropriate workflow based on your request to ensure correct execution.

Can I use a specific build URL to initialize the CUBRID test environment?▼

Yes, you can use an optional build URL to initialize the CUBRID test environment. Providing the build URL allows the skill to properly prepare the temporary test workspace before executing the SQL test case.

What's the best way to verify an isolated SQL script during CUBRID development?▼

The best way to verify an isolated SQL script is running a single testcase via CTP interactive mode. It executes the specific .sql file and compares output against the .answer file for quick regression checks.

Why is my CUBRID SQL test failing and how do I get diagnostic output?▼

When a CUBRID SQL test fails, the skill generates detailed diagnostic output including difference reports. It compares actual output against the .answer file to help identify why the test case did not pass.

Related Skills

Explore More Software Engineering Skills→
tw-kangtw-kang

cci-runone

Execute and analyze a single CCI testcase with pass/fail reports.

Community
Advanced
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_repl-runone

Run a single CUBRID HA replication testcase and report master-slave result match.

Community
Advanced
tw-kangtw-kang

shell-runone

Execute a named CUBRID shell testcase locally and report pass/fail results.

Community
Advanced