case-extractor
CommunityEffortlessly extract CRM case data with denormalization.
AuthorWkayaobama
Version1.0.0
Installs0
System Documentation
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'.
Dependency Matrix
Required Modules
pandaspyodbc
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: case-extractor Download link: https://github.com/Wkayaobama/icalps_pipeline/archive/main.zip#case-extractor Please download this .zip file, extract it, and install it in the .claude/skills/ directory.