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¶
Score¶
- Escape Severity:
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