📋

Compliance Report Generator

Query audit data, verify against policies, and generate a compliance report

Data 4 steps 4 tools 4 servers

Example Prompt

Generate a SOC 2 compliance report for Q4 covering access controls and change management

About

Generates a compliance report by querying audit logs and access records from your database, reasoning through policy requirements to identify violations or gaps, and producing a structured report. The report includes pass/fail status for each policy control, evidence references, and recommended remediation steps.

Workflow Steps

Query the audit log database for access events, changes, and user activity within the reporting period

📊 Run SQL Query

Search Elasticsearch for security events and anomalies flagged during the period

🔎 Search Index

Reason through each policy control to determine pass/fail status based on collected evidence

🧠 Structured Reasoning

Generate the structured compliance report with findings, evidence, and remediation recommendations

✏️ Write File

Tools Used

🔎

Search Index

Run a full-text or structured query against an Elasticsearch index

Data

✏️

Write File

Write or overwrite a file at a specified path with the given content

Developer

📊

Run SQL Query

Execute a read-only SQL query against a PostgreSQL database and return results

Data

🧠

Structured Reasoning

Break down a complex problem into sequential reasoning steps with explicit chain-of-thought

General

Required MCP Servers

🔍

Elasticsearch

Search, index, and analyze data in Elasticsearch clusters with full-text queries

Data API Key

📁

Filesystem

Read, search, and manage files on the local filesystem

Productivity

🐘

PostgreSQL

Query, inspect, and manage PostgreSQL databases with full SQL support