What problem does it solve? Auditing toll tariffs requires understanding a two-layer diagnosis system (algorithmic diagnostico vs human status), Patrón A/B detection, and a CSV/Excel upload wizard, all split between a read-only remote DESARROLLO database and a local Supabase CLI environment. This Skill guides inspection, diagnosis, and safe implementation of tariff normalization changes without risking unauthorized writes to production data. ## Core Features & Use Cases - Algorithm advisory: Explains and troubleshoots the peajes_normalizar_tarifas and peajes_recalcular_tarifas RPCs, the full diagnosis tree (MUESTRA_INSUFICIENTE, TARIFA_UNICA, CATEGORIA, POSIBLE_HORARIO, REVISAR), and invariants like RN-05 and RN-15. - CSV/Excel upload guidance: Covers the wizard pipeline, text-based CSV parsing (avoiding SheetJS numeric coercion of Argentine formats like 19.985,09), delimiter detection, and Strategy/Builder transformation codes such as CONVERTIR_NUMERO_ARS. - Environment safety: Enforces read-only MCP inspection of DESARROLLO and restricts all SQL edits to local Supabase CLI migrations with pgTAP tests. - Use Case: A user asks why a toll station's tariffs are stuck in REVISAR status; the Skill inspects tarifas_normalizadas via read-only MCP queries, checks dispersion thresholds, and recommends a migration fix tested locally. ## Quick Start Ask the assistant to inspect why a specific toll station's tariffs show a given diagnostico in DESARROLLO and recommend whether to keep, fix, or implement a change.
