.github/9
ISSUE_TEMPLATE/3bug_report.md config.yml feature_request.md
workflows/3ci.yml clean-clone.yml release.yml
CODEOWNERS dependabot.yml pull_request_template.md
apps/630
api/250
src/243
common/30
__tests__/3authorize.test.ts bigint-serialization.interceptor.test.ts files-limits.test.ts
filters/1all-exceptions.filter.ts
guards/3auth.guard.ts internal-service.guard.ts rate-limit.guard.ts
interceptors/2actor-context.interceptor.ts bigint-serialization.interceptor.ts
middleware/2idempotency.test.ts idempotency.ts
pipes/1zod-validation.pipe.ts
actor-context.ts audit.service.ts cache.test.ts cache.ts cookies.ts core.module.ts deprecation.ts email.service.ts errors.ts event-bus.ts log-scrubber.test.ts log-scrubber.ts logger.ts permission-cache-bridge.ts prisma.service.ts redis.service.ts trace-metadata.ts types.ts
config/1env.ts
lib/11
__tests__/5crypto.test.ts filter-builder.test.ts jwt.test.ts pagination.test.ts positions.test.ts
authorize.ts crypto.ts filter-builder.ts jwt.ts pagination.ts positions.ts
modules/197
ai/28
__tests__/4ai-writing.test.ts database-ai.test.ts generate-executor.test.ts prompts.test.ts
generator/4executor.ts generate.controller.ts generate.dto.ts generate.service.ts
ai-chat.service.ts ai-rate-limit.ts ai-writing.controller.ts ai-writing.dto.ts ai-writing.service.ts ai.controller.ts ai.module.ts ai.service.ts budget-guard.service.ts database-ai.controller.ts database-ai.dto.ts database-ai.service.ts db-prompts.ts dto.ts gateway-provider.ts ledger.service.ts prompts.ts rag.controller.ts rag.dto.ts rag.service.ts
api-keys/3api-keys.controller.ts api-keys.module.ts api-keys.service.ts
audit/2audit-log.controller.ts audit.module.ts
auth/4auth.controller.ts auth.module.ts auth.service.ts dto.ts
automations/5automations.controller.ts automations.module.ts automations.service.ts dto.ts webhook-incoming.controller.ts
blocks/5
__tests__/1batch-version-cas.test.ts
block.service.ts blocks.controller.ts blocks.module.ts dto.ts
comments/4comments.controller.ts comments.module.ts comments.service.ts dto.ts
databases/9
__tests__/3normalize-select-options.test.ts option-id-canonicalization.test.ts record-open-query-shape.test.ts
database.service.ts databases.controller.ts databases.module.ts dto.ts property-cache-schema.ts query.service.ts
docs/2docs.controller.ts docs.module.ts
files/10
__tests__/1quota.test.ts
dto.ts files.controller.ts files.module.ts files.service.ts quota.ts record.ts s3.ts uploads.controller.ts uploads.service.ts
forms/18debug.controller.ts form.dto.ts forms.controller.ts forms.module.ts forms.service.ts markdown.test.ts markdown.ts optional-auth.guard.ts public-forms.controller.ts public-forms.service.ts question.dto.ts questions.service.ts rate-limit.ts recaptcha.ts slug.ts submissions.controller.ts submissions.service.ts submit-schema.ts
health/3health.controller.ts health.module.ts health.service.ts
integrations/3integrations.controller.ts integrations.module.ts integrations.service.ts
internal/12
__tests__/2flush-query-shape.test.ts internal.endpoints.test.ts
ai-test-seam.controller.ts ai-test-seam.dto.ts ai-test-seam.service.ts internal.controller.ts internal.dto.ts internal.module.ts internal.service.ts test-seam.controller.ts test-seam.dto.ts test-seam.service.ts
notifications/3notifications.controller.ts notifications.module.ts notifications.service.ts
oauth/6
__tests__/1oauth.scopes.test.ts
oauth.controller.ts oauth.module.ts oauth.service.ts scopes.ts token-keys.ts
org/15audit.service.ts embed-preview.controller.ts guards.ts members.service.ts org-admin.controller.ts org-policy.service.ts org.module.ts overview.service.ts policy-effective.controller.ts policy.schema.ts policy.test.ts retention.service.ts totp.test.ts totp.ts two-factor.service.ts
orgs/5dto.ts orgs.controller.ts orgs.module.ts orgs.service.ts util.ts
pages/4dto.ts page.service.ts pages.controller.ts pages.module.ts
scim/15
__tests__/3email-mapping.test.ts etag.test.ts filters.test.ts
etag.ts filters.ts groups.service.ts schemas.ts scim-admin.controller.ts scim-admin.service.ts scim-auth.guard.ts scim-auth.service.ts scim-errors.ts scim.controller.ts scim.module.ts users.service.ts
search/4
__tests__/1search.service.test.ts
search.controller.ts search.module.ts search.service.ts
sessions/3sessions.controller.ts sessions.module.ts sessions.service.ts
share/3share.controller.ts share.module.ts share.service.ts
sso/16
__tests__/4enforcement.test.ts oidc.verify.test.ts provisioning.test.ts saml.validate.test.ts
enforcement.ts oidc.controller.ts oidc.service.ts oidc.ts provisioning.service.ts saml.controller.ts saml.ts schemas.ts sso-admin.controller.ts sso-admin.service.ts sso-secrets.ts sso.module.ts
teams/4dto.ts teams.controller.ts teams.module.ts teams.service.ts
users/4dto.ts users.controller.ts users.module.ts users.service.ts
webhooks/3webhooks.controller.ts webhooks.module.ts webhooks.service.ts
workspaces/4dto.ts workspaces.controller.ts workspaces.module.ts workspaces.service.ts
types/1xmldom.d.ts
app.module.ts constants.ts main.ts
_probe_rawbody.cjs .env.example Dockerfile package.json README.md tsconfig.json vitest.config.ts
realtime/33
src/17auth.ts comments.ts config.ts event-source.ts http-store.ts index.ts metrics.ts notifications.ts page-updated-source.ts presence.ts prisma-store.ts protocol.ts rate-limit.ts room-key.ts rooms.ts server.ts update-log.ts
test/11auth.test.ts config.test.ts event-source.test.ts http-store.test.ts metrics-merge.test.ts page-updated-source.test.ts presence.test.ts protocol.test.ts rate-limit.test.ts rooms.test.ts task-0094-builders.test.ts
.env.example Dockerfile package.json README.md tsconfig.json
web/255
src/244
app/45
__tests__/1theme-tokens.test.ts
(app)/26
w/25
[workspace]/25
ask/1page.tsx
databases/1
[id]/1page.tsx
favorites/1page.tsx
files/1page.tsx
notifications/1page.tsx
page/4
[id]/4
[block]/1page.tsx
share/1page.tsx
layout.tsx page.tsx
search/1page.tsx
settings/10
appearance/1page.tsx
automations/3
[id]/1page.tsx
new/1page.tsx
page.tsx
billing/1page.tsx
developers/1page.tsx
members/1page.tsx
permissions/1page.tsx
teams/1page.tsx
page.tsx
shared/1page.tsx
templates/1page.tsx
trash/1page.tsx
layout.tsx page.tsx
layout.tsx
(auth)/4
login/1page.tsx
register/1page.tsx
reset-password/1page.tsx
layout.tsx
api/2
metrics/1route.ts
v1/1
health/1route.ts
f/1
[slug]/1page.tsx
health/1
ready/1route.ts
org/2
[orgId]/2
admin/2
integrations/1page.tsx
page.tsx
share/1
[id]/1page.tsx
error.tsx global-error.tsx globals.css layout.tsx not-found.tsx page.tsx providers.tsx
components/118
admin/10
org-admin/8ApiKeysTab.tsx AuditTab.tsx MembersTab.tsx OverviewTab.tsx PoliciesTab.tsx RetentionTab.tsx WebhooksTab.tsx WorkspacePicker.tsx
ScimCard.tsx SsoTabs.tsx
ai/6ai-panel.tsx ask-ai-submenu.tsx db-ai-dialog.tsx generate-page-dialog.tsx writing-actions-menu.tsx writing-diff.tsx
automations/5action-editor.tsx condition-editor.tsx lib.ts run-history.tsx trigger-editor.tsx
collaboration/6CursorLayer.tsx OfflineBanner.tsx PresenceBar.tsx README.md ReviewFailedDialog.tsx StatusChip.tsx
comments/3comment-panel.tsx comment-thread.tsx mention-input.tsx
database/27
__tests__/2cell-editor.test.tsx cell-renderer.test.tsx
AiExtractDialog.tsx AiFormulaDialog.tsx AiGenerateDialog.tsx board-view.tsx buttons-panel.tsx calendar-view.tsx cell-editor.tsx cell-renderer.tsx chart-view.tsx database-page-view.tsx database-toolbar.tsx database-view-renderer.tsx db-embedded.tsx filter-builder.tsx form-builder-view.tsx formula-editor.tsx gallery-view.tsx group-builder.tsx list-view.tsx property-editor.tsx record-header.tsx record-panel.tsx sort-builder.tsx table-view.tsx timeline-view.tsx
dialogs/7
__tests__/1move-to-dialog.test.tsx
create-dialog.tsx dialog.tsx file-permissions-dialog.tsx invite-dialog.tsx move-to-dialog.tsx share-dialog.tsx
editor/19
__tests__/3code-block-text.test.ts code-block.test.tsx expandable.test.tsx
block-card.tsx block-renderer.tsx block-save-queue.ts block-toolbar.tsx context-menu.tsx expandable.tsx history-popover.tsx inline-editor.tsx insert-dialog.tsx page-canvas.tsx page-spinner.tsx page-view.tsx selection-toolbar.tsx slash-menu.tsx template-dialog.tsx type-menu.tsx
files/4FileBlock.tsx FileBrowser.tsx FilePicker.tsx PreviewModal.tsx
form/4form-field.tsx form-renderer.tsx form-responses-view.tsx form-view.tsx
layout/8
__tests__/1page-tree-icon.test.tsx
command-palette.tsx factory-logo.tsx page-tree-node.tsx sidebar.tsx theme-provider.tsx topbar.tsx workspace-shell.tsx
mentions/3
__tests__/1mention-model.test.ts
mention-model.ts MentionPopup.tsx
search/3ask-ai-search.tsx results-list.tsx search-dialog.tsx
settings/10
api-keys/4ApiKeyCreateDialog.tsx ApiKeyRevealDialog.tsx ApiKeyTable.tsx ScopesBadge.tsx
webhooks/5CurlExamples.tsx DeliveryInspector.tsx EventExplorer.tsx OverviewTab.tsx WebhooksTab.tsx
settings-shell.tsx
ui/3confirm-dialog.tsx form.tsx toaster.tsx
hooks/21
__tests__/4realtime-frame-handler.test.ts use-blocks.test.ts use-database-options.test.ts use-workspace.test.tsx
realtime-frame-handler.ts use-ai-stream.ts use-auth.ts use-blocks.ts use-database.ts use-db-ai-stream.ts use-forms.ts use-members.ts use-mention-sources.ts use-notifications.ts use-offline-status.ts use-pages.ts use-presence-announcer.ts use-presence-toasts.ts use-presence.ts use-realtime.ts use-workspace.ts
lib/50
__tests__/21ai-database.test.ts ai-generate.test.ts ai-sse.test.ts ai-writing.test.ts api-keys.test.ts api-members.test.ts auth-refresh.test.ts auth-store.test.ts batch-queue-drop.test.ts block-content.test.ts clipboard-import.test.ts code-highlight.test.ts offline-status.test.ts presence-announcer.test.ts presence-color.test.ts presence-cursor.test.ts presence-emitter.test.ts realtime-url.test.ts search.test.ts utils.test.ts writing-diff.test.ts
files/7
__tests__/2picker.test.ts upload.test.ts
api.ts picker.ts upload-store.ts upload.ts use-file-uploads.ts
ai-database.ts ai.ts api-keys.ts api.ts auth-store.ts batch-queue.ts block-content.ts clipboard-import.ts code-highlight.ts constants.ts offline-status.ts org-admin.ts presence-announcer.ts presence-color.ts presence-cursor.ts presence-editor-views.ts presence-emitter.ts query-client.ts realtime.ts search.ts types.ts utils.ts
stores/8
__tests__/1block-patch-store.test.ts
block-patch-store.ts comment-pill-store.ts database-store.ts editor-store.ts offlineQueue.ts presence-store.ts ui-store.ts
instrumentation.ts middleware.ts
.env.example Dockerfile next-env.d.ts next.config.mjs package.json postcss.config.mjs README.md tailwind.config.ts tsconfig.json tsconfig.tsbuildinfo vitest.config.ts
worker/92
src/87
__tests__/13ai-embedding.test.ts ai-request.test.ts ai-usage-budget.test.ts audit-export.test.ts email-decision.test.ts encrypt.test.ts health-search-index-lag.test.ts mime.test.ts retention.test.ts s3-sign.test.ts search-index.test.ts smtp.test.ts webhook-sign.test.ts
health/1server.ts
lib/12
__tests__/1clamav.test.ts
clamav.ts encrypt.ts job-otel.ts mime.ts notify.ts prisma.ts redis-stream.ts redis.ts s3.ts sharp.ts smtp.ts
processors/56
automations/28
__tests__/3condition-evaluator.spec.ts executors.spec.ts run-pipeline.spec.ts
executors/17assign-user.ts call-integration.ts change-status.ts classify.ts create-notification.ts create-page.ts email-cap.ts helpers.ts integration-registry.ts permission.ts record-write.ts registry.ts run-ai-action.ts send-email.ts send-webhook.ts types.ts update-record.ts
condition-evaluator.ts dead-letter.ts log.ts matcher.ts pipeline.ts run-state.ts schedule.ts watchdog.ts
files/15
__tests__/4errors.test.ts scan-gate.test.ts status.test.ts temp.test.ts
steps/4finalize.ts metadata.ts scan.ts thumbnails.ts
cleanup.ts errors.ts generateThumbs.ts processor.ts status.ts temp.ts types.ts
search-index/4builders.ts grants.ts index.ts processor.ts
ai-embedding.ts ai.processor.ts audit-export.ts automations.processor.ts email-decision.processor.ts email.processor.ts maintenance.processor.ts retention.ts webhooks.processor.ts
config.ts events.ts index.ts logger.ts queues.ts
.env.example Dockerfile package.json README.md tsconfig.json
docs/73
api/17ai.md authentication.md automations.md blocks.md comments.md databases.md files.md forms.md openapi.yaml org-admin.md pages.md scim.md search.md sso.md versioning.md webhooks.md workspaces.md
architecture/10ai-architecture.md automation.md backend-architecture.md database-architecture.md frontend-architecture.md realtime-architecture.md search-architecture.md security-architecture.md storage.md system-architecture.md
database/2database-architecture.md redis-keys.md
development/8admin-guide.md coding-standards.md deployment.md development-guide.md files-pipeline.md perf-report.md performance.md testing.md
product/4functional-requirements.md non-functional-requirements.md product-requirements.md ux-requirements.md
requirements/1requirements-matrix.md
security/5audit-report.md files.md forms.md license-allowlist.md security-architecture.md
tasks/16phase-00-foundation.md phase-01-authentication.md phase-02-workspace.md phase-03-pages.md phase-04-editor.md phase-05-databases.md phase-06-relations.md phase-07-collaboration.md phase-08-search.md phase-09-files.md phase-10-forms.md phase-11-automation.md phase-12-ai.md phase-13-api.md phase-14-enterprise.md phase-15-production.md
ui/9ai.md automations.md design-system.md developers.md files.md forms.md org-admin.md scim.md sso.md
support-matrix.md
infrastructure/71
caddy/1Caddyfile
docker/6
init/101-extensions.sql
opensearch/1init-indices.json
.env.docker docker-compose.yml opensearch-init.sh README.md
kubernetes/40
observability/20
alertmanager/1alertmanager.yaml
grafana/8
dashboards/6ai.json api-overview.json infra.json realtime.json search.json workers-queues.json
provisioning/2
dashboards/1dashboards.yaml
datasources/1datasource.yaml
prometheus/3alerts.yaml recording-rules.yaml scrape.yaml
scripts/1sync-sources.mjs
alertmanager.yaml grafana.yaml kustomization.yaml namespace.yaml node-exporter.yaml otel-collector.yaml prometheus.yaml
postgres/7configmap.yaml cronjob-backup.yaml cronjob-opensearch-snapshot.yaml pgbouncer.yaml replica.yaml statefulset.yaml walg-iam-policy.yaml
api.yaml configmap.yaml ingress.yaml kustomization.yaml namespace.yaml networkpolicy.yaml pdb.yaml README.md realtime.yaml redis.yaml secret.example.yaml web.yaml worker.yaml
nginx/2nginx.conf README.md
observability/14
alertmanager/1alertmanager.yaml
grafana/8
dashboards/6ai.json api-overview.json infra.json realtime.json search.json workers-queues.json
provisioning/2
dashboards/1dashboards.yaml
datasources/1datasource.yaml
prometheus/3alerts.yaml recording-rules.yaml scrape.yaml
scripts/1dashboard-completeness.mjs
README.md
terraform/8compute.tf data.tf main.tf network.tf outputs.tf README.md security.tf variables.tf
packages/289
ai/24
src/20
providers/7anthropic.ts google.ts http.ts index.ts openai-compatible.ts rag.test.ts writing.test.ts
schemas/2database.ts generate.ts
adapters.test.ts config.test.ts config.ts gateway.test.ts gateway.ts index.ts tools.test.ts tools.ts types.ts usage.test.ts usage.ts
package.json README.md tsconfig.json vitest.config.ts
auth/11
src/7index.ts passwords.test.ts passwords.ts sessions.test.ts sessions.ts tokens.test.ts tokens.ts
package.json README.md tsconfig.json vitest.config.ts
collaboration/17
src/13awareness.ts codec.test.ts codec.ts index.ts lww.test.ts lww.ts mapping.ts offline.ts outbox.test.ts outbox.ts provider.test.ts provider.ts types.ts
package.json README.md tsconfig.json vitest.config.ts
config/7
src/4eslint.base.js index.ts prettier.base.json tsconfig.base.json
package.json README.md tsconfig.json
database-client/5
src/2index.test.ts index.ts
package.json README.md tsconfig.json
database-engine/33
src/29
filter/2filter.test.ts index.ts
formula/8evaluator.ts formula.test.ts functions.ts index.ts lexer.ts parser.ts types.ts validate.ts
query/6group.ts index.ts paginate.ts pivot.ts query.test.ts sort.ts
relations/2index.ts relations.test.ts
rollups/2index.ts rollups.test.ts
values/5dates.ts index.ts registry.ts types.ts values.test.ts
views/3buttons.ts index.ts views.test.ts
index.ts
package.json README.md tsconfig.json vitest.config.ts
editor/25
src/21
marks/1highlight.ts
nodes/2equation.ts mention.ts
autosave.test.ts autosave.ts clipboard.test.ts clipboard.ts codec.test.ts codec.ts context-menu.test.ts context-menu.ts diff.test.ts diff.ts factory.ts history.test.ts history.ts index.ts positions.ts slash.test.ts slash.ts types.ts
package.json README.md tsconfig.json vitest.config.ts
observability/20
src/16
__tests__/8db-redis-metrics.test.ts metrics.test.ts otel.test.ts pino-otel.test.ts prometheus.test.ts resource.test.ts scrubber.test.ts traceparent.test.ts
index.ts metrics.ts otel.ts pino-otel.ts prometheus.ts resource.ts scrubber.ts traceparent.ts
package.json README.md tsconfig.json vitest.config.ts
permissions/11
src/7index.ts levels.test.ts levels.ts resolve.test.ts resolve.ts rules.test.ts rules.ts
package.json README.md tsconfig.json vitest.config.ts
search/22
src/18chunking.test.ts chunking.ts client.test.ts client.ts embeddings.test.ts embeddings.ts hybrid.test.ts hybrid.ts index.ts indexer.test.ts indexer.ts mapping.test.ts mapping.ts queries.test.ts queries.ts rrf.test.ts rrf.ts types.ts
package.json README.md tsconfig.json vitest.config.ts
shared/61
src/57
dto/17ai.dto.ts auth.dto.test.ts auth.dto.ts block.dto.ts browser-safety.test.ts comment.dto.ts database.dto.test.ts database.dto.ts file.dto.ts formula-ast.ts index.ts notification.dto.ts page.dto.ts search.dto.ts share.dto.ts webhook.dto.ts workspace.dto.ts
events/8audit-catalog.test.ts audit-catalog.ts audit-csv.test.ts audit-csv.ts audit-scope.test.ts audit-scope.ts catalog.test.ts catalog.ts
realtime/6comment-events.ts frames.test.ts frames.ts notification-policy.ts notification-prefs.ts task-0094.test.ts
automation.test.ts automation.ts constants.ts crypto.test.ts crypto.ts env.ts errors.ts events.test.ts events.ts forms.test.ts forms.ts index.ts markdown.test.ts markdown.ts mentions.test.ts mentions.ts net.test.ts net.ts positions.test.ts positions.ts presence.test.ts presence.ts security-headers.ts webhook-delivery.test.ts webhook-delivery.ts webhook-events.ts
package.json README.md tsconfig.json vitest.config.ts
storage/16
src/12client.test.ts client.ts index.ts keys.test.ts keys.ts mime.test.ts mime.ts presign.test.ts presign.ts thumbnails.test.ts thumbnails.ts types.ts
package.json README.md tsconfig.json vitest.config.ts
ui/37
src/33
components/19avatar.tsx badge.tsx button.tsx checkbox.tsx command.tsx context-menu.tsx dialog.tsx dropdown-menu.tsx empty-state.tsx index.ts popover.tsx separator.tsx skeleton.tsx slider.tsx spinner.tsx switch.tsx tabs.tsx toast.tsx tooltip.tsx
color.ts command-filter.test.ts command-filter.ts focus.test.ts focus.ts formatters.test.ts formatters.ts index.ts theme.test.ts theme.ts toast-store.test.ts toast-store.ts tokens.test.ts tokens.ts
package.json README.md tsconfig.json vitest.config.ts
prisma/16
migrations/13
20260927000000_init/1migration.sql
20260928000000_search_documents_content_hash/1migration.sql
20260929000000_workspace_usage_storage_bytes/1migration.sql
20260930000000_form_submitted_notification_type/1migration.sql
20261001000000_ai_phase12/1migration.sql
20261002000000_webhooks_secret_encrypted_dlq/1migration.sql
20261002111436_webhook_delivery_latency/1migration.sql
20261002120000_org_admin_2fa_retention_unique/1migration.sql
20261002215124_audit_export/1migration.sql
20261003210000_perf_indexes_hot_paths/1migration.sql
20261004004500_perf_indexes_hot_paths_2/1migration.sql
migration_lock.toml README.md
schema.prisma seed.ts verify.ts
scripts/7backup-health.ts docs-completeness.mjs generate-openapi.mjs minio-init.ts opensearch-reindex.ts storage-orphans.ts verify-clean-clone.sh
tests/169
e2e/63
.auth/1user.json
fixtures/7
files/6clip.mp4 clip.wav clip.webm hero-1400.png note.docx note.txt
realtime.ts
mocks/2oidc-issuer.ts saml-idp.ts
playwright-report/3
data/2a6557bae9c2714a658968d4eb8534195c08ebda8.png e3092d07d00a16063e46385c02a559a9054fa847.webm
index.html
reports/1files-security.json
specs/34ai-database.spec.ts ai-generate.spec.ts ai-rag.spec.ts ai-security.spec.ts ai-writing.spec.ts ai.spec.ts api-keys.spec.ts appearance-theme.spec.ts auth.spec.ts automation.spec.ts collab-two-tab.spec.ts comments.spec.ts databases.spec.ts default-workspace-alias.spec.ts developers.spec.ts editor.spec.ts files.spec.ts final-flow.spec.ts forms.spec.ts oauth.spec.ts org-admin.spec.ts pages.spec.ts performance.spec.ts presence-cursors.spec.ts qa-paste-toggle.spec.ts realtime.spec.ts scim.spec.ts search-index-lag.spec.ts search.spec.ts sharing.spec.ts sso.spec.ts task-0094-comments-notifications.spec.ts webhooks.spec.ts workspace.spec.ts
test-results-final-flow/3
final-flow-Release-v1-0-fi-6c06b-w-state-carries-sequential--chromium-desktop/2test-failed-1.png trace.zip
.last-run.json
utils/4api.ts dnd.ts search-lag.ts wait.ts
.gitignore fixtures.ts global-setup.ts package.json playwright.config.ts playwright.final-flow.config.ts README.md tsconfig.json
fixtures/1
files/1make-sparse.ts
integration/60
ai-capability/2ai-app.capability.test.ts gateway.capability.test.ts
drill/2seed-drill.mjs verify-restore.mjs
fixtures/5
files/5clip.mp4 clip.wav doc.pdf hero-1400.png note.txt
helpers/3api.ts containers.ts seed.ts
realtime/11control-channel.test.ts convergence.test.ts flush-rebase-http.test.ts handshake.test.ts heartbeat-limits.test.ts lifecycle.test.ts presence.test.ts rebase.test.ts resume.test.ts rt-helpers.ts task-0094-fanout.test.ts
ai-chat.integration.test.ts ai-database.integration.test.ts ai-generate.integration.test.ts ai-rag.integration.test.ts ai-writing.integration.test.ts api-keys.integration.test.ts audit-completeness.integration.test.ts audit-export-s3.integration.test.ts auth.integration.test.ts automation-pipeline.integration.test.ts automations.integration.test.ts blocks.integration.test.ts cache-invalidation.integration.test.ts comments.integration.test.ts databases.integration.test.ts files-lifecycle.integration.test.ts files-pipeline.integration.test.ts files-security.integration.test.ts files.integration.test.ts forms-responses.integration.test.ts forms.integration.test.ts oauth.integration.test.ts openapi.contract.test.ts org-admin.integration.test.ts package.json pages.integration.test.ts permissions.integration.test.ts README.md replica-routing.integration.test.ts retention-engine.integration.test.ts scim.integration.test.ts search.integration.test.ts sso.integration.test.ts tsconfig.json vitest.config.ts webhooks.integration.test.ts workspace.integration.test.ts
performance/28
fixtures/1search-100k.ts
helpers/2seed-100k.mjs seed-1k-load.mjs
reports/7api-load-smoke.json database-load-smoke.json editor-local.json realtime-load.json search-full.json search-last.json search-reduced.json
api-load.js api.js archive.tar database-load.js database.js editor-local.mjs extract-100k-env.mjs package.json README.md realtime-1k.js realtime-load.js realtime.js run-realtime-load.sh search-search.k6.js search-summary.json seed-100k.mjs threshold-breach-demo.js verify-zero-op-loss.mjs
security/16
helpers/1app.ts
audit-report.test.ts auth-paths.test.ts deps.test.ts formula-fuzz.test.ts gitleaks-config.test.ts headers.test.ts images.test.ts oracle.ts package.json permission-fuzz.test.ts rate-limits.test.ts README.md tsconfig.json upload-abuse.test.ts vitest.config.ts
README.md
.dockerignore .env .env.bak-task0125 .env.example .eslintrc.json .gitignore .npmrc .prettierignore .prettierrc.json AGENTS.md ARCHITECTURE.md CHANGELOG.md CONTRIBUTING.md gitleaks.toml LICENSE package.json pnpm-lock.yaml pnpm-workspace.yaml PRODUCT-SPEC.md README.md ROADMAP.md SECURITY.md tsconfig.json turbo.json
assistant.service.tsapps/api/src/modules/ai/assistant/assistant.service.tsraw← assistant28,272 B← Back to the app
1/**
2 * T-172…T-175 (A-010) — AI Knowledge Assistant.
3 *
4 * Five tools on the EXISTING gateway + permissions stack (no new provider,
5 * vector store, or conversation surface):
6 *
7 *   extract-actions   meeting notes → real tasks (TasksService.create)
8 *   generate-faqs     visible pages → FAQ draft page (Page/BlockService)
9 *   find-duplicates   candidate pool → duplicate groups (read-only)
10 *   find-stale        recent-update pool → stale pages (read-only)
11 *   suggest-metadata  one page → title/description suggestion + apply
12 *
13 * Every call repeats the canonical gate sequence (assertCan → rate limit →
14 * budget guard), retrieves ONLY what the requester can view (per-page
15 * `actorLevel` VIEW re-check — the authoritative permission layer, same IDOR
16 * guard as `assembleWritingContext`), validates the UNTRUSTED tool output with
17 * zod (retry-once on structure errors), drops any model-emitted id that is
18 * not in the retrieved set (no fabricated refs), and writes only through the
19 * normal domain services AS THE REQUESTING USER. A hidden per-call
20 * conversation (`assistant:` prefix, filtered out of the panel) records the
21 * tokens; each capability audits its own `ai.assistant_*` event.
22 */
23import { Inject, Injectable } from "@nestjs/common";
24import type { Request } from "express";
25import type { Prisma, PrismaClient } from "@prisma/client";
26 
27import { PrismaService } from "../../../common/prisma.service.js";
28import { AuditService } from "../../../common/audit.service.js";
29import { ApiError } from "../../../common/errors.js";
30import { logger } from "../../../common/logger.js";
31import { assertCan, actorLevel } from "../../../lib/authorize.js";
32import { AI_GATEWAY, mapAiError, primeWorkspaceCache, type AiBudgetGuard } from "../gateway-provider.js";
33import { AiBudgetGuardService } from "../budget-guard.service.js";
34import { AiRateLimitService } from "../ai-rate-limit.js";
35import { stripHtml } from "../prompts.js";
36import { SearchService } from "../../search/search.service.js";
37import { PageService } from "../../pages/page.service.js";
38import { BlockService } from "../../blocks/block.service.js";
39import { TasksService } from "../../tasks/tasks.service.js";
40import type { AiGateway } from "@factory/ai";
41 
42import {
43  ASSISTANT_CONV_PREFIX,
44  EXTRACT_ACTION_ITEMS_TOOL,
45  EXTRACT_ACTIONS_SYSTEM_PROMPT,
46  FIND_DUPLICATE_GROUPS_TOOL,
47  FIND_DUPLICATES_SYSTEM_PROMPT,
48  FIND_STALE_PAGES_TOOL,
49  FIND_STALE_SYSTEM_PROMPT,
50  GENERATE_FAQS_SYSTEM_PROMPT,
51  GENERATE_FAQS_TOOL,
52  SUGGEST_METADATA_SYSTEM_PROMPT,
53  SUGGEST_PAGE_METADATA_TOOL,
54  renderExtractPrompt,
55  renderFaqsPrompt,
56  renderDuplicatesPrompt,
57  renderMetadataPrompt,
58  renderStalePrompt,
59  validateDuplicateGroups,
60  validateExtractActions,
61  validateGenerateFaqs,
62  validateMetadataSuggestion,
63  validateStalePages,
64} from "./assistant-prompts.js";
65import type {
66  AiExtractActionsInput,
67  AiGenerateFaqsInput,
68  AiFindDuplicatesInput,
69  AiFindStaleInput,
70  AiSuggestMetadataInput,
71  AiApplyMetadataInput,
72} from "./assistant.dto.js";
73 
74type AssistantTool =
75  | typeof EXTRACT_ACTION_ITEMS_TOOL
76  | typeof GENERATE_FAQS_TOOL
77  | typeof FIND_DUPLICATE_GROUPS_TOOL
78  | typeof FIND_STALE_PAGES_TOOL
79  | typeof SUGGEST_PAGE_METADATA_TOOL;
80 
81const CANDIDATE_CAP = 200;
82const CANDIDATE_FLOOR = 10;
83 
84@Injectable()
85export class AssistantService {
86  constructor(
87    @Inject(PrismaService) private readonly prisma: PrismaClient,
88    @Inject(AuditService) private readonly audit: AuditService,
89    @Inject(AI_GATEWAY) private readonly gateway: AiGateway,
90    @Inject(AiBudgetGuardService) private readonly guardService: AiBudgetGuardService,
91    @Inject(AiRateLimitService) private readonly rateLimit: AiRateLimitService,
92    @Inject(SearchService) private readonly search: SearchService,
93    @Inject(PageService) private readonly pages: PageService,
94    @Inject(BlockService) private readonly blocks: BlockService,
95    @Inject(TasksService) private readonly tasks: TasksService,
96  ) {}
97 
98  private get guard(): AiBudgetGuard {
99    return this.guardService.guard;
100  }
101 
102  // ------------------------------------------------------------------- gates ---
103 
104  /** Rate cap + budget (canonical JSON envelope on failure, pre-write). */
105  private async preGate(workspaceId: string, userId: string, req: Request): Promise<void> {
106    const rl = await this.rateLimit.check(userId);
107    if (!rl.allowed) {
108      throw new ApiError("RATE_LIMITED", 429, "AI call limit reached.", [
109        { reason: "ai_call_rate_limited", retryAfterSeconds: rl.retryAfterSeconds },
110      ]);
111    }
112    await primeWorkspaceCache(this.prisma, workspaceId);
113    try {
114      await this.guard.check(workspaceId, undefined, req);
115    } catch (err) {
116      throw mapAiError(err);
117    }
118  }
119 
120  /** Hidden per-call conversation (never listed in the panel) + user row. */
121  private async beginConversation(
122    workspaceId: string,
123    userId: string,
124    action: string,
125    userContent: string,
126    context: Record<string, unknown>,
127  ) {
128    const conversation = await this.prisma.aiConversation.create({
129      data: {
130        workspaceId,
131        userId,
132        title: `${ASSISTANT_CONV_PREFIX}${action}`,
133        context: context as object,
134      },
135    });
136    await this.prisma.aiMessage.create({
137      data: { conversationId: conversation.id, role: "user", content: userContent },
138    });
139    return conversation;
140  }
141 
142  private async persistAssistant(
143    conversationId: string,
144    model: string,
145    usage: { in: number; out: number },
146    metadata: Record<string, unknown>,
147  ): Promise<string | undefined> {
148    try {
149      const row = await this.prisma.aiMessage.create({
150        data: {
151          conversationId,
152          role: "assistant",
153          content: metadata.error ? `error: ${String(metadata.error)}` : "ok",
154          model,
155          ...(usage.in > 0 ? { tokensIn: usage.in } : {}),
156          ...(usage.out > 0 ? { tokensOut: usage.out } : {}),
157          metadata: metadata as object,
158        },
159      });
160      return row.id;
161    } catch (err) {
162      logger.warn(`assistant: persist failed workspace conversation=${conversationId}: ${String(err)}`);
163      return undefined;
164    }
165  }
166 
167  /**
168   * One forced tool call. `metadata.mode = "assistant"` + `action` is the
169   * MockProvider branch for deterministic unit/integration coverage.
170   */
171  private async chatTool(opts: {
172    workspaceId: string;
173    userId: string;
174    system: string;
175    user: string;
176    tool: AssistantTool;
177    action: string;
178    feedback?: string;
179  }): Promise<{ args: unknown; usage: { in: number; out: number } }> {
180    const messages: Array<{ role: "system" | "user"; content: string }> = [
181      { role: "system", content: opts.system },
182      {
183        role: "user",
184        content: opts.feedback
185          ? `${opts.user}\n\nPrevious attempt was INVALID: ${opts.feedback}\nCorrect it and call the tool again.`
186          : opts.user,
187      },
188    ];
189    let args: unknown;
190    let usage = { in: 0, out: 0 };
191    for await (const chunk of this.gateway.chat({
192      workspaceId: opts.workspaceId,
193      userId: opts.userId,
194      capability: "assistant",
195      messages,
196      tools: [opts.tool],
197      toolChoice: { name: opts.tool.name },
198      metadata: { mode: "assistant", action: opts.action },
199    })) {
200      if (chunk.toolCallDelta) args = chunk.toolCallDelta.arguments;
201      if (chunk.done && chunk.usage) usage = { in: chunk.usage.in, out: chunk.usage.out };
202    }
203    if (args === undefined) {
204      throw ApiError.unprocessable("The model returned no tool call.", [{ reason: "ai_invalid_structure", issue: "no tool call" }]);
205    }
206    return { args, usage };
207  }
208 
209  /** Run chatTool + a `validate*` helper, retrying once with the error as feedback. */
210  private async callValidated<T>(
211    opts: {
212      workspaceId: string;
213      userId: string;
214      system: string;
215      user: string;
216      tool: AssistantTool;
217      action: string;
218    },
219    validate: (raw: unknown) => { ok: true; value: T; dropped?: string[] } | { ok: false; feedback: string },
220  ): Promise<{ value: T; dropped: string[]; usage: { in: number; out: number }; invalid?: string }> {
221    let attempt = await this.chatTool(opts);
222    let parsed = validate(attempt.args);
223    if (!parsed.ok) {
224      attempt = await this.chatTool({ ...opts, feedback: parsed.feedback });
225      parsed = validate(attempt.args);
226    }
227    if (!parsed.ok) {
228      return { value: undefined as T, dropped: [], usage: attempt.usage, invalid: parsed.feedback };
229    }
230    return { value: parsed.value, dropped: parsed.dropped ?? [], usage: attempt.usage };
231  }
232 
233  // ------------------------------------------------------------- retrieval ---
234 
235  /** Plain text of a page's blocks (title block included; HTML stripped). */
236  private async pageText(pageId: string, cap: number): Promise<string> {
237    const rows = await this.prisma.block.findMany({
238      where: { pageId, deletedAt: null },
239      select: { content: true, position: true },
240      orderBy: { position: "asc" },
241    });
242    return rows.map((r) => blockText(r.content)).filter(Boolean).join("\n").slice(0, cap);
243  }
244 
245  /**
246   * Permission-filtered candidate pages: a workspace-scoped pool (most recent
247   * or search-hit) re-checked PER PAGE against the authoritative permission
248   * layer (`actorLevel` — page grants, workspace role). Unviewable pages are
249   * dropped + logged (IDOR guard; nothing unseen reaches the model).
250   */
251  private async viewableCandidates(
252    workspaceId: string,
253    userId: string,
254    opts: { pageIds?: string[]; limit: number; olderThan?: Date },
255  ): Promise<Array<{ id: string; title: string; text: string; updatedAt: string }>> {
256    const limit = Math.max(CANDIDATE_FLOOR, Math.min(CANDIDATE_CAP, opts.limit));
257    const where: Prisma.PageWhereInput = {
258      workspaceId,
259      deletedAt: null,
260      trashedAt: null,
261      ...(opts.pageIds ? { id: { in: opts.pageIds } } : {}),
262      ...(opts.olderThan ? { updatedAt: { lt: opts.olderThan } } : {}),
263    };
264    const pool = await this.prisma.page.findMany({
265      where,
266      select: { id: true, title: true, updatedAt: true },
267      orderBy: { updatedAt: "desc" },
268      take: opts.pageIds ? undefined : limit,
269    });
270 
271    // Per-page VIEW re-check (the authoritative layer — never the model, never
272    // a cached snapshot): drop what the requester cannot see.
273    const visible: Array<{ id: string; title: string; updatedAt: Date }> = [];
274    for (const p of pool) {
275      const level = await actorLevel(this.prisma, { workspaceId, userId, resource: { pageId: p.id } });
276      if (level === "NONE") {
277        logger.info(`assistant: page ${p.id} dropped from candidates — user ${userId} lacks VIEW`);
278        continue;
279      }
280      visible.push(p);
281    }
282 
283    const ids = visible.map((p) => p.id);
284    const blockRows = ids.length
285      ? await this.prisma.block.findMany({
286          where: { pageId: { in: ids }, deletedAt: null },
287          select: { pageId: true, content: true, position: true },
288          orderBy: [{ pageId: "asc" }, { position: "asc" }],
289        })
290      : [];
291    const textByPage = new Map<string, string>();
292    for (const b of blockRows) {
293      const t = blockText(b.content);
294      if (!t) continue;
295      textByPage.set(b.pageId, (textByPage.get(b.pageId) ?? "") + (textByPage.get(b.pageId) ? "\n" : "") + t);
296    }
297    return visible.map((p) => ({
298      id: p.id,
299      title: p.title,
300      updatedAt: p.updatedAt.toISOString(),
301      text: (textByPage.get(p.id) ?? "").slice(0, 1200),
302    }));
303  }
304 
305  // ------------------------------------------------------------ 1. actions ---
306 
307  /** Meeting notes → tasks, created through TasksService as the requester. */
308  async extractActions(workspaceId: string, userId: string, input: AiExtractActionsInput, req: Request) {
309    await assertCan(this.prisma, { workspaceId, userId }, "EDIT");
310    await this.preGate(workspaceId, userId, req);
311 
312    const conversation = await this.beginConversation(
313      workspaceId,
314      userId,
315      "extract-actions",
316      `extract-actions: ${input.text.slice(0, 200)}`,
317      { feature: "assistant.extract-actions", chars: input.text.length },
318    );
319 
320    const result = await this.callValidated(
321      {
322        workspaceId,
323        userId,
324        system: EXTRACT_ACTIONS_SYSTEM_PROMPT,
325        user: renderExtractPrompt(input.text),
326        tool: EXTRACT_ACTION_ITEMS_TOOL,
327        action: "extract-actions",
328      },
329      validateExtractActions,
330    );
331    if ((result as { invalid?: string }).invalid) {
332      await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
333        feature: "assistant.extract-actions",
334        error: "ai_invalid_structure",
335      });
336      throw ApiError.unprocessable("The AI returned an invalid action list.", [
337        { reason: "ai_invalid_structure", issue: (result as { invalid?: string }).invalid },
338      ]);
339    }
340 
341    const tasksOut: Array<{ id: string; title: string; dueDate?: string }> = [];
342    for (const a of result.value) {
343      const row = await this.tasks.create(
344        workspaceId,
345        userId,
346        { title: a.title, dueAt: a.dueDate ?? null },
347        req,
348      );
349      tasksOut.push({ id: row.id, title: a.title, dueDate: a.dueDate });
350    }
351 
352    const assistantId = await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
353      feature: "assistant.extract-actions",
354      taskIds: tasksOut.map((t) => t.id),
355    });
356    await this.audit.audit(req, req?.auth, {
357      action: "ai.assistant_extract_actions",
358      resourceType: "task",
359      resourceId: tasksOut[0]?.id ?? assistantId ?? conversation.id,
360      workspaceId,
361      metadata: { taskCount: tasksOut.length },
362    });
363    return { tasks: tasksOut, tokensIn: result.usage.in, tokensOut: result.usage.out };
364  }
365 
366  // ---------------------------------------------------------------- 2. faqs ---
367 
368  /** Visible pages → an FAQ draft PAGE (title + H2/paragraph per Q/A). */
369  async generateFaqs(workspaceId: string, userId: string, input: AiGenerateFaqsInput, req: Request) {
370    await assertCan(this.prisma, { workspaceId, userId }, "VIEW");
371    await this.preGate(workspaceId, userId, req);
372 
373    const unique = [...new Set(input.pageIds)];
374    const pages_ = await this.prisma.page.findMany({
375      where: { id: { in: unique }, workspaceId, deletedAt: null },
376      select: { id: true, title: true },
377    });
378    const sections: Array<{ label: string; text: string }> = [];
379    for (const p of pages_) {
380      const level = await actorLevel(this.prisma, { workspaceId, userId, resource: { pageId: p.id } });
381      if (level === "NONE") {
382        logger.info(`assistant: faqs — page ${p.id} dropped, user ${userId} lacks VIEW`);
383        continue;
384      }
385      sections.push({ label: p.title || p.id, text: await this.pageText(p.id, 4000) });
386    }
387    if (sections.length === 0) throw ApiError.notFound("Pages not found.");
388 
389    const conversation = await this.beginConversation(
390      workspaceId,
391      userId,
392      "generate-faqs",
393      `generate-faqs: ${sections.map((s) => s.label).join(", ").slice(0, 200)}`,
394      { feature: "assistant.generate-faqs", pageIds: sections.map((s) => s.label) },
395    );
396 
397    const result = await this.callValidated(
398      {
399        workspaceId,
400        userId,
401        system: GENERATE_FAQS_SYSTEM_PROMPT,
402        user: renderFaqsPrompt(sections, sections.length),
403        tool: GENERATE_FAQS_TOOL,
404        action: "generate-faqs",
405      },
406      validateGenerateFaqs,
407    );
408    if ((result as { invalid?: string }).invalid) {
409      await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
410        feature: "assistant.generate-faqs",
411        error: "ai_invalid_structure",
412      });
413      throw ApiError.unprocessable("The AI returned an invalid FAQ list.", [
414        { reason: "ai_invalid_structure", issue: (result as { invalid?: string }).invalid },
415      ]);
416    }
417 
418    // Write through the normal services (EDIT re-checked + audited inside).
419    const page = await this.pages.create(workspaceId, userId, { title: result.value.title }, req);
420    const pageId = page.id;
421    for (const faq of result.value.faqs) {
422      await this.blocks.create(pageId, userId, { type: "HEADING_2", content: { text: faq.question }, properties: {} }, req);
423      await this.blocks.create(pageId, userId, { type: "PARAGRAPH", content: { text: faq.answer }, properties: {} }, req);
424    }
425 
426    const assistantId = await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
427      feature: "assistant.generate-faqs",
428      pageId,
429      faqCount: result.value.faqs.length,
430    });
431    await this.audit.audit(req, req?.auth, {
432      action: "ai.assistant_faq_page",
433      resourceType: "page",
434      resourceId: pageId,
435      workspaceId,
436      pageId,
437      metadata: { faqCount: result.value.faqs.length },
438    });
439    return { page: { id: pageId, title: result.value.title }, faqCount: result.value.faqs.length, tokensIn: result.usage.in, tokensOut: result.usage.out };
440  }
441 
442  // -------------------------------------------------------- 3. duplicates ---
443 
444  /** Candidate pool (search or most-recent) → duplicate groups (read-only). */
445  async findDuplicates(workspaceId: string, userId: string, input: AiFindDuplicatesInput, req: Request) {
446    await assertCan(this.prisma, { workspaceId, userId }, "VIEW");
447    await this.preGate(workspaceId, userId, req);
448 
449    const limit = input.limit ?? 100;
450    let pageIds: string[] | undefined;
451    if (input.query) {
452      const hits = await this.search.query(userId, { q: input.query, workspaceId, types: ["page"], limit: CANDIDATE_CAP });
453      pageIds = hits.map((h) => h.id);
454    }
455    const candidates = await this.viewableCandidates(workspaceId, userId, { pageIds, limit });
456    if (candidates.length < 2) {
457      return { groups: [], considered: candidates.length, tokensIn: 0, tokensOut: 0 };
458    }
459 
460    const conversation = await this.beginConversation(
461      workspaceId,
462      userId,
463      "find-duplicates",
464      `find-duplicates: ${input.query ?? "recent pages"} (${candidates.length} candidates)`,
465      { feature: "assistant.find-duplicates", candidateCount: candidates.length, query: input.query ?? null },
466    );
467 
468    const known = new Set(candidates.map((c) => c.id));
469    const result = await this.callValidated(
470      {
471        workspaceId,
472        userId,
473        system: FIND_DUPLICATES_SYSTEM_PROMPT,
474        user: renderDuplicatesPrompt(candidates),
475        tool: FIND_DUPLICATE_GROUPS_TOOL,
476        action: "find-duplicates",
477      },
478      (raw) => validateDuplicateGroups(raw, known),
479    );
480    if ((result as { invalid?: string }).invalid) {
481      await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
482        feature: "assistant.find-duplicates",
483        error: "ai_invalid_structure",
484      });
485      throw ApiError.unprocessable("The AI returned an invalid duplicate list.", [
486        { reason: "ai_invalid_structure", issue: (result as { invalid?: string }).invalid },
487      ]);
488    }
489 
490    const byId = new Map(candidates.map((c) => [c.id, c]));
491    const groups = result.value.map((g) => ({
492      similarity: g.similarity,
493      reason: g.reason,
494      pages: g.pageIds.map((id) => ({ pageId: id, title: byId.get(id)?.title ?? "", updatedAt: byId.get(id)?.updatedAt ?? "" })),
495    }));
496 
497    await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
498      feature: "assistant.find-duplicates",
499      groups: result.value,
500      ...(result.dropped.length ? { droppedIds: result.dropped } : {}),
501    });
502    await this.audit.audit(req, req?.auth, {
503      action: "ai.assistant_duplicates_found",
504      resourceType: "ai_suggestion",
505      resourceId: conversation.id,
506      workspaceId,
507      metadata: { groupCount: groups.length, candidateCount: candidates.length },
508    });
509    return { groups, considered: candidates.length, tokensIn: result.usage.in, tokensOut: result.usage.out };
510  }
511 
512  // ---------------------------------------------------------------- 4. stale ---
513 
514  /** Pages not updated in N days → model judges which look stale. */
515  async findStale(workspaceId: string, userId: string, input: AiFindStaleInput, req: Request) {
516    await assertCan(this.prisma, { workspaceId, userId }, "VIEW");
517    await this.preGate(workspaceId, userId, req);
518 
519    const cutoff = new Date(Date.now() - input.days * 86_400_000);
520    const candidates = await this.viewableCandidates(workspaceId, userId, { limit: input.limit ?? 100, olderThan: cutoff });
521    if (candidates.length === 0) {
522      return { pages: [], considered: 0, tokensIn: 0, tokensOut: 0 };
523    }
524 
525    const conversation = await this.beginConversation(
526      workspaceId,
527      userId,
528      "find-stale",
529      `find-stale: ${candidates.length} candidates (older than ${input.days} days)`,
530      { feature: "assistant.find-stale", candidateCount: candidates.length, days: input.days },
531    );
532 
533    const known = new Set(candidates.map((c) => c.id));
534    const result = await this.callValidated(
535      {
536        workspaceId,
537        userId,
538        system: FIND_STALE_SYSTEM_PROMPT,
539        user: renderStalePrompt(candidates),
540        tool: FIND_STALE_PAGES_TOOL,
541        action: "find-stale",
542      },
543      (raw) => validateStalePages(raw, known),
544    );
545    if ((result as { invalid?: string }).invalid) {
546      await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
547        feature: "assistant.find-stale",
548        error: "ai_invalid_structure",
549      });
550      throw ApiError.unprocessable("The AI returned an invalid stale list.", [
551        { reason: "ai_invalid_structure", issue: (result as { invalid?: string }).invalid },
552      ]);
553    }
554 
555    const byId = new Map(candidates.map((c) => [c.id, c]));
556    const pages_ = result.value.map((p) => ({
557      pageId: p.pageId,
558      title: byId.get(p.pageId)?.title ?? "",
559      updatedAt: byId.get(p.pageId)?.updatedAt ?? "",
560      reason: p.reason,
561    }));
562 
563    await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
564      feature: "assistant.find-stale",
565      pageIds: pages_.map((p) => p.pageId),
566      ...(result.dropped.length ? { droppedIds: result.dropped } : {}),
567    });
568    await this.audit.audit(req, req?.auth, {
569      action: "ai.assistant_stale_found",
570      resourceType: "ai_suggestion",
571      resourceId: conversation.id,
572      workspaceId,
573      metadata: { staleCount: pages_.length, candidateCount: candidates.length },
574    });
575    return { pages: pages_, considered: candidates.length, tokensIn: result.usage.in, tokensOut: result.usage.out };
576  }
577 
578  // ---------------------------------------------------------- 5. metadata ---
579 
580  /** One page → suggested title/description (suggestion; apply is separate). */
581  async suggestMetadata(workspaceId: string, userId: string, input: AiSuggestMetadataInput, req: Request) {
582    const page = await this.prisma.page.findFirst({
583      where: { id: input.pageId, workspaceId, deletedAt: null },
584      select: { id: true, title: true, description: true },
585    });
586    if (!page) throw ApiError.notFound("Page not found.");
587    const level = await actorLevel(this.prisma, { workspaceId, userId, resource: { pageId: page.id } });
588    if (level === "NONE") throw ApiError.notFound("Page not found.");
589    await assertCan(this.prisma, { workspaceId, userId }, "VIEW");
590    await this.preGate(workspaceId, userId, req);
591 
592    const conversation = await this.beginConversation(
593      workspaceId,
594      userId,
595      "suggest-metadata",
596      `suggest-metadata: ${page.title || page.id}`,
597      { feature: "assistant.suggest-metadata", pageId: page.id },
598    );
599 
600    const result = await this.callValidated(
601      {
602        workspaceId,
603        userId,
604        system: SUGGEST_METADATA_SYSTEM_PROMPT,
605        user: renderMetadataPrompt({ title: page.title, text: await this.pageText(page.id, 8000) }),
606        tool: SUGGEST_PAGE_METADATA_TOOL,
607        action: "suggest-metadata",
608      },
609      validateMetadataSuggestion,
610    );
611    if ((result as { invalid?: string }).invalid) {
612      await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
613        feature: "assistant.suggest-metadata",
614        pageId: page.id,
615        error: "ai_invalid_structure",
616      });
617      throw ApiError.unprocessable("The AI returned an invalid suggestion.", [
618        { reason: "ai_invalid_structure", issue: (result as { invalid?: string }).invalid },
619      ]);
620    }
621 
622    const assistantId = await this.persistAssistant(conversation.id, this.gateway.resolve(workspaceId).chatModel, result.usage, {
623      feature: "assistant.suggest-metadata",
624      pageId: page.id,
625      suggestion: result.value,
626    });
627    await this.audit.audit(req, req?.auth, {
628      action: "ai.assistant_metadata_suggested",
629      resourceType: "page",
630      resourceId: page.id,
631      workspaceId,
632      pageId: page.id,
633      metadata: { fields: Object.keys(result.value) },
634    });
635    return {
636      suggestionId: assistantId,
637      pageId: page.id,
638      current: { title: page.title, description: page.description },
639      suggested: result.value,
640      tokensIn: result.usage.in,
641      tokensOut: result.usage.out,
642    };
643  }
644 
645  /** Apply a previously-suggested field subset via the normal page PATCH path. */
646  async applyMetadata(workspaceId: string, userId: string, input: AiApplyMetadataInput, req: Request) {
647    // Ownership-scoped lookup (404 no-leak, like the writing apply path).
648    const message = await this.prisma.aiMessage.findFirst({
649      where: { id: input.suggestionId, role: "assistant" },
650      select: { id: true, conversationId: true, metadata: true },
651    });
652    const conversation = message
653      ? await this.prisma.aiConversation.findUnique({ where: { id: message.conversationId }, select: { workspaceId: true, userId: true } })
654      : null;
655    if (!message || !conversation || conversation.workspaceId !== workspaceId || conversation.userId !== userId) {
656      throw ApiError.notFound("Suggestion not found.");
657    }
658    const meta = (message.metadata ?? {}) as { feature?: string; pageId?: string; suggestion?: { title?: string; description?: string } };
659    if (meta.feature !== "assistant.suggest-metadata" || !meta.pageId || !meta.suggestion) {
660      throw ApiError.notFound("Suggestion not found.");
661    }
662 
663    // Only fields EXACTLY as suggested may be applied (no smuggling).
664    const updates: { title?: string; description?: string } = {};
665    if (input.fields.title !== undefined) {
666      if (meta.suggestion.title !== input.fields.title) {
667        throw new ApiError("VALIDATION_ERROR", 400, "fields.title does not match the suggestion.", [{ field: "fields.title", issue: "not_in_suggestion" }]);
668      }
669      updates.title = input.fields.title;
670    }
671    if (input.fields.description !== undefined) {
672      if (meta.suggestion.description !== input.fields.description) {
673        throw new ApiError("VALIDATION_ERROR", 400, "fields.description does not match the suggestion.", [{ field: "fields.description", issue: "not_in_suggestion" }]);
674      }
675      updates.description = input.fields.description;
676    }
677 
678    await this.pages.update(meta.pageId, userId, updates, req);
679 
680    await this.audit.audit(req, req?.auth, {
681      action: "ai.assistant_metadata_applied",
682      resourceType: "page",
683      resourceId: meta.pageId,
684      workspaceId,
685      pageId: meta.pageId,
686      metadata: { fields: Object.keys(updates), suggestionId: input.suggestionId },
687    });
688    return { pageId: meta.pageId, applied: Object.keys(updates) };
689  }
690}
691 
692/** Block content → plain text (string-or-object, HTML stripped — see prompts.ts). */
693function blockText(content: unknown): string {
694  if (typeof content === "string") return stripHtml(content);
695  if (typeof content !== "object" || content === null) return "";
696  const c = content as { text?: unknown; title?: unknown };
697  const raw = typeof c.text === "string" ? c.text : typeof c.title === "string" ? c.title : "";
698  return stripHtml(raw);
699}
700