cli-anything-openrefine
GitHub通过 CLI 自动化操作 OpenRefine，实现脏数据导入、清洗转换、JSON 操作历史应用及 CSV/TSV 导出，支持会话管理与错误处理。
Trigger Scenarios
Install
npx skills add HKUDS/CLI-Anything --skill cli-anything-openrefine -g -y
SKILL.md
Frontmatter
{
"name": "cli-anything-openrefine",
"contributor": "CLI-Anything-Team",
"description": "Use OpenRefine through an agent-native CLI for importing messy data, applying JSON operation histories, inspecting rows, exporting cleaned data, and managing session undo\/redo."
}
CLI-Anything OpenRefine
Use this skill when a task needs OpenRefine data cleaning, transformation, reusable operation histories, or CSV/TSV export from an automated agent workflow.
Prerequisites
Install the harness:
cd openrefine/agent-harness
python -m pip install -e .
Start OpenRefine before backend commands:
openrefine -i 127.0.0.1 -p 3333
Set a custom server with OPENREFINE_URL=http://127.0.0.1:3333 or pass --base-url.
Command Rules For Agents
- Prefer
--jsonon every one-shot command. - Use
--session <path>for isolated task state. - Import or open a project before row, apply, export, undo, or redo commands.
- Existing OpenRefine operation-history JSON can be passed directly to
data apply. - Generated files are normal OpenRefine operation JSON and exported CSV/TSV data.
Common Commands
cli-anything-openrefine --json server ping
cli-anything-openrefine --json project list
cli-anything-openrefine --json --session run/session.json project import messy.csv --name cleanup
cli-anything-openrefine --json --session run/session.json data rows --limit 10
cli-anything-openrefine --json ops text-transform run/trim.json --column Name --expression 'value.trim()'
cli-anything-openrefine --json --session run/session.json data apply run/trim.json
cli-anything-openrefine --json --session run/session.json data export run/clean.csv --format csv
cli-anything-openrefine --json --session run/session.json session undo
cli-anything-openrefine --json --session run/session.json session redo
REPL
Run cli-anything-openrefine with no subcommand to enter the REPL.
For automated user journeys, pipe newline-separated REPL commands through stdin. Redirected streams automatically use an ASCII-only input/output path while interactive terminals retain the Unicode banner, prompt history, and styling:
printf 'help\nexit\n' | cli-anything-openrefine
Unicode payloads are rendered as reversible ASCII backslash escapes when the REPL is redirected, preventing legacy Windows output encodings from turning a successful command into a failed journey.
Piped workflows return a nonzero exit status at exit or EOF if any command
failed, allowing CI to detect an unsuccessful user journey.
Error Handling
When --json is set, command failures write a JSON object to stderr with ok: false.
Version History
- 6f372d3 Current 2026-08-20 06:42
