Import Check: Validate & Clean CSV

Connect Remote server

claude mcp add --transport http import-check https://check.orvel.dev/mcp --header "Authorization: Bearer <YOUR_API_KEY>"

{
  "mcpServers": {
    "import-check": {
      "url": "https://check.orvel.dev/mcp",
      "headers": {
        "Authorization": "Bearer <YOUR_API_KEY>"
      }
    }
  }
}

{
  "servers": {
    "import-check": {
      "type": "http",
      "url": "https://check.orvel.dev/mcp",
      "headers": {
        "Authorization": "Bearer <YOUR_API_KEY>"
      }
    }
  }
}

Settings > Connectors > Add custom connector
URL: https://check.orvel.dev/mcp

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools 10 found in our last check

• get_csv_example

  Return a fixed synthetic CSV and its column schema. Free, no key or quota. Copy the structure, then supply your own CSV to validate_csv.

• view_csv_demo

  Validate the fixed example with the current engine. Free and no arguments; demonstrates duplicate, email, amount and date findings. Custom files require validate_csv and paid access.

• get_csv_usage

  Read remaining operations and expiry for the API key supplied in the Authorization header. Does not consume credit.

• get_table_example

  Return fixed synthetic left/right tables and a reusable join recipe. No arguments, key or credit. Copy the structure for reconcile_tables; mode controls which unmatched rows appear in output.

• view_table_demo

  Join the bundled fixed tables and show changed and unmatched records. No arguments, key or credit. This cannot process custom data; use reconcile_tables with a paid key for your files.

• inspect_table

  Profile a CSV or explicit string table before writing a recipe. Return empty, distinct and duplicate-value counts per column and complete formula warnings; no schema or business validity is inferred. Supply CSV OR columns/rows, never both. JSON numbers must be encoded as strings…

• prepare_table

  Select, rename, derive and convert columns using a caller-owned version-1 recipe. Rules reference original input headers; output follows recipe order and omitted columns are listed. All input rows remain. Any failed conversion returns valid=false, all findings and csv_text=null,…

• reconcile_tables

  Join two bounded tables using exact string or composite keys. Both sides must have non-empty unique keys: duplicates block the entire output, including many-to-many matches. Choose left, inner or full retention explicitly; unmatched records are reported even if excluded. Optiona…

• validate_csv

  Check a CSV against your explicit schema; return all issue counts and at most 200 detailed findings. Headers match exactly; required=false permits empty cells, not missing headers. Unique compares raw non-empty strings. Dates use YYYY-MM-DD, decimals use a dot without grouping,…

• clean_csv

  Apply only requested column renames and transformations, then validate the output against schema. Cleanup column names refer to the original headers; schema names refer to the renamed output. Transformations run in listed order. decimal_comma changes only plain numbers such as 1…

Headers

Details

More data and analytics servers See all

• topo^alpin

  Avalanche bulletins, mountain weather, stations, huts, ski and snowshoe tours in the Alps.

• MedBillAnalyzer

  Compares a medical bill with the insurer's Explanation of Benefits and lists where they disagree.

• Brush Pack

  Paint and wallpaper amounts, weather checks and lead paint safety for UK decorators' AI

• Ridge Pack

  Roof take-offs, weather windows, building regs and storm triage for UK roofers' AI assistants

• Agent Data Tools: Everyday data

  29 tools: weather, time zones, sun and moon, earthquakes, countries. 25 free calls.

• Agent Data Tools: Utilities

  105 tools: JSON repair, CSV, hashes, cron, dates, units, validators. 25 free calls.