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
"""AuditLog ORM model — append-only event store."""
import uuid
from datetime import UTC, datetime
from sqlalchemy import BigInteger, DateTime, ForeignKey, SmallInteger, String
from sqlalchemy.dialects.postgresql import INET, JSONB, UUID
from sqlalchemy.orm import Mapped, mapped_column
from app.db.database import Base
class AuditLog(Base):
"""Immutable audit event. Never update or delete rows; enforced by DB trigger."""
__tablename__ = "audit_log"
id: Mapped[uuid.UUID] = mapped_column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
tenant_id: Mapped[uuid.UUID] = mapped_column(
UUID(as_uuid=True), ForeignKey("tenants.id", ondelete="CASCADE"), nullable=False, index=True
)
actor_id: Mapped[uuid.UUID | None] = mapped_column(UUID(as_uuid=True), ForeignKey("users.id", ondelete="SET NULL"), nullable=True)
actor_email: Mapped[str | None] = mapped_column(String(255), nullable=True)
actor_ip: Mapped[str | None] = mapped_column(INET, nullable=True)
action: Mapped[str] = mapped_column(String(200), nullable=False)
resource: Mapped[str | None] = mapped_column(String(200), nullable=True)
resource_id: Mapped[str | None] = mapped_column(String(200), nullable=True)
changes: Mapped[dict | None] = mapped_column(JSONB, nullable=True)
metadata_: Mapped[dict | None] = mapped_column("metadata", JSONB, nullable=True)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=lambda: datetime.now(UTC), nullable=False)
# Tamper-evident hash chain. ``prev_hash`` is the ``entry_hash`` of
# the previous audit row for the same tenant; ``entry_hash`` is a
# sha256 digest over the canonical serialization of this row mixed
# with ``prev_hash``. See migration 043_audit_log_hash_chain.sql
# and ``app.services.audit_hash`` for the canonical algorithm.
prev_hash: Mapped[str | None] = mapped_column(String(64), nullable=True)
entry_hash: Mapped[str | None] = mapped_column(String(64), nullable=True)
# Chain position, assigned under the ``audit_chain_head`` row lock so a
# replay reads rows in the order the writer chained them. Inferring that
# order from ``(created_at, id)`` ties on a random UUID when two rows
# share a microsecond, which can order a replay differently from the way
# it was written. NULL on rows predating migration 074.
chain_index: Mapped[int | None] = mapped_column(BigInteger, nullable=True)
# 1 = the pre-074 writer, which could fork under concurrency. 2 = the
# serialized appender. Set by the writer, not defaulted by the schema —
# see migration 074.
chain_epoch: Mapped[int] = mapped_column(SmallInteger, nullable=False, default=1)