Analyze local files, then check the result

Alchemist · Data analysis2 spells in orderProposed, not testedUnrated

Play the combo

Foe: Riddle Sphinx, a question your data hasn't answered yet.

Foes

  • Riddle Sphinx

Party · Context

  • AlchemistYour agent100/100
  1. Riddle Sphinx

    The Riddle Sphinx blocks the way.

    What really happensIt stands for a question your data hasn't answered yet.

    Alchemist: Context 100/100.

  2. Riddle

    The sphinx asks a riddle. A wrong guess costs dearly.

    What really happensAn answer guessed from a hunch instead of a query sends the work the wrong way.

    Alchemist takes 11. Alchemist: Context 89/100.

  3. DuckDB / MotherDuck MCP

    A pocket duck engine that runs SQL on your local data.

    What really happensRuns DuckDB SQL on local files or an in-memory database.

    Riddle Sphinx takes 50.

  4. Riddle

    The Riddle Sphinx uses Riddle.

    Alchemist takes 11. Alchemist: Context 78/100.

  5. Anthropic Data

    A satchel of analyst scrolls for questions your tables can answer.

    What really happensProfiles the data, charts the answer and validates it before you share.

    Riddle Sphinx takes 50. Riddle Sphinx falls.

  6. Victory

    The Riddle Sphinx falls.

    What really happensDuckDB gives the agent a SQL engine for local files with no warehouse account. The Data plugin then profiles the results, draws the chart and runs its validation pass before anyone sees the numbers.

Cast order

  1. DuckDB / MotherDuck MCP

    Runs DuckDB SQL on local files or an in-memory database.

  2. Anthropic Data

    Profiles the data, charts the answer and validates it before you share.

Why it works

DuckDB gives the agent a SQL engine for local files with no warehouse account. The Data plugin then profiles the results, draws the chart and runs its validation pass before anyone sees the numbers.

Records

Not measurable yet: Anthropic Data has no log match.

Learn the spells

  1. 1. DuckDB / MotherDuck MCP

    Claude Code

    claude mcp add --scope user duckdb --transport stdio -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases

    Codex

    codex mcp add duckdb -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases

  2. 2. Anthropic Data

    Claude Code

    claude plugin marketplace add anthropics/knowledge-work-plugins
    claude plugin install data@knowledge-work-plugins