Menu
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/penghang1223/niannian-workspace --skill duckdb-analyticsThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Showing SKILL.md
| 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 — 核心模块（连接/基准/导出）
Based on SOC occupation classification