菜单
Query the Gaia DR3 PostgreSQL database at gaia.aip.de via its Daiquiri REST API. Includes CSRF handling, async job submission, queue names, and result fetching. Access 1.8 billion sources with ~153 columns.
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/arm2arm/AstroAgentAssistant --skill gaiadr3-aip-de-adql命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
基于 SOC 职业分类
正在显示 SKILL.md
| name | gaiadr3-aip-de-adql |
| description | Query the Gaia DR3 PostgreSQL database at gaia.aip.de via its Daiquiri REST API. Includes CSRF handling, async job submission, queue names, and result fetching. Access 1.8 billion sources with ~153 columns. |
| version | 1.0.0 |
| author | AstroAgent / AIP |
| license | MIT |
| metadata | {"hermes":{"tags":["astronomy","gaia-dr3","postgresql","adql","daiquiri","rest-api","gaia-aip"],"category":"astronomy","related_skills":["rave-dr6","shboost24-cmd","starhorse-access","gaiadr3-aip-de-adql"]}} |
Use this skill when querying the Gaia DR3 catalog at https://gaia.aip.de/ programmatically — count rows, sample data, filtered selections. For browser-based queries use the web UI; for scripted, large, or reproducible queries use this REST API.
curl and Python 3 stdlib only — no API keys, no installation needed.curl -s -c /tmp/gaia_cookies.txt "https://gaia.aip.de/query//sql/" > /dev/null
CSRF=$(grep csrftoken /tmp/gaia_cookies.txt | awk '{print $7}')
curl -s -b /tmp/gaia_cookies.txt -c /tmp/gaia_cookies.txt \
-X POST \
-H "Referer: https://gaia.aip.de/query//sql/" \
-H "Content-Type: application/json" \
-H "X-CSRFToken: $CSRF" \
-H "X-Requested-With: XMLHttpRequest" \
-d '{"query": "SELECT COUNT(*) FROM gaiadr3.gaia_source", "query_language": "postgresql", "queue": "5m"}' \
"https://gaia.aip.de/query/api/jobs/"
Returns: {"id": "<uuid>", "phase": "QUEUED", ...}
JOB_ID="<uuid_from_step2>"
for i in $(seq 1 20); do
sleep 5
PHASE=$(curl -s -b /tmp/gaia_cookies.txt -c /tmp/gaia_cookies.txt \
-H "Referer: https://gaia.aip.de/query/$JOB_ID/" \
-H "X-CSRFToken: $CSRF" \
-H "X-Requested-With: XMLHttpRequest" \
"https://gaia.aip.de/query/api/jobs/$JOB_ID/" | \
python3 -c "import sys,json; print(json.load(sys.stdin).get('phase'))")
echo "[$((i*5))s] Phase: $PHASE"
[ "$PHASE" = "COMPLETED" ] && break
[ "$PHASE" = "ERROR" ] && break
done
curl -s -b /tmp/gaia_cookies.txt -c /tmp/gaia_cookies.txt \
-H "Referer: https://gaia.aip.de/query/$JOB_ID/" \
-H "X-CSRFToken: $CSRF" \
-H "X-Requested-With: XMLHttpRequest" \
"https://gaia.aip.de/query/api/jobs/$JOB_ID/rows/?limit=10&offset=0"
curl -s "https://gaia.aip.de/metadata/gaiadr3/gaia_source/"
| UI label | Queue param | Timeout |
|---|---|---|
| "30 Seconds" | omit (default) | 30s — times out on large queries |
| "5 Minutes" | "5m" | 5 min |
| "2 Hours" | "2h" | 2 hours |
Always use "5m" or "2h" for COUNT or large scans.
Always use "postgresql" — not adql, even though the web UI defaults to ADQL.
| Method | Endpoint | Purpose |
|---|---|---|
| POST | /query/api/jobs/ | Submit async query job |
| GET | /query/api/jobs/{id}/ | Poll job status (phase) |
| GET | /query/api/jobs/{id}/rows/ | Fetch JSON results |
| GET | /metadata/gaiadr3/gaia_source/ | Full column list with types/units |
/query/tap/sync/ and /query/tap/async/ return HTML — do NOT use for programmatic queries./query/sync/ returns 405 Method Not Allowed.gaiadr3.gaia_source (~1.8B rows) — always use "5m".csrftoken cookie) and sent via X-CSRFToken header.X-Requested-With: XMLHttpRequest, Referer: https://gaia.aip.de/query//sql/.gaiadr3.gaia_source1000/parallax for simple estimatesThis is a specialized or legacy example skill. For new work, start with astro-data-access-umbrella and route through:
gaia-aip-data-accessKeep this skill for dataset-specific examples, but prefer the canonical skills for new implementations, live probes, REANA execution, and plotting/cache conventions.
"5m", "2h".COMPLETED (not ERROR)./metadata/ endpoint returns a JSON list of 153 columns.