Mismatching persisted queries and schema
Description
Your persisted queries are not aligning with your schema, which leads to unusable queries due to mistyping.
Remediation
To remediate mismatching persisted queries and schema, follow these steps:
- Update persisted queries to align with the current schema.
- Validate persisted queries against the updated schema before deployment.
- Implement a versioning system for the schema to manage changes.
- Use automated tools to detect and alert on mismatches.
- Establish a process for deprecating and removing outdated queries.
- Ensure backward compatibility during schema updates when possible.
- Regularly audit and test persisted queries for compliance with the schema.
- Educate developers on best practices for maintaining query and schema compatibility.
Configuration
Identifier:
schema/mismatching_persisted_queries_and_schema
Examples
Ignore this check
checks:
schema/mismatching_persisted_queries_and_schema:
skip: true
Score
- Escape Severity: MEDIUM
Compliance
- OWASP: API8:2023
- OWASP LLM: LLM02:2023
- pci: 6.5.10
- gdpr: Article-5
- soc2: CC6
- psd2: Article-94
- iso27001: A.14.2
- nist: SP800-95
- fedramp: CM-3
Classification
- CWE: 20
Score
- CVSS_VECTOR: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:L/A:N
- CVSS_SCORE: 4.3