How Exagomatica connects Claude to your data stack.
Exagomatica is a local Python MCP server that exposes 11 tools to Claude Desktop over stdio. It bridges two enterprise data sources with strict read-only access and respects your existing authentication and authorisation.
- Python 3.10+
- MCP over stdio
- Azure AD auth
- Read-only
- 11 tools · 6 skills · 4 resources
One local process. Two enterprise sources.
Claude Desktop launches Exagomatica as a subprocess on first connection. All communication happens over stdio — no network ports opened, no inbound listener. The server then makes outbound REST calls to enterprise APIs using the user’s Azure AD credentials.
AI client
Claude Desktop
Natural language
MCP / stdio
MCP server
Exagomatica
11 tools · auth · DAX validator · ETL KB
REST · Azure AD
Power BI
Semantic model
Azure DevOps
ETL pipelines
SharePoint
via M365 connector
SharePoint document search is provided by Anthropic’s official Microsoft 365 connector in Claude Desktop (Settings › Connectors). Exagomatica’s /find-docs skill orchestrates whichever SharePoint search and read tools the connector exposes at runtime.
Eleven tools across four domains.
Each data tool is read-only and respects existing access controls. A license_status tool reports licensing state and is always callable.
Power BI Intelligence
pbi_get_schemaGet Semantic Model Schema
Returns tables, columns, measures, and relationships. Use this to understand what data is available before writing DAX queries.
pbi_execute_daxExecute DAX Query
Runs DAX EVALUATE statements against live data. Pre-validates names against the schema, checks syntax before execution, and suggests corrections. Results include an interactive chart view.
pbi_get_measure_definitionGet Measure Definition
Returns the DAX formula and metadata for a specific measure. Use this to understand how a KPI is computed.
Architecture & Knowledge Base
arch_overviewArchitecture Overview
Renders the unified data architecture: semantic-model tables/columns/measures on top, ETL entities in the middle, external sources at the bottom, with lineage edges connecting layers.
arch_searchSearch Architectural Entities
Finds where transformations happen by entity name. Searches dataflow .txt queries, .tmdl partitions, and shared M expressions.
arch_get_entityGet Architectural Entity Details
Returns the full transformation pipeline with business logic annotations, partition breakdown, and optionally the complete M code.
arch_list_sourcesList All Sources
Discovers all source repositories backing the architectural index. Each typically corresponds to a specific data domain.
kb_refreshRefresh Knowledge Base
Scans Azure DevOps, parses M code, and snapshots the Power BI schema. Supports full, incremental, and entity-specific refreshes. Auto-triggers on first use each session.
kb_statsGet KB Statistics
Returns entity counts, ADO repo coverage, semantic-model snapshot freshness, and last scan time.
DAX Reference
dax_lookup_functionLook Up DAX Function
Retrieves syntax, parameters, and examples for any DAX function from dax.guide. Helps Claude write idiomatic DAX.
Licensing
license_statusGet License Status
Reports active tier, customer, expiry, and feature flags. Always callable, even if licensing blocks data tools.
Six pre-built workflows.
Skills guide Claude through multi-step tasks — ensuring the right tools are called in the right order with appropriate context.
/analyze-dataAnalyze data from Power BI
Guided ad-hoc analysis. Discovers schema, writes optimised DAX, returns charts, and enriches answers with ETL pipeline context.
- pbi_get_schema
- pbi_execute_dax
- kb_refresh
/trace-dataTrace data lineage
Traces data from report columns back to source through every transformation step. Shows how data is filtered, renamed, and enriched.
- arch_search
- arch_get_entity
- pbi_get_schema
/explain-measureExplain a Power BI measure
Retrieves a measure’s DAX formula and translates it into plain business language so non-technical users understand exactly what the number means.
- pbi_get_measure_definition
- dax_lookup_function
/top-nTop / Bottom N analysis
Quick ranked analysis. Returns the top or bottom N records by any metric — great for leaderboards and outlier detection.
- pbi_get_schema
- pbi_execute_dax
/find-docsFind business documentation
Searches SharePoint for business docs and glossaries via the Microsoft 365 connector. Summarises findings so users get answers without reading whole documents.
- M365 connector
/refresh-etlRefresh the ETL knowledge base
Scans Azure DevOps dataflow repos and rebuilds the local knowledge base. Use after pipeline changes.
- kb_refresh
- kb_stats
Designed for enterprise environments.
Exagomatica is designed for environments where data security is non-negotiable.
Azure AD authentication
Corporate SSO with MFA support. Tokens are refreshed automatically. No separate credentials to manage.
100% local execution
The server runs on the user’s machine. Data flows directly from enterprise APIs to Claude Desktop. No third-party cloud services involved.
Permission-aware
Every query respects Row-Level Security and existing access controls. Users see only what they’re authorised to see.
- Read-only access — no DDL operations
- DDL blocklist enforced at the server level
- Encrypted credential storage via OS keyring
- No telemetry or data collection
- License key via environment variable
- Configurable query result size limits
- Full audit trail in local logs
- MCP stdio transport — no open network ports
Technical specifications.
- Runtime
- Python 3.10+
- MCP SDK
- mcp (FastMCP) — v1.25.0+
- Protocol
- Model Context Protocol over stdio
- Authentication
- Azure Identity / MSAL
- AI client
- Claude Desktop (Windows, macOS, Linux)
- Platforms
- Windows 10/11, macOS 12+, Linux (x86_64)
- Installer
- Inno Setup (Windows), pip (all platforms)
- Config location
- %APPDATA%\Exagomatica\
- Env prefix
- EXAGOMATICA_
- MCP surface
- 11 tools · 6 prompts · 4 resources
- Data access
- Read-only — DDL blocked at server level