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/e171d39ba5bce7c9/aact-bulk-trials/SKILL.md- Versions recorded
- 1
- Latest version
- git:20260912.c74de71, committed Sep 12, 2026
- Size
- 15,031 bytes
- Repository stars
- 11
- License
- MIT
使用 AACT (Aggregate Analysis of ClinicalTrials.gov) PostgreSQL 数据库进行大批量临床试验历史分析与数据挖掘。触发场景包括：AACT 查询、临床试验批量分析、PostgreSQL 试验数据、全量 NCT 检索、试验数据挖掘、clinical trials data warehouse、疾病领域全景分析、设计相似试验匹配、跨年度试验趋势聚合。本 skill 通过 SQL 接口处理百万级试验记录，支持云端公共 PostgreSQL 服务（aact-db.ctti-clinicaltrials.org）和每日 dump 本地还原两种连接方式，自动检测并优先使用本地高性能模式。.
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. 职责边界 **只做**：基于 AACT PostgreSQL 数据库的批量、历史、聚合性临床试验数据分析。 **不做**： - 实时单条 NCT 查询（→ 使用 `clinical-trials-v2` skill） - 文献检索（→ 使用 `pubmed-search` / `europepmc-search`） - 临床数据撰写报告（→ 使用 `clinical-reports`） **典型用例**： - "分析血液科所有 IFI（侵袭性真菌感染）相关历史试验的设计趋势" - "找出过去 10 年 AML 领域全部 III 期试验的赞助商分布" - "匹配某个 NCT 的设计相似试验（同 condition + intervention + phase）" - "按国家维度聚合 CAR-T 试验的 status 分布" --- ## 2. 与 clinical-trials-v2 的差异 | 维度 | clinical-trials-v2 | aact-bulk-trials（本 skill） | |------|-------------------|----------------------------| | 数据源 | ClinicalTrials.gov v2 REST API | AACT PostgreSQL 镜像（每日同步） | | 单次容量 | ≤ 1000 条 | 单 SQL 可处理百万级 | | 网络 | 强依赖 | 本地模式离线可用 | | 延迟 | 低（实时） | T+1（每日 dump） | | 适用场景 | 单试验细节、最新状态 | 批量聚合、历史趋势、跨表 JOIN | --- ## 3. 两种连接方式 skill 启动时自动检测优先级：**本地 dump (B) → 云端 (A) → 报错指引**。 ### 方式 A · 云端公共 PostgreSQL（推荐零部署） - Host: `aact-db.ctti-clinicaltrials.org` - Port: `5432` - Database: `aact` - 注册免费账号: https://aact.ctti-clinicaltrials.org/users/sign_up - 适合：偶发查询、无本地 PostgreSQL、可接受网络延迟 ### 方式 B · 本地 dump 还原（高性能 · 离线分析） - 下载每日 dump（约 2.27 GB pg_dump custom format）：https://aact.ctti-clinicaltrials.org/downloads - 要求：本地 PostgreSQL 16+ - 还原命令： …
Read the whole file at its exact version.
How to install
mdr add ethanyoq/skill-hub/aact-bulk-trials@sha256:7f03d1d50cdd9a63The 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_6rimoj55w7jtwh4k)
5 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 (15031 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_6rimoj55w7jtwh4k GET https://markdownregistry.com/api/v1/resolve?ref=ethanyoq/skill-hub/aact-bulk-trials GET https://markdownregistry.com/api/v1/blob/7f03d1d50cdd9a633bbfad086739b98a423099e3842b68aebfc32752b6b2e40e
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