Open-source AI Security Operations Center: alert fusion, LLM-agent triage, MITRE ATT&CK investigation, and a replayable decision ledger for every agent step. Self-hostable, runs with no API keys, MIT licensed. Ships an MCP server for Claude, Cursor and Continue.
Python agentic-aiai-securityalert-triageblue-teamcybersecuritydetection-engineeringincident-responselanggraphllm-agentsmcpmitre-attackmodel-context-protocolpurple-teamsecurity-operationsself-hostedsiemsoarsocthreat-detectionthreat-intelligence
-- 101b: fix the jsonb null test (jsonb 'null' is not SQL NULL).
CREATE OR REPLACE FUNCTION public.audit_log_immutable()
RETURNS trigger
LANGUAGE plpgsql
AS $fn$
DECLARE
key text;
old_row jsonb := to_jsonb(OLD);
new_row jsonb := to_jsonb(NEW);
BEGIN
-- The trigger is BEFORE UPDATE **OR DELETE** (migration 004), and both
-- arms run this one function. On DELETE there is no NEW, so
-- `jsonb_object_keys(NULL)` yields no rows, the loop below never runs,
-- and `RETURN NEW` returns NULL -- which in a BEFORE trigger silently
-- *cancels* the statement. The row survives and the caller is told
-- nothing, so a deployment would read "DELETE 0" as success while
-- immutability quietly stopped being enforced as an error.
--
-- DELETE is refused first and unconditionally, the way 004 refused it.
IF TG_OP = 'DELETE' THEN
RAISE EXCEPTION 'audit_log rows are immutable (attempted %)', TG_OP;
END IF;
FOR key IN SELECT jsonb_object_keys(new_row) LOOP
IF old_row -> key IS DISTINCT FROM new_row -> key THEN
-- The ONE legal mutation, pinned to its column: only actor_id
-- carries ON DELETE SET NULL. audit_log has ten nullable columns
-- (actor_email, actor_ip, resource, resource_id, changes,
-- metadata, prev_hash, entry_hash, chain_index); a blanket
-- value->NULL exemption would let one UPDATE strip every fact an
-- auditor reads while the trigger stayed silent. Review #1231
-- reproduced exactly that on Postgres 16; this guard refuses it.
IF key = 'actor_id'
AND jsonb_typeof(old_row -> key) <> 'null'
AND jsonb_typeof(new_row -> key) = 'null'
THEN
CONTINUE;
END IF;
RAISE EXCEPTION 'audit_log rows are immutable (attempted UPDATE of %)', key;
END IF;
END LOOP;
RETURN NEW;
END;
$fn$;