ET WEB_SPECIFIC_APPS AppSmith PostgreSQL Command Injection Attempt (CVE-2024-55963)

alert http any any -> $HOME_NET any (
    msg:"ET WEB_SPECIFIC_APPS AppSmith PostgreSQL Command Injection Attempt (CVE-2024-55963)";
    flow:established,to_server;
    http.method;
    content:"POST";
    http.uri;
    content:"/api/v1/datasources"; startswith;
    content:"/schema-preview"; endswith;
    http.header;
    content:"X-Requested-By|3a 20|Appsmith"; fast_pattern;
    content:"x-anonymous-user-id|3a 20|";
    http.request_body;
    content:"title";
    content:"body";
    content:"copy"; nocase; within:30;
    content:"from program|20 27|"; nocase; within:100;
    content:"suggested";
    content:"True"; within:30;
    reference:cve,2024-55963;
    reference:url,rhinosecuritylabs.com/research/cve-2024-55963-unauthenticated-rce-in-appsmith/;
    classtype:attempted-admin;
    sid:2061291; rev:1;
    metadata:affected_product Appsmith, attack_target Web_Server, tls_state plaintext, created_at 2025_04_04, cve CVE_2024_55963, deployment Perimeter, deployment Internal, performance_impact Low, confidence High, signature_severity Major, updated_at 2025_04_04, mitre_tactic_id TA0001, mitre_tactic_name Initial_Access, mitre_technique_id T1190, mitre_technique_name Exploit_Public_Facing_Application;
    target:dest_ip;
)