Clinical Trial Schema Designer
by jorgealves
Analyzes clinical trial protocols and generates CDISC-compliant (SDTM/ADaM) data schemas. Use when designing data ingestion pipelines for clinical research or preparing regulatory submissions.
Skill Details
Repository Files
2 files in this skill directory
name: clinical-trial-schema-designer description: Analyzes clinical trial protocols and generates CDISC-compliant (SDTM/ADaM) data schemas. Use when designing data ingestion pipelines for clinical research or preparing regulatory submissions.
Clinical Trial Schema Designer
Purpose and Intent
The clinical-trial-schema-designer bridges the gap between clinical research and data engineering. It helps automate the creation of standardized data structures (CDISC) based on clinical protocols, reducing the manual effort required for data ingestion and submission preparation.
When to Use
- Study Setup: Use during the "Start-up" phase of a clinical trial to design the Electronic Data Capture (EDC) schemas.
- Data Integration: When merging data from multiple sources into a single study standard.
- Submission Prep: To ensure the data structure matches FDA/PMDA requirements for SDTM/ADaM.
When NOT to Use
- Unvalidated Systems: Clinical data must be handled in GxP-validated environments. This tool generates the design, but the implementation must follow strict validation protocols.
- Medical Decision Making: This is a data structuring tool, not a clinical diagnostic or treatment tool.
Error Conditions and Edge Cases
- Ambiguous Protocols: If the input text is vague about how a variable is measured, the generated schema may be incomplete.
- Non-Standard Studies: Phase 1 or highly experimental studies may use variables that don't fit existing CDISC domains perfectly.
Security and Data-Handling Considerations
- IP Protection: Clinical protocols are intellectual property. Ensure the environment running this skill is secure.
- No Patient Data: This tool works on protocols (the plan), not the actual results (the data).
Related Skills
Xlsx
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
Clickhouse Io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Clickhouse Io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Analyzing Financial Statements
This skill calculates key financial ratios and metrics from financial statement data for investment analysis
Data Storytelling
Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.
Team Composition Analysis
This skill should be used when the user asks to "plan team structure", "determine hiring needs", "design org chart", "calculate compensation", "plan equity allocation", or requests organizational design and headcount planning for a startup.
Kpi Dashboard Design
Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.
Dbt Transformation Patterns
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
Sql Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Clinical Decision Support
Generate professional clinical decision support (CDS) documents for pharmaceutical and clinical research settings, including patient cohort analyses (biomarker-stratified with outcomes) and treatment recommendation reports (evidence-based guidelines with decision algorithms). Supports GRADE evidence grading, statistical analysis (hazard ratios, survival curves, waterfall plots), biomarker integration, and regulatory compliance. Outputs publication-ready LaTeX/PDF format optimized for drug develo
