🎃 Export the audit log as CSV or JSON from /logs
Los mantenedores suelen responder en 1 día
Nadie ha tomado este issue todavía.
Evaluación
- Dificultad
- 3/5
- Tiempo estimado
- 1-2 días
- Aptitud para principiantes
- 68/100
- Tipo de issue
- Nueva funcionalidad
- Claridad
- Bien especificado
- Estado de actividad
- Activo
- Stack tecnológico
- typescript
Línea de trabajo
Start with the list filters in packages/backend/src/audit/audit.controller.ts and orgScope()/getRecentInvocations() in audit.service.ts; then read the logs page and audit client paths listed in the issue. Run the backend tests with cd packages/backend && npm test and add the specified CSV utility tests. Done means the streamed export honors filters, admin and organization restrictions, row cap and truncation header, with the frontend button and API docs updated.
Escrito por el modelo de indexación a partir del texto del issue.
Descripción
Part of the October Challenge #846.
Why
The Audit Log page (/logs) only lets you page through tool calls 50 at a time. Admins who need to send a compliance report, look into an incident in a spreadsheet, or attach evidence to a support ticket have nothing to download. Most API gateways and MCP platforms (Kong, Tyk, Apigee, Postman monitors) have a "download logs" button. This issue adds a streamed export that applies the filters the user already has set.
Self-hosted vs Cloud
- Self-hosted: enabled in Community and Business. Not a Business feature: do not touch
ee/. - Cloud (
DEPLOYMENT_MODE=cloud): enabled, behaves the same. Cloud is multi-tenant, so the export must always be scoped to the caller's organization: refuse with 403 whenreq.user.organizationIdis not set, and never fall back to unscoped rows. One tenant can hold millions of rows (see the comment inbound-payload.ts), so the row cap and the throttle are required. - Who can use it:
ADMINonly (@Roles('ADMIN')+RolesGuard). Every role can view the list today, but a bulk download of the whole org's call payloads is a bigger step, so it is limited to admins. Hide the button for other roles. The data is always filtered to the caller's organization.
What to build
- Backend:
GET /api/audit/invocations/export?format=csv|jsoninaudit.controller.ts. It takes the same filters as the list (status,search,connectorId,mcpServerId,toolId) plus optional ISOfrom/tooncreatedAt. - Move the
whereconstruction out ofgetRecentInvocations()into one helper (e.g.buildInvocationWhere(filters)) that both the list and the export call, so the two cannot drift apart. - Stream the response: read in batches (e.g. 1000 rows, keyset pagination on
createdAt/id, newest first) and write each batch tores. Never load everything into memory. Cap atAUDIT_EXPORT_MAX_ROWS(default50000). SendX-Export-Truncated: truewhen the cap was hit (do acountfirst). SetContent-Disposition: attachment; filename="anythingmcp-logs-YYYY-MM-DD.csv". Throttle with@Throttle({ default: { limit: 5, ttl: 60_000 } }). - Columns (only data the page already shows):
createdAt(ISO),status,durationMs,tool,connector,connectorType,mcpServer,userEmail,authMethod,apiKeyName,error. JSON additionally includes theinput/outputexcerpts exactly as stored. Do not exportintent,costMicros,usedProxy, the rawclientInfoblob, internal ids other than the invocation id, or anything else the UI does not show. - CSV safety: RFC 4180 quoting (wrap in quotes, double any
"), and escape formula injection: prefix any cell that starts with=,+,-,@, tab or CR with'. Put this in a small pure function (e.g.packages/backend/src/audit/csv.util.ts) so it can be unit-tested. JSON: either one array or NDJSON. Pick one and document it. - Frontend: an "Export" button (with a CSV/JSON choice) in the page
actionsnext to Refresh. Call it with the current filters,fetchwith the Bearer token, download the result as a Blob (same pattern asconnectors/page.tsx:139-149), and show a notice whenX-Export-Truncatedis set. Add anaudit.exportInvocations()helper inlib/api.ts. The sharedrequest()helper parses JSON, so it can't be used for the file.
Where to look
packages/backend/src/audit/audit.controller.ts:13-38: the list endpoint and its filters.packages/backend/src/audit/audit.service.ts:176-225:orgScope()andgetRecentInvocations().packages/backend/src/audit/bound-payload.ts:16:_amcp_truncatedmarker. Stored payloads are excerpts, so don't try to recover full bodies.packages/backend/src/knowledge-graph/kg.controller.ts:22,52:RolesGuard+@Roles('ADMIN')pattern.packages/backend/src/auth/login.controller.ts:137:@Throttlepattern.packages/backend/src/auth/login.controller.ts:87:@Res()usage with Express.packages/frontend/src/app/logs/page.tsx:116-134(filters),:183-207(theexportButtonvariable is actually Refresh; rename it),:204-208(actions).packages/frontend/src/app/settings/layout.tsx:54:user?.role === 'ADMIN'check.packages/frontend/src/lib/api.ts:735-747:auditclient.
Acceptance criteria
- Export applies every active filter, and only the caller's org rows are ever returned (unit test:
organizationIdis in thewhere; a missing org gives 403). - Non-admins get 403, and the button is hidden for them.
- Results are streamed in batches, the row cap is honored, and the truncation header is set.
-
csv.util.spec.tscovers quoting, newlines inside cells, and=cmd|' /C calc'!A0-style injection. -
audit.service.spec.ts/ a new controller spec covers the shared where-builder (cd packages/backend && npm test). -
docs/api-reference.mdAudit section (line 219) documents the endpoint. Also fix the existing examples at lines 226-236, which usetoolName/from/toparams the list endpoint does not support.
Out of scope
- Scheduled exports, emailing exports, S3/SIEM push.
- Exporting security events or product events.
- Changing what is stored in
tool_invocations, or the retention policy.
Size
M (1–2 days)
How to claim
Comment "I'd like to work on this" and we'll assign you. Rules in #846.
- Lenguaje dominante
- TypeScript
- Estrellas
- 856
- Forks
- 82
- Merge medio
- 5 h 18 min
- PR fusionados (30 d)
- 162
Preparar el entorno
Este proyecto no incluye contenedor de desarrollo, Dockerfile ni guía de contribución, así que la configuración corre por tu cuenta: empieza por su README y consulta nuestra guía para la primera contribución para los pasos generales.
Primeros pasos
- Lee el issue completo y luego la guía de contribución del proyecto.
- Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
- Haz un fork del repositorio y trabaja en una rama.
- Abre un pull request que haga referencia al número del issue.
Más de HelpCode-ai/anythingmcp
-
Docs: document all SMTP_* and other undocumented env vars for self-hostingPosiblemente ocupada @notlakshitha la tomó hace 2 días. Abiertoenhancement
Dificultad 2/5 1-3 horas Aptitud para principiantes 82/100
HelpCode-ai/anythingmcp#1049 · 3 comentarios ·
Los mantenedores suelen responder en 1 día
-
good first issue hacktoberfest
Dificultad 2/5 Medio día Aptitud para principiantes 70/100
HelpCode-ai/anythingmcp#996 ·
Los mantenedores suelen responder en 1 día
-
good first issue hacktoberfest
Dificultad 2/5 Medio día Aptitud para principiantes 72/100
HelpCode-ai/anythingmcp#995 ·
Los mantenedores suelen responder en 1 día
-
enhancement good first issue hacktoberfest help wanted
Dificultad 2/5 1-3 horas Aptitud para principiantes 78/100
HelpCode-ai/anythingmcp#982 ·
Los mantenedores suelen responder en 1 día
-
Upload the new social previewPosiblemente ocupada @helpcodeai la tomó hace 2 días. Abierto
HelpCode-ai/anythingmcp#1087 · 6 comentarios · 1 asignado ·
Los mantenedores suelen responder en 1 día
Todos los issues de HelpCode-ai/anythingmcp
Issues similares
-
bug
Dificultad 2/5 1-3 horas Aptitud para principiantes 80/100
aws/agentcore-cli#2606 ·
Los mantenedores suelen responder en 1 día
-
ai-driven-qa bug Cosmetic
Dificultad 2/5 1-3 horas Aptitud para principiantes 74/100
Los mantenedores suelen responder en 1 día
-
ai-driven-qa bug claude Minor
Dificultad 2/5 1-3 horas Aptitud para principiantes 64/100
linagora/twake-mail-admin#301 ·
Los mantenedores suelen responder en 1 día
-
Dificultad 2/5 1-3 horas Aptitud para principiantes 75/100
Los mantenedores suelen responder en 1 día
-
reproduced
Dificultad 2/5 1-3 horas Aptitud para principiantes 70/100
anomalyco/opencode#56038 · 1 comentario ·
Los mantenedores suelen responder en 1 día