Is this vulnerability remotely exploitable?

Yes. Any user who can reach the SiYuan HTTP(S) interface and holds valid credentials can remotely send requests to `/api/query/sql` and execute arbitrary SQL, assuming the endpoint is exposed on a network-accessible interface.

What level of access does an attacker need to exploit this issue?

An attacker needs only a low-privilege, authenticated account (such as a reader). No administrative role or elevated application permissions are required, because the endpoint does not perform proper authorization checks.

What is the safest general fix pattern for this kind of vulnerability?

The safest pattern is to remove or strictly encapsulate raw SQL execution from public APIs, and to ensure that any remaining high-impact operations are guarded by robust, role-based authorization checks. Only explicitly authorized admin users should be able to perform direct database operations, and even then, only through carefully controlled interfaces.

Severity:

HIGH RISK

(8.8)

SQL Query Abuse & Missing Authorization (CWE-89, CWE-862) in SiYuan /api/query/sql Endpoint

CVE-2026-29073

Published:

Mar 6, 2026

Status:

Analyzed

Summary

Affected Context

Exploit Preconditions

Why This Happens

Potential Impact

General Mitigation Guidance

How Teams Detect Issues Like This

Frequently Asked Questions

Source

NDV

Recent Vulnerabilities

CWE-918

HIGH RISK

HIGH

(8.6)

Server-Side Request Forgery (CWE-918) in OpenClaw Zalo Plugin sendPhoto

Unauthorized Access to Internal Resources via SSRF

May 6, 2026

CWE-863

HIGH RISK

HIGH

(8.8)

Authorization Bypass (CWE-863) in OpenClaw Matrix Room Control Commands

Privilege Escalation via Bypassed Access Control

May 6, 2026

Vulnerability Type

Category:

Improper Access Control / SQL Query Abuse

CWE:

CWE-89;CWE-862

Impact:

Privilege Escalation and Data Compromise via Arbitrary SQL Execution

Severity:

HIGH RISK

(8.8)

CVSS Version:

3.1

Vulnerability Type

Category:

Improper Access Control / SQL Query Abuse

CWE:

CWE-89;CWE-862

Impact:

Privilege Escalation and Data Compromise via Arbitrary SQL Execution

Severity:

HIGH RISK

(8.8)

CVSS Version:

3.1

Catch This CVE While Code Is Being Written

Detect vulnerable code directly in pull requests, so CVEs are fixed before merge.

Get Started

Ship clean & secure code faster

Start Free Trial

Get Pentest Report

Ship clean & secure code faster

Start Free Trial

Get Pentest Report

Ship clean & secure code faster

Start Free Trial

Get Pentest Report

CodeAnt AI is an offensive and defensive security platform.

Defensive + offensive security.

From first line of code to a pentest
that knows every line of it.

SOC 2 Type II certified | CodeAnt AI is independently audited and compliant with SOC 2 Type II security standards

Ask AI for summary of CodeAnt

Defensive + offensive security.

From first line of code to a pentest
that knows every line of it.

Ask AI for summary of CodeAnt

Defensive + offensive security.

From first line of code to a pentest
that knows every line of it.

Ask AI for summary of CodeAnt

SQL Query Abuse & Missing Authorization (CWE-89, CWE-862) in SiYuan /api/query/sql Endpoint

Summary

Affected Context

Exploit Preconditions

Why This Happens

Potential Impact

General Mitigation Guidance

How Teams Detect Issues Like This

Frequently Asked Questions

Source

Recent Vulnerabilities

HIGH RISK

HIGH

(8.6)

Server-Side Request Forgery (CWE-918) in OpenClaw Zalo Plugin sendPhoto

HIGH RISK

HIGH

(8.8)

Authorization Bypass (CWE-863) in OpenClaw Matrix Room Control Commands

Vulnerability Type

Vulnerability Type

Vulnerability Type

Catch This CVE While Code Is Being Written

Ship clean & secure code faster

Ship clean & secure code faster

Ship clean & secure code faster

Product

Compare

Company

Developers

Legal

Product

Compare

Company

Developers

Legal

Product

Compare

Company

Developers

Legal