mcpField
C
cli-anything-openrefine

cli-anything-openrefine

github.com/hkudsData & databases57.6k195 installsUpdated 5w ago
Repository

About cli-anything-openrefine

A command-line skill for using OpenRefine in automated agent workflows to clean and transform data, reuse operation histories, and export CSV or TSV. JSON output and isolated sessions support scripted runs and failure detection in CI.

Key features

  1. 01Clean and transform data
  2. 02Reuse OpenRefine operation histories
  3. 03Export CSV and TSV
  4. 04JSON output and isolated sessions
  5. 05Piped REPL runs with failure status

Use cases

  1. 01Clean imported CSV data automatically
  2. 02Apply an existing operation history
  3. 03Export processed data as CSV or TSV
  4. 04Run workflows in CI and detect failures

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/hkuds/cli-anything --skill cli-anything-openrefine

After installing, type/cli-anything-openrefinein Claude Code to confirm it loaded.

Details

From the project README

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.

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.

Comments

Markdown supported