SLayer v0.3.1 is live — the open-source semantic layer built for AI agents. View on GitHub →

Make every AI agent a reliable data analyst.

Motley turns your warehouse into a governed, agent-ready analytics platform, so every report your agents generate is auditable, repeatable, and built on a single definition of every metric.

Trusted by:

Seedcamp logoImpactPilot logoTSIC logoFounders logoEvelart logoRTP Global logoNoosa Labs logo
Product overview

Agent-ready analytics for your data

Motley turns your warehouse into analytics your AI agents can use: so the reports they generate are accurate by construction, not by luck.

SLayer (open-source): the semantic layer your agents query. Define every metric once; expose it over MCP, REST, Python, or CLI. Same query, same answer, every time.

Motley reporting engine: the runtime on top. Compose queries, tables, charts, and narrative into versioned Markdown reports your team can forward, diff, audit, and regenerate on demand.

A Claude plugin: the easiest way to try it

Core components

Inside 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

Integrations

How It Works

Connect Your Data

Plug in your database, data warehouse, or BI tool. SLayer introspects the schema and generates semantic models automatically: get started in minutes not weeks.

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 structured, auditable report.

Ship It

Deliver reports as Markdown files, convert them to PPTX or HTML presentations, embed them in your product, or build custom experiences on 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

Ship in-product reporting in weeks: without staffing a data platform team

Reports answer "why it matters": narrative, charts, and tables in one artefact

Whoʼs Motley for

Data & Engineering Teams

One semantic layer, every agent. Define metrics once; expose them via MCP, REST, Python, or CLI.

Product Teams Building Reporting

Ship AI reporting inside your product. Embedded Motley handles the data layer, narrative, and rendering: no platform build.

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"

ImpactPilot logo

Erik Beentjes

FAQs

What is Motley?

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.

How does Motley handle security and data?

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.

Why a semantic layer instead of text-to-SQL?

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.

Who is Motley for?

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.

How much does it cost?

SLayer is MIT-licensed and free. The Motley platform offers a free tier for individual users, a $25-per-month tier for power users, and starts at a $250-per-month tier for Enterprise with unlimited users.

What makes Motley different?

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.

How does SLayer differ from dbt MetricFlow or Cube?

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.