Menú
DuckDB数据分析工具集 — 内存管理/ClickBench基准/结果导出。$700 MacBook也能跑大数据。
Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.
Basado en la clasificación ocupacional SOC
Unit, integration, and E2E testing patterns with framework-specific guidance. Use when asked to "write tests", "add test coverage", "testing strategy", "test this function", "create test suite", "fix flaky tests", or "improve test quality".
A self-evolution engine for AI agents. Analyzes runtime history to identify improvements and applies protocol-constrained evolution. Communicates with EvoMap Hub via local Proxy mailbox.
抖音视频下载工具 - 解析抖音链接，下载视频并发送
根据用户提供的内容方向自动生成提示词并创作爽文小说。适用场景：(1) 用户提供小说方向/题材/关键词，(2) 需要生成章节连贯的长篇爽文，(3) 需要维护角色、地点、情节的连续性，(4) 需要为关键情节生成图解，(5) 需要记录生成失败场景以优化后续创作。支持都市、修仙、玄幻、重生、系统流等多种题材。Use when user asks to write a novel, generate fiction, create stories, or mentions 爽文/小说/写作。
Imported specialist agent skill for architecture designer. Use when requests match this domain or role.
Builds automation workflows from repetitive tasks. Use when user mentions "automate", "save time", "reduce manual work", or has repeated tasks.
| name | duckdb-analytics |
| description | DuckDB数据分析工具集 — 内存管理/ClickBench基准/结果导出。$700 MacBook也能跑大数据。 |
自动使用80%可用内存，让DuckDB自己管OOM。
from duckdb_setup import get_connection
conn = get_connection() # 自动配置内存
result = conn.execute("SELECT * FROM 'data.parquet'").fetchdf()
from duckdb_setup import benchmark_clickbench
results = benchmark_clickbench("hits.parquet")
# 输出每个查询的avg/min/max耗时
from duckdb_setup import export_analytics_report
path = export_analytics_report(conn, "SELECT * FROM sales", format="parquet")
| 技巧 | 说明 |
|---|---|
SET memory_limit='80%' | 让DuckDB自管OOM |
$700 MacBook能跑100M行 | 边缘计算基准验证 |
| VARIANT+GEOMETRY类型 | DuckDB 1.5新特性 |
# 测试
python3 <SKILL_DIR>/scripts/duckdb_setup.py
# 在脚本中import
python3 -c "from duckdb_setup import get_connection; conn = get_connection(); print(conn.execute('SELECT version()').fetchone())"
scripts/duckdb_setup.py — 核心模块（连接/基准/导出）