A sovereign, local-first MCP-Native ETL System with Hot/Cold tiering, PII scrubbing, ID stitching, Parquet buffers, and data warehouse exports.
Four tools with basic schemas and descriptions, but significant gaps in parameter clarity, output documentation, and error handling. Tool names follow verb_noun pattern (extract_*, poll_*, transform_*, export_*), which is good. However, descriptions lack actionable context for LLM selection. Parameters are typed but lack constraints (enums, ranges, format specs). No documented output schemas. Error responses are JSON but lack recovery guidance. Security concern: payload_json parameters accept raw user input without validation hints. Identity stitching logic is complex but underdocumented in tool descriptions.
LOAD: Exports transformed, anonymized data from Cold Storage to target enterprise warehouses.
EXTRACT: Ingests real-time events (webhooks, CMS events, clicks) directly into the Hot Tier.
EXTRACT: Ingests batch CRM records (HubSpot, Salesforce) directly to Cold Storage. Executes immediate PII redaction and assigns a unified mcp_root_id.
TRANSFORM: Processes buffered Hot Tier records, executes PII redaction and identity stitching, and migrates the records to the Cold Storage Tier.
No output schemas documented. Tools return JSON strings but LLMs cannot infer response structure (fields, types, pagination). Breaks downstream tool chaining and forces parsing guesswork.
payload_json parameters accept raw strings with no validation hints. Descriptions lack format constraints (valid JSON, max size, required fields). LLMs may pass malformed payloads.
source_system and target_warehouse parameters lack enum constraints. Descriptions mention examples ('hubspot', 'salesforce', 'SNOWFLAKE') but no formal enum. LLMs may hallucinate invalid values.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | D | 59 | 2026-07-28+ | v2 |
Error responses (BACKPRESSURE_LIMIT_EXCEEDED, SECURITY_SIGNATURE_MISMATCH) lack recovery guidance. No hint to LLM on whether to retry, ask user, or abort. Violates recovery-guide pattern.
Tool descriptions do not explain WHEN to use each tool vs. alternatives. 'EXTRACT' and 'LOAD' labels are internal jargon. LLMs need explicit guidance on hot vs. cold tier semantics and when to call each.