JULY 15, 2025

4 MIN READ

SYLVAIN UTARD

Under the Hood: Agents

Under the Hood: Agents

Altertable agents think ahead. Powered by custom lakehouse and MCP, they monitor, investigate, and act on your data autonomously.

0:00
3:47

Gen-AI Audio

Share

Blog

At Altertable, we're building something simple but radical: data agents that work so you don't have to.

These agents don't just respond to queries. They monitor. They investigate. They remember. And when they find something that matters (an anomaly, a correlation, a segment worth testing, ...): they tell you. Otherwise, they stay quiet and keep watching. We're moving from passive dashboards to active dialogue.

This is analytics reimagined: not a dashboard waiting for a click, but an insight engine that thinks ahead.

An operating system for your data

Most agent systems depend on someone else's stack. We built our own, from ingestion to insight.

We run on a custom-built, in-house lakehouse architecture: engineered for fast, unified access across event data, product usage, and business metrics. Learn about our full technical stack. Our lakehouse isn't just storage; it's the foundation of a full-stack platform. From event collection to modeling to real-time analysis, we own the pipeline.

That's what enables our vision of a data operating system: a unified environment where agents, memory, computation, and interfaces all work together, seamlessly.

Tools matter. A lot.

Our agents aren't generating answers from thin air. They operate through our internal Model Context Protocol (MCP), a system that exposes core analytics primitives like:

  • Schema introspection
  • Semantic layer
  • Event funnels & segmentation
  • Time-based breakdowns
  • Cohort definitions
  • SQL access to raw data
  • Chart rendering and dashboard manipulation
  • and more...

Behind each agent action is a well-defined MCP call: transparent, auditable, and consistent. This is how we avoid hallucinations and deliver explainable, reproducible insights.

Memory: the key to continuous intelligence

Most analytics tools forget everything after a session ends. Ours don't.

Every Altertable agent operates with persistent memory: tracking past workflows, accepted/rejected hypotheses, user preferences, and prior anomalies. This shared memory is critical. It lets agents avoid repeating past failures, learn which patterns matter to your team, and adapt over time.

Without memory, AI agents are stateless scripts. With memory, they become intelligent systems that build on what they (and your team) already know.

What our agents actually do

Here's how a typical sequence unfolds:

  • Coordinator agent receives a new task.
    • Determines which agents to activate.
    • Gathers memory and context from previous interactions.
    • Injects company metadata, roadmap signals, recent changes.
  • Preparer agent scopes and cleans the data.
    • Joins events, filters sources, and ensures proper structure.
    • Uses our internal MCP tools to create a reliable dataset for analysis.
  • Investigator agent explores the data.
    • Runs statistical tests, finds outliers, compares time ranges.
    • Flags changes, anomalies, and hypotheses.
    • Cross-checks memory to avoid redundant or rejected paths.
  • Visualizer agent builds the story visually.
    • Suggests or creates new visuals tied to the findings.
    • Updates or improves dashboards accordingly.
  • Synthesizer agent composes the output.
    • Compiles agent contributions into a coherent narrative.
    • Includes executive summaries, evidence, and historical context from prior runs.

Many of these agents run silently, in the background. They don't interrupt your day—they enhance it. If nothing notable happens, they log and wait. If something changes, they'll be the first to know, and the first to tell you!

Why it matters

The modern data stack is too manual. It's reactive, fragmented, and expensive. Teams are left babysitting pipelines and digging through dashboards, just to answer basic questions.

We're replacing that with a full-stack platform that thinks ahead. Our agents analyze, remember, and act because they're built on top of a data operating system designed for proactive, always-on insight.

If your stack feels more like a patchwork than a platform, let's talk.

Share

Sylvain Utard, Co-Founder & CEO at Altertable

Sylvain Utard

Co-Founder & CEO

Seasoned leader in B2B SaaS and B2C. Scaled 100+ teams at Algolia (1st hire) & Sorare. Passionate about data, performance and productivity.

Stay Updated

Get the latest insights on data, AI, and modern infrastructure delivered to your inbox

For more information, please consult our Privacy Policy

Related Articles

Continue exploring topics related to this article

Let Agents Render the Platform
MAY 25TH, 2026
Florian Valeye

Let Agents Render the Platform

Architecture, AI Agents, Engineering

Charts, queries, and interactive UI, now rendering inside any AI agent through MCP Apps.

READ ARTICLE
Memory Is Not a Database
MAY 18TH, 2026
Florian Valeye

Memory Is Not a Database

AI Agents, Architecture, Engineering

Intelligence without memory is nothing. The right model is memory that lives, forgets, and knows where it belongs.

READ ARTICLE
What We're Building
JULY 8TH, 2025
Sylvain Utard

What We're Building

Product, Architecture, AI Agents

Most data platforms wait for questions. Altertable doesn't. We're building an AI-native data OS that turns raw data into continuous insight.

READ ARTICLE
Upstreaming with AI
SEPTEMBER 23RD, 2025
Sylvain Utard

Upstreaming with AI

Open Source, Engineering, AI Agents

How we contributed 17 upstream PRs in 90 days—where AI accelerated our workflow, what we learned, and practical tips for open source success with AI assistance.

READ ARTICLE
Upside-Down Architecture
JANUARY 20TH, 2026
Yannick Utard

Upside-Down Architecture

Architecture, Engineering

Most analytics queries scan <100MB. We explore a hybrid architecture where compute moves between servers and your local machine, powered by DuckDB and DuckLake.

READ ARTICLE
Altertable Logo

A lakehouse your apps, BI, and agents share

DuckDB workers on open formats, federated SQL across your existing systems,
and an MCP server for agents — at flat monthly pricing.