菜单
Query the Gaia DR3 PostgreSQL database at gaia.aip.de via its Daiquiri REST API. Includes CSRF handling, queue names, and result fetching.
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/arm2arm/AstroAgentAssistant --skill gaiadr3-aip-query-api命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
基于 SOC 职业分类
正在显示 SKILL.md
| name | gaiadr3-aip-query-api |
| category | data-science |
| description | Query the Gaia DR3 PostgreSQL database at gaia.aip.de via its Daiquiri REST API. Includes CSRF handling, queue names, and result fetching. |
| triggers | ["how many stars in gaiadr3","query gaia aip database","gaia.aip.de query","gaiadr3 count"] |
Query the Gaia DR3 PostgreSQL database at gaia.aip.de via its Daiquiri REST API. Includes CSRF handling, queue names, and result fetching.
This skill contains a reusable operational workflow. Follow the existing task-specific steps and examples in the sections below.
This 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.
Query the Gaia DR3 PostgreSQL database at https://gaia.aip.de/ programmatically via its Daiquiri REST API.
# 1. Get CSRF token + session cookie
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}')
# 2. Submit async query job (POST /query/api/jobs/)
# Queue names are NOT what the UI shows:
# - "30 Seconds" -> default (no queue param, times out at 30s)
# - "5 Minutes" -> "5m"
# - "2 Hours" -> "2h"
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/"
# 3. Poll for completion
JOB_ID="<id_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
# 4. Fetch results (JSON)
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"
https://gaia.aip.de/query/api/jobs/{"id": "<uuid>", ...})count, results, next, previous)postgresql (not adql even though UI defaults to ADQL)"5m", "2h", or omit for default (30s, times out on large queries)csrftoken cookie), send via X-CSRFToken headerX-Requested-With: XMLHttpRequest, Referer: https://gaia.aip.de/query//sql//query/tap/sync/, /query/tap/async/) return HTML, not JSON — do NOT use"5m" queuegaiadr3.gaia_source (verified working) — 153 columnsgaiadr3.gaia_source = 1,811,709,771 sources (as of 2026-04-14)curl -s "https://gaia.aip.de/metadata/gaiadr3/gaia_source/" — full column list with types/units/descriptions-- Count all sources
SELECT COUNT(*) FROM gaiadr3.gaia_source
-- Count with filter
SELECT COUNT(*) FROM gaiadr3.gaia_source WHERE phot_g_mean_mag < 16
-- Sample rows
SELECT * FROM gaiadr3.gaia_source LIMIT 10