skills.rest
Wkayaobama
WkayaobamaCOMMUNITY
Explore all skills by this author →
GitHub

case-extractor

Extract denormalized case data from SQL Server into Python dataclasses.

Updated Aug 23, 2026
Ready to run
npx skills add https://github.com/Wkayaobama/icalps_pipeline --skill case-extractor
💬 Prompt for ChatGPT / Claude Chat▼
Please help me install this Agent Skill.
Skill: case-extractor
Source: https://github.com/Wkayaobama/icalps_pipeline/tree/main/Documents/AnthonySalesOps/Codebase/IC_Load/case-extractor
Command: npx skills add https://github.com/Wkayaobama/icalps_pipeline --skill case-extractor

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, pyodbc, and includes scripts (resource) components.

What problem does it solve?

Manually extracting complex case data from SQL Server, including related company and person details, is time-consuming and requires careful SQL crafting. This Skill automates the extraction and denormalization, providing clean, type-safe data, so you can get insights faster.

Core Features & Use Cases

  • Denormalized Data Extraction: Automatically join Case, Company, and Person tables to get a comprehensive view of support tickets, reducing manual query complexity.
  • Type-Safe Output: Convert extracted data directly into Python dataclass instances, ensuring data integrity and ease of use for downstream processing.
  • Use Case: Extract all "Open" support tickets from your CRM, including the associated customer's name and company website, and save them as a Bronze layer CSV for daily reporting and analysis.

Quick Start

Use the case-extractor skill to extract all cases from the CRMICALPS database and save them to 'Bronze_Cases.csv'.