Intelligent Analytics

Your Database Talks. Adam Listens.

Zero-instrumentation analytics that sits in the proxy layer. No code changes, no agents to deploy, no SDK to integrate. Enable a feature flag and insights start flowing.

Automatic Anti-Pattern Detection

Adam watches your traffic and identifies performance anti-patterns in real time at two levels: per-connection burst analysis and per-endpoint aggregate analysis.

  • N+1 query detection
  • Hot key concentration via Space-Saving sketch (64-entry, O(1) lookup)
  • Unbounded range warnings

PII Exposure Alerts

Real-time detection of personally identifiable information flowing through your data layer. Regex-based scanning for 5+ patterns with automatic redaction before storage.

  • SSN & credit card detection
  • API key & password scanning
  • Email, phone, IP detection

30+ Rule Recommendation Engine

Not just metrics, but actionable recommendations with confidence scoring, severity classification, and estimated monthly cost savings. Covers write-heavy patterns, missing TTLs, oversized values, hot keys above 15% traffic, large hash operations, and read replica candidates.

  • Pattern & context rules
  • Confidence-scored output
  • Cost savings estimates

Real-Time Streaming Analytics

SSE-powered real-time monitoring with per-endpoint health snapshots every 60 seconds including ops/sec, error rate, and p50/p99/p999 latency percentiles. Anomaly transitions emit immediately.

  • Zero-overhead when unused
  • Anomaly-only filtering
  • 64-event broadcast buffer

Anomaly Detection

Three-stage confirmation using Jensen-Shannon divergence. Compares command distribution to baseline — watch at 2% divergence, critical at 5%. Includes latency spike and error rate detectors.

  • 3-window confirmation before alerting
  • 5-window cooldown before reset
  • Confirmation memory with 5-minute bridging windows

Adaptive Metadata Polling

Three-frequency metadata collection — High (60s), Medium (30min), Low (24h) — with four escalation levels that accelerate up to 8x during anomalies.

  • Normal → Watch → Elevated → Critical escalation
  • Hysteresis prevents flapping between states
  • ClickHouse storage with SummingMergeTree rollups

Detected Anti-Patterns

Automatically flagged with confidence scores and actionable recommendations.

N+1 Queries

5 repeated commands

Hot Keys

> 15% traffic

KEYS Command

Any occurrence

Unbounded Range

Any occurrence

Large Responses

> 64 KB

High Fanout

100+ keys in MGET/MSET

High Error Rate

> 10% rate

Missing TTLs

> 80% no TTL

Slow Queries

> 10ms

Dangerous Commands

FLUSHDB, SHUTDOWN, CONFIG

Large Hash Ops

> 5 KB per operation

Write-Heavy Never-Read

0 reads on pattern

Ready to Connect AI to Your Data?

Join forward-thinking companies using ADAM to unify their AI and database infrastructure. Same auth. Same RBAC. Same API.