SQL Query Telemetry PII Scrubber & Parameterization Masker
sanitize_sql_telemetryMasks PII, financial values, and credential literals in raw SQL query logs and slow-query dumps before telemetry storage, so production logs can be safely shipped to APM tools or external collectors.
Instructions
Masks PII, financial values, and credential literals from raw SQL query logs and slow-query dumps before telemetry storage. Use when scrubbing production database query logs before shipping to APM tools, Datadog, or external log collectors; for auditing SQL injection vulnerabilities, use audit_sql_injection_ast instead. Stateless read-only edge call (max 32 KB, 60 RPM): accepts 'query_logs' ('masking_policy' defaults to 'mask_pii_and_literals'), supports '?demo=true' or L402 (10 sats), and returns HTTP 400 if invalid.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| hash_salt | No | Optional salt string for deterministic pseudonymization of user IDs. | |
| query_logs | Yes | Raw SQL query text or multi-line database query log strings requiring sanitization. | |
| masking_policy | No | Scrubbing rigor policy: mask PII and literals, anonymize all constants, or strict AST parameterization. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sanitized_logs | Yes | Clean query logs with sensitive constants replaced by parameter placeholders. | |
| parameterized_templates | Yes | Normalized abstract query patterns suitable for APM metrics grouping. | |
| redacted_literals_count | Yes | Total number of strings, numbers, and PII literals scrubbed from logs. |