Skip to content

armgit / AiSOC

Public Imported from GitHub
0

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.

734 B
Raw Blame
-- AiSOC WS-B4: Detection-as-Code git PR path
-- Author: Beenu - [email protected]
--
-- Adds `github_pr_url` to `detection_rule_proposals` so the promote
-- endpoint can link each promoted proposal to the GitHub Pull Request
-- that carries the Sigma/YARA rule file into the detections/ directory.
-- The URL is optional — deployments without AISOC_GITHUB_TOKEN configured
-- will leave it NULL and the UI omits the link.

ALTER TABLE detection_rule_proposals
    ADD COLUMN IF NOT EXISTS github_pr_url TEXT;

COMMENT ON COLUMN detection_rule_proposals.github_pr_url IS
    'GitHub Pull Request URL created when this proposal was promoted (e.g. https://github.com/org/repo/pull/42). NULL when GitHub integration is not configured.';