The semantic layer & reporting engine built for AI agents.
Motley gives AI agents a governed view of your data and turns their output into auditable, repeatable files. Build on the open-source semantic layer (SLayer), leverage Motley's platform to accelerate your data driven agent development, or use the plugin to connect to Claude for reporting
.png)
Trusted by:
What is Motley
SLayer (open source)
The semantic layer that makes AI agents actually understand your data.
SLayer sits between your warehouse and your agents. Agents query in terms of measures, dimensions, filters, and time grains. SLayer compiles to SQL, runs it against the warehouse, and returns typed results. One definition of every metric, enforced across every agent and app, less silent failures
Key points:
Agent-first design: MCP, REST API, and Python SDK
Rich metric expressions: reusable measures, dimensions, filters, and logic
Embeddable semantic layer: use via API, plugin, or inside your product
Datasource-agnostic: Postgres, Snowflake, BigQuery, ClickHouse, and more
MIT licensed and extensible
View on GitHub
Motley Platform
The intelligence layer between your data and your AI agents.
Motley wires your databases to your agents. SLayer governs the metrics, the harness grounds every number, and masters turn reports into templates that fire on conditions you set, so a signal in your warehouse becomes a Slack message and an input for your agents.
Key points:
Native MCP server for AI agents
Governed metrics via SLayer, our open-source semantic layer
Connects to your SQL databases and warehouses
Composable primitives: queries, tables, charts, text, reports, masters
Versioned history of every output, manageable via UI or MCP
Learn more about the platform
Motley Plugin
Generate reports from your data in Claude
The Motley plugin comes preloaded with reporting and presentation skills, generating high-quality, interactive HTML presentations that can be edited with Claude and serve as a strong baseline for other presentation tools.
Key points:
MCP plugin for Claude
Reporting skill create a full presentation from a single prompt with strong data driven storytelling
Presentation ready: generated HTML report in your own branding with an easy to use skill
Fully auditable: All reports have fully traceable numerical value and can be audited in Motley's platform
Flexible integration: combine it with your CRM MCP and/or your call assistant MCP for complete context
Try the Plugin
Integrations
.svg)
.png)
How It Works
Connect Your Data
Plug in your database, data warehouse, or BI tool. SLayer introspects the schema and generates semantic models automatically — no manual configuration needed
Define What Matters
Refine your models with business-specific metrics, dimensions, and context. This is where organizational knowledge becomes machine-readable. Define it once; every agent and app uses the same definitions.
Generate Reports
Use the Motley Plugin to create reports conversationally, or call the API programmatically. Motley pulls data through SLayer, builds the narrative, and outputs a finished deck, document, or dashboard.
Ship It
Deliver reports as PPTX, embed them in your product with Embedded Motley, or build custom experiences on top of the Motley platform. Your data, your story, your way.
The Problem
Before Motley
Agents hallucinate metrics because they're writing SQL against a schema they don't understand
Every team defines "ARR" or "active user" slightly differently, and no one notices until the board deck
Reports are one-offs – rebuilt by hand every cycle, impossible to audit
Shipping reporting in your product means staffing a data platform team
Dashboards answer "what happened" but not "why it matters" — and no one reads them
With Motley
Agents query through a governed semantic layer, not the raw schema
One definition of every metric, enforced across every agent and surface
Reports are markdown files: versioned, diffable, forwardable, regenerable
Embedded Motley ships reporting into your product without a platform build
Narrative-first output: rose, charts, and queries in one artifact
Whoʼs Motley for
Data & Engineering Teams
Use SLayer as the governed data access layer for AI agents. Define metrics once, query from anywhere — MCP, REST, Python, or CLI.
Product Teams Building Reporting
Add AI-powered reporting to your SaaS product without building a data pipeline. Embedded Motley handles the data layer, narrative, and presentation.
Revenue Operations
Generate pipeline reviews, forecast decks, and performance summaries from live CRM and database data.
Customer Success Teams
Automate QBRs, monthly check-ins, onboarding updates, and value reports. Spend your time on retention and growth, not slide assembly
"Our challenge is that none of the existing AI tools seems to do the data crunch, visualisation and consistent report building at the same time. ChatGPT is awfully inconsistent, Gamma can't crunch the data and Julius doesn't have a repeatable process"
Erik Beentjes
FAQs
Motley is an open-source semantic layer (SLayer) and a reporting engine built on top of it. Agents query your data through SLayer; Motley turns those queries into reports you can forward, version, and embed.
SLayer is agent-native: it exposes 14 tools over MCP out of the box, supports composable time formulas, and ships with pluggable storage. It's designed to sit in front of AI agents, not BI dashboards.
Text-to-SQL hallucinates joins, silently redefines metrics, and produces different numbers on different runs. A semantic layer constrains the agent to a governed set of measures and dimensions: same query, same answer, every time.
SOC 2 Type 2 on track for 2026. Data shared with model providers is scoped to the report being generated, never used for training, and can be self-hosted end-to-end if you run SLayer yourself.
Data and engineering teams that want to expose their warehouse to AI agents safely. Product teams shipping reporting features. Developers who want their agents to generate accurate reports instead of guessed SQL.
SLayer is MIT-licensed and free. The Motley plugin has a free tier (10 docs/month) and paid plans from ~$5/month. Embedded Motley is priced per design partner — contact us.
Reports, not dashboards. Markdown as the source of truth. A semantic layer you can actually read the code of. Built for the agentic era from the first commit.