Clinical Trial Schema Designer

by jorgealves

designdatacli

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

data

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Analyzing Financial Statements

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

data

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.

data

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.

artdesign

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.

designdata

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.

testingdocumenttool

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.

designdata

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

developmentdocumentcli

Skill Information

Category:Creative
Last Updated:1/25/2026