SQL Query Telemetry PII Scrubber & Parameterization Masker
sanitize_sql_telemetryMasks PII, financial values, and credentials in raw SQL query logs and slow-query dumps before telemetry storage or APM ingestion.
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. |