OpenParable
Skip to content
← Back to skills

CLI Anything Openrefine

Documents
cli-anything-openrefine

CLI Anything Openrefine is an Agent Skill for documents published in the HKUDS/CLI-Anything repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

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.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/HKUDS/CLI-Anything/blob/HEAD/skills/cli-anything-openrefine/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/cli-anything-openrefine, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

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 --json on 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.

Error Handling

When --json is set, command failures write a JSON object to stderr with ok: false.