aact-bulk-trials SKILL.md skillA
aact-bulk-trials from ethanyoq/skill-hub is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add ethanyoq/skill-hub/aact-bulk-trials@git:20260912.c74de71Pins git:20260912.c74de71 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- ethanyoq/skill-hub
- Path
archives/user-installed-skills/aact-bulk-trials/e07736f27453c7b6/aact-bulk-trials/SKILL.md- Versions recorded
- 1
- Latest version
- git:20260912.c74de71, committed Sep 12, 2026
- Size
- 8,282 bytes
- Repository stars
- 11
- License
- MIT
使用 AACT (Aggregate Analysis of ClinicalTrials.gov) PostgreSQL 数据仓库进行批量、历史、聚合性临床试验数据挖掘。Use this skill when the user requests bulk SQL analysis over the full clinical trials data warehouse — historical trial trends, disease landscapes, similar-design matching, or multi-year aggregations across hundreds of thousands of NCT records. 触发场景包括：AACT 查询、临床试验批量分析、PostgreSQL 试验数据、全量 NCT 检索、试验数据挖掘、历史试验分析、clinical trials data warehouse、SQL trials、bulk trial analysis、disease…
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# AACT Bulk Trials · 批量临床试验数据仓库
## 1. 何时调用本 skill
**调用本 skill** 当用户请求：
- 疾病领域全景分析（"过去 10 年血液病所有 NCT 试验按 phase/sponsor 聚合"）
- 跨年度趋势聚合（"AML 领域 III 期试验赞助商分布"）
- 设计相似试验匹配（"找与 NCT12345678 设计相似的其他试验"）
- 整库扫描 / 百万级 JOIN（条件 + 干预 + 结果跨表）
**不要调用本 skill**（应转其他）：
- 单条 NCT 最新状态查询 → `clinical-trials-v2`（实时 API · 互补）
- 文献检索 → `pubmed-search` / `europepmc-search`
- 临床报告撰写 → `clinical-reports`
**与 clinical-trials-v2 的差异**：
| 维度 | clinical-trials-v2 | aact-bulk-trials（本 skill） |
|------|-------------------|----------------------------|
| 数据源 | ClinicalTrials.gov v2 REST API | AACT PostgreSQL 镜像（每日同步） |
| 单次容量 | ≤ 1000 条 | 单 SQL 可处理百万级 |
| 网络 | 强依赖 | 本地模式离线可用 |
| 延迟 | 低（实时） | T+1（每日 dump） |
| 适用场景 | 单试验细节、最新状态 | 批量聚合、历史趋势、跨表 JOIN |
---
## 2. 上下游 skill 协作
```
clinical-trials-v2 ────┐
(实时单查 · 互补) │
▼
aact-bulk-trials → medical-evidence-grading → evidence-appendix-sync
(本 skill · 批量SQL) (上层 · 批量 grade) (终下游 · 报告附录)
```
- **上游**：用户原始批量挖掘需求（市场调研、疾病全景、设计相似性）
- **平级互补**：`clinical-trials-v2`（单条实时） / `pubmed-search`（文献）
- **下游**：`medical-evidence-grading`（用本 skill 输出的 NCT 列表批量评级） → `evidence-appendix-sync`（终态报告附录 C）
---
…Read the whole file at its exact version.
How to install
mdr add ethanyoq/skill-hub/aact-bulk-trials@sha256:80b42e5e0048d952The line at the top of this page pins the label git:20260912.c74de71, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_ipsivibe5nzxoiud)
3 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 1 version of this file, committed on Sep 12, 2026.
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (8282 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
ethanyoq/skill-hub · 11 stars · license MIT · pushed 2026-10-19 · branch mine
API
GET https://markdownregistry.com/api/v1/artifacts/art_ipsivibe5nzxoiud GET https://markdownregistry.com/api/v1/resolve?ref=ethanyoq/skill-hub/aact-bulk-trials GET https://markdownregistry.com/api/v1/blob/80b42e5e0048d9528aa76b93b7df2d846f229a05e2c9cf5eb9ff6d6616731456
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.
More from ethanyoq/skill-hub
Every file in ethanyoq/skill-hub