← Back to directory
COMPARE UP TO 4 SERVERS

Compare MCP servers

Compare scores, permissions, risks, and fit in one decision-focused table.

DimensionFabric RTI MCPKQL queries, Eventstream management, and real-time alerts for Microsoft Fabric Real-Time IntelligenceCompartmentEncrypted, fully offline long-term memory for AI agents
FMRS65 / 100 · C75 / 100 · B
Reliability10 / 2012 / 20
Security and permissions13 / 2016 / 20
Maintenance15 / 2014 / 20
Documentation15 / 2018 / 20
Setup experience12 / 2015 / 20
Best for
  • Teams using Microsoft Fabric RTI who want to interact with data via AI agents using natural language.
  • Data engineers needing to quickly analyze streaming data and generate KQL queries automatically.
  • Developers looking to automate real-time data monitoring and alerts, such as Activator triggers and Eventstream management.
  • Analysts needing to visualize geospatial data and interact with Map items.
  • Individuals or teams who prioritise privacy and offline operation and do not want data leaving the machine
  • Users who share memory across multiple MCP clients such as Claude Code, Claude Desktop, Hermes Agent, OpenClaw, Cursor, Codex and Gemini CLI
  • Scenarios that need encrypted storage, a hash-chained audit log and verifiable vault migration
  • Users who want low-latency recall, a bundled embedding model and no extra LLM calls inside the memory layer
Not for
  • Production deployments seeking a stable, GA MCP server (currently in Public Preview).
  • Users unfamiliar with Fabric RTI or KQL, as the server relies on existing knowledge to use effectively.
  • Organizations that do not wish to expose their data or workspaces to LLMs or third-party clients.
  • Use cases requiring advanced security for HTTP mode without additional configuration.
  • Users who need cloud multi-device sync or a hosted team memory service; moving between machines means locking the vault and copying the file
  • Users who expect the server itself to run an LLM that extracts facts and decides what to remember; Compartment explicitly keeps no LLM inside and leaves that to the host model
  • Users who cannot keep a passphrase safe or who need a recovery path if it is lost, since Compartment never generates a password, seed or recovery phrase
  • Deployments that require network transports such as SSE or streamable-http; this server is stdio only and opens no ports
Required permissions
  • Access Microsoft Fabric workspaces, including Eventhouse, Eventstreams, Activator, and Map items.
  • Execute KQL queries and management commands, including ingesting data and modifying schemas.
  • Create, update, and delete Eventstreams and Map items.
  • Create Activator triggers and configure email or Teams notifications.
  • Authenticate using Azure Identity, which automatically uses environment credentials, Azure CLI, PowerShell, etc.
  • Read and write the vault file under the user's home directory, by default ~/.compartment/memory.vault, and its sibling settings file
  • Access the session directory holding the unlock credential (configurable with COMPARTMENT_SESSION_DIR), which also carries the shared embedding process's Unix socket
  • Optionally use the macOS keychain (compartment unlock --keychain is an explicit opt-in, and it survives reboots)
  • Write or merge an mcpServers entry into each MCP client's own configuration file, taking a byte-exact backup first
  • Install a PostToolUse hook for Claude Code that captures memory files the agent writes
  • Serve a read-only dashboard on 127.0.0.1 behind a one-time random URL token
Risks and side effects
  • Public Preview: implementation may change significantly prior to General Availability.
  • MCP clients can perform destructive operations (e.g., deleting Eventstreams or Maps) if permissions are too broad.
  • Sharing data with third-party LLMs or clients may fall outside Fabric's compliance boundary; review carefully.
  • HTTP mode may expose endpoints beyond localhost; ensure a security boundary (e.g., Entra authentication) is placed in front.
  • Some tools, like kusto_get_shots, require additional configuration (e.g., embedding endpoints and table).
  • A leaked passphrase means the encrypted content can be decrypted; Compartment generates no recovery phrase and cannot recover a lost passphrase
  • Enabling the memory_unlock tool places the passphrase in the model's context, which is why it is off by default
  • If a 2FA keyfile is lost, for example a USB stick, the vault cannot be opened even with the passphrase
  • `export --plaintext` writes the vault as unencrypted JSONL, so that file must be handled carefully
  • Memory content can come from untrusted sources; recall wraps memories with a notice that they are stored data and content can be marked quarantined, but the host agent must still treat memory as data to limit prompt-injection risk
  • The capture hook and client integration write into the user's own settings files, although the implementation backs up and merges rather than replacing
Supported clientsVS Code, GitHub CopilotClaude Desktop, Claude Code, Hermes Agent, OpenClaw, Cursor, VS Code, Codex, Gemini CLI, Cline, Roo Code, Zed, OpenCode, LM Studio, AnythingLLM, BoltAI, Goose, Kiro
Tools3914