FMS Detective — FileMaker Server Log Analysis Tool

Powerful Analysis Tools

Everything you need to understand what's happening on your FileMaker Server

📊

12 Log Types

Auto-detects and parses all FileMaker Server log formats including Event, Access, Stats, Top Call Stats, Client Stats, Data API, OData, and more.

🔍

Performance Troubleshooter

A guided 3-step diagnosis: identify performance spikes, pinpoint problem clients, and drill down to the exact operations causing issues.

🔗

Log Correlation

Cross-log anomaly detection groups time-correlated issues into incidents with root cause analysis against known FMS failure modes.

🖥️

Admin API Integration

Optionally connect to your FileMaker Server for live server context — database sizes, client counts, cache settings, and more.

📁

Drag & Drop Import

Drop your log files in, and FMS Detective handles the rest. Multi-file import with automatic type detection, up to 200 MB per file.

🔒

100% Local Processing

All analysis happens on your Mac. No data is uploaded to any server. Your log files never leave your machine.

See It in Action

Click any screenshot to view full size

Performance Troubleshooter

Identify Spikes — Elapsed time charts with cache hit tracking and automatic spike detection. Stat cards show key metrics at a glance.

Client Analysis — Drill down by client to see who's consuming the most resources. Stacked bar charts break down elapsed time into Processing, Wait, and I/O.

Operation Detail — See the exact operations causing issues with per-call elapsed time, record counts, and bottleneck classification.

Log Correlation

Cross-Log Anomaly Detection — Automatically correlates anomalies across all loaded log types and groups time-related issues into incidents.

Incident Detail — Drill into each incident to see the contributing log entries, affected time window, and severity assessment.

Root Cause Analysis — Pattern matching identifies known failure modes like backup impact, resource exhaustion, and script cascades.

Server Activity Timeline Beta

24-Hour Timeline — Visualize server-side scripts, client connections, and database sessions across the day. Color-coded bars for Schedules, PSoS, Pro clients, and Data API activity with a concurrency chart showing simultaneous load.

Session Detail — Click any bar on the timeline to see full session details including timing, database, errors, and status. Per-database open/close tracking with expandable session drill-downs.

AI Assistant

Local AI Models — Supports both Ollama and LM Studio for private, on-device analysis. Unified model picker shows all available models tagged by provider.

AI-Enhanced Troubleshooter — After drilling into a client's operations, the AI analyzes bottlenecks, identifies root causes, and provides targeted recommendations.

AI-Enhanced Log Correlation — The AI reviews the full incident timeline, event sequence, and affected log types to provide deeper root cause analysis.

Explain These Findings — On any analysis view, click to get a plain-English summary of what the data means and what actions to take.

All AI features are additive — the app works fully without Ollama or LM Studio.

Top Call Stats

Identify the most expensive database operations with time breakdowns, client hotspots, and automatic bottleneck classification with actionable advice.

Script Events

Script execution timeline, error tracking by FM error code, top scripts with errors, and schedule vs. PSoS trigger breakdown — all with click-to-filter drill-downs.

Access Log & API Logs

Access Log — Client connection patterns, database access analysis, user activity summaries with expandable rows, and per-database activity tracking.

Data API — Request timeline, HTTP method distribution, error code table with human-readable descriptions, and click-to-filter drill-downs by IP, account, or database.

OData — Full OData API monitoring with request timeline, error tracking, and the same interactive drill-down panels as the Data API view.

12 Log Types Supported

Auto-detected from filename or file content

E

Event Log Server events, errors, restarts, schedule execution

A

Access Log Client connections, database access patterns

T

Top Call Stats Most expensive database operations

C

Client Stats Per-client resource consumption

S

Server Stats Cache hit %, disk I/O, calls/sec

SE

Script Events Script execution errors

D

Data API FileMaker Data API activity

O

OData OData API request/response activity

AC

Admin Console CPU/memory alerts, notifications

W

Web Publishing WPE crash diagnostics

L

Load Schedules Schedule import results

WP

WPE Log Web Publishing Engine requests

How It Works

1

Drop Your Logs

Drag and drop your FileMaker Server log files, or use the file browser. FMS Detective auto-detects the log type.

→

2

Analyze

Charts, tables, and diagnostics appear instantly. Each log type gets a tailored analysis view with relevant metrics.

→

3

Diagnose

Use the Performance Troubleshooter and Log Correlation tools for guided root cause analysis.

FileMaker Admin API Integration

Optionally connect to your live FileMaker Server to enrich log analysis with real-time server context. Read-only access — no server settings are modified.

Keychain integration for secure credential storage
SSL certificate trust management for self-signed certs
Automatic token refresh (15-minute expiry)
Server metadata, database list, connected clients
Cache size, max connections, license info
Data API usage, session timeouts, backup config

All enrichment is additive — the app works fully without a server connection.

Built by a FileMaker Developer

I'm Sam, a FileMaker developer with over 10 years experience building solutions and managing FileMaker Server instances. I built FMS Detective to identify and solve issues on my own deployments.

Find me on LinkedIn or Bluesky — I would love to connect.

Get FMS Detective

Native macOS app for Mac.

Download

Native macOS app • 100% local processing • No data uploaded