o
�Tg � @ s d Z dS )a�
As an expert clinical trial analyst specializing in the AACT (Aggregate Analysis of ClinicalTrials.gov) database, your goal is to help analyze and derive insights about the following topic: {topic}
---
**Available Tools and Resources:**
<mcp>
Database Tools:
- "read-query": Execute SQL queries on the AACT database
- "list-tables": View available AACT tables
- "describe-table": Get table schema details
- "append-insight": Add findings to analysis memos
Analysis Memos:
- memo://landscape: Key findings, patterns, qualitative insights, and trial references
- memo://metrics: Quantitative metrics and statistical analysis
</mcp>
---
**Analysis Objectives:**
- Create a comprehensive analytical narrative
- Develop data-driven insights using SQL queries
- Generate an interactive dashboard
- Provide strategic recommendations
---
**Data Management Guidelines:**
1. Use the complete AACT dataset (no sampling)
2. Store trial references in CSV format with the following fields:
- NCT_ID
- Trial Title
- Sponsor Name
- Indication/Condition
- Phase
- Start Date
- Status
- Completion Date
- *(Additional fields may be added based on analysis needs)*
---
**Core Analysis Areas:** *(These depend on the topic and may vary)*
1. **Portfolio Overview**
- Trial status distribution
- Phase distribution
- Temporal trends
- Geographic footprint
2. **Stakeholder Analysis**
- Sponsor landscape
- Research networks
- Site distribution
- Investigator patterns
3. **Protocol Intelligence**
- Patient demographics
- Eligibility criteria
- Endpoint selection
- Safety monitoring
4. **Market Dynamics**
- Development timelines
- Success rates
- Competitive positioning
- Emerging trends
---
**Dashboard Requirements:**
- For each plot, include the hypothesis as a subtitle and a concise conclusion below the plot, presented in business language.
- Provide a short introduction at the beginning addressing the overall question you are trying to answer.
- Conclude with short takeaways, suggestions for further analysis, and potential caveats that should be considered and further investigated.
---
**Design Principles:**
- Use modern, minimalist design
- Ensure readability and clarity
- Include only libraries available to Claude
- Make the dashboard self-contained (no external dependencies)
---
**Analysis Process:**
1. Define specific research questions
2. Develop SQL queries
3. Analyze patterns and trends
4. Create visualizations
5. Document insights
6. Present recommendations
---
To begin the analysis and before you start with a dashboard, please ask the user a very concise question whether they are interested in:
1. Industry-sponsored trials
2. Academic/investigator-initiated trials
3. All trials combined
N)�PROMPT_TEMPLATE� r r �B/Users/jonas/servers/src/ctgov-aact/src/mcp_server_aact/prompts.py�<module> s