duckdb/duckdb-skills

convert-file

Convert any data file to another format: CSV, Parquet, JSON, Excel, GeoJSON, and more.

ソースを見る

使い方

  1. インストールコマンドをコピーし、自分の環境へ導入する前にソースを確認します。
  2. 必要なツール、認証情報、対応環境を原文で確認します。
  3. 入力と成果物を指定し、出力を資料と照合します。
npx skills add https://github.com/duckdb/duckdb-skills --skill convert-file

開始前の確認

  • 導入にはモデル契約、API枠、ファイルへのアクセス許可は含まれません。
  • スター数や導入数は活動の指標であり、独立した品質・安全性試験ではありません。
リポジトリの原文

見出し、例、コード、表、リンク、参照画像を含む原文を表示しています。

You are helping the user convert a data file from one format to another using DuckDB.

Input file: $0 Output file: ${1:-}

Step 1 — Resolve input and output

Input: $0. If it's a bare filename (no /), resolve to a full path with find "$PWD" -name "$0" -not -path '*/.git/*' 2>/dev/null | head -1.

Output: If $1 is provided, use it as the output path. If not, default to the same stem as the input with a .parquet extension (e.g., data.csv → data.parquet).

Infer the output format from the output file extension:

ExtensionFormat clause
.parquet, .pq(default, no clause needed)
.csv(FORMAT csv, HEADER)
.tsv(FORMAT csv, HEADER, DELIMITER '\t')
.json(FORMAT json, ARRAY true)
.jsonl, .ndjson(FORMAT json, ARRAY false)
.xlsx(FORMAT xlsx) — requires INSTALL excel; LOAD excel;
.geojson(FORMAT GDAL, DRIVER 'GeoJSON') — requires LOAD spatial;
.gpkg(FORMAT GDAL, DRIVER 'GPKG') — requires LOAD spatial;
.shp(FORMAT GDAL, DRIVER 'ESRI Shapefile') — requires LOAD spatial;

Step 2 — Convert

Run a single DuckDB command. Prepend extension loads as needed based on both the input and output formats.

bash
duckdb -c "
<EXTENSION_LOADS>
COPY (FROM '<INPUT_PATH>') TO '<OUTPUT_PATH>' <FORMAT_CLAUSE>;
"

For remote inputs (s3://, https://, etc.), prepend the same protocol setup as read-file:

ProtocolPrepend
s3://LOAD httpfs; CREATE SECRET (TYPE S3, PROVIDER credential_chain);
gs:// / gcs://LOAD httpfs; CREATE SECRET (TYPE GCS, PROVIDER credential_chain);
https:// / http://LOAD httpfs;

If the user mentions partitioning (e.g., "partition by year"), add PARTITION_BY (col) to the format clause. This only works with Parquet and CSV output.

If the user mentions compression (e.g., "use zstd"), add CODEC 'zstd' for Parquet output.

Step 3 — Report

On success, report:

  • Input file and detected format
  • Output file, format, and size (ls -lh)
  • Row count if quick to compute

On failure:

  • `duckdb: command not found` → delegate to /duckdb-skills:install-duckdb
  • Missing extension → install it and retry
  • Input parse error → suggest the user check the input format or try /duckdb-skills:read-file first to inspect it

タスクに関連する項目

同じリポジトリから

関連する Skills

すべての Skills
duckdb
コミュニティ

query

Run SQL queries against the attached DuckDB database or ad-hoc against files. Accepts raw SQL or natural language questions. Uses DuckDB Friendly SQL idioms.

1時間の導入数
2
GitHub Stars
610
更新日
4月23日
duckdb
コミュニティ

s3-explore

Explore and query data on S3, Cloudflare R2, GCS, MinIO, or any S3-compatible storage. Use when the user mentions an s3://, r2://, gs://, or gcs:// URL, asks "what's in this bucket", wants to list remote files, preview remote Parquet/CSV/JSON, or query data on object storage without downloading it. Also triggers when the user wants to know the size, schema, or row count of remote datasets.

1時間の導入数
1
GitHub Stars
609
更新日
4月23日
duckdb
コミュニティ

attach-db

Attach a DuckDB database file for use with /duckdb-skills:query. Explores the schema (tables, columns, row counts) and writes a SQL state file so subsequent queries can restore this session automatically via duckdb -init.

1時間の導入数
1
GitHub Stars
609
更新日
4月23日
duckdb
コミュニティ

install-duckdb

Install or update DuckDB extensions. Each argument is either a plain extension name (installs from core) or name@repo (e.g. magic@community). Pass --update to update extensions instead of installing.

1時間の導入数
1
GitHub Stars
609
更新日
4月23日