{"product_id":"n8n-mcp-compliance-register-discord-audit-logs","title":"n8n MCP Compliance Register + Discord Audit Logs","description":"\u003ch3\u003eKeep your n8n MCP tool usage compliant—with an audit trail you can trust\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow exposes a \u003cstrong\u003ecompliance register as an authenticated MCP server\u003c\/strong\u003e, complete with \u003cstrong\u003eread tools\u003c\/strong\u003e for looking up records and viewing call history, plus a \u003cstrong\u003epolicy-guarded write tool\u003c\/strong\u003e that logs every attempt. It also posts a \u003cstrong\u003eweekly compliance audit\u003c\/strong\u003e to \u003cstrong\u003eDiscord\u003c\/strong\u003e via webhook.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOne-time setup:\u003c\/strong\u003e Run “Set Up Tables (run once)” to create three n8n Data Tables: \u003cem\u003etool policy\u003c\/em\u003e, \u003cem\u003emcp_calls\u003c\/em\u003e, and \u003cem\u003ecompliance register\u003c\/em\u003e. It upserts an \u003cstrong\u003eallow list\u003c\/strong\u003e and loads \u003cstrong\u003edemo register records\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthenticated MCP server endpoint:\u003c\/strong\u003e The workflow exposes an MCP server protected with \u003cstrong\u003ebearer authentication\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTool: lookup_record (read):\u003c\/strong\u003e Queries the compliance register table by \u003cstrong\u003erecord reference\u003c\/strong\u003e and returns up to \u003cstrong\u003e5 matching rows\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTool: read_call_log (read):\u003c\/strong\u003e Returns the most recent entries from \u003cstrong\u003emcp_calls\u003c\/strong\u003e (up to \u003cstrong\u003e25 rows\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTool: add_note (write, policy-guarded):\u003c\/strong\u003e Accepts a single-string request, checks the request against the \u003cstrong\u003emcp_tools allow list\u003c\/strong\u003e, verifies the referenced record exists, and enforces a \u003cstrong\u003eper-day call cap\u003c\/strong\u003e using today’s allowed calls in \u003cem\u003emcp_calls\u003c\/em\u003e. If permitted, it appends a dated note to the matching register row—otherwise it refuses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudit logging:\u003c\/strong\u003e Every add_note attempt (allowed or refused) is recorded in \u003cstrong\u003emcp_calls\u003c\/strong\u003e and returned as plain-text to the MCP client.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly Discord audit:\u003c\/strong\u003e Every Monday at \u003cstrong\u003e08:00\u003c\/strong\u003e, it summarizes the last \u003cstrong\u003e7 days\u003c\/strong\u003e of calls and posts either an \u003cstrong\u003eescalation\u003c\/strong\u003e or a quiet status message to \u003cstrong\u003eDiscord\u003c\/strong\u003e via webhook.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCompliance teams managing controlled access to records through MCP in n8n.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators needing an auditable trail of every MCP tool call and refusal.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers enforcing daily caps and tool allow lists for safer agent workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUses n8n nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ediscord\u003c\/strong\u003e, \u003cstrong\u003edata table\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eImplements MCP tools: \u003cstrong\u003elookup_record\u003c\/strong\u003e, \u003cstrong\u003eread_call_log\u003c\/strong\u003e, and \u003cstrong\u003eadd_note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eStores data in n8n Data Tables: \u003cem\u003etool policy\u003c\/em\u003e, \u003cem\u003emcp_calls\u003c\/em\u003e, and \u003cem\u003ecompliance register\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008798675123,"sku":"N8N-19482","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Y-1KxVPZ8HwWuhiaUJrqY_PbbPdQGu.png?v=1789204594","url":"https:\/\/buyflowscripts.com\/products\/n8n-mcp-compliance-register-discord-audit-logs","provider":"N8N Commerce","version":"1.0","type":"link"}