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.

Listen to this article (Gen-AI)

0:00
3:47
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

Related Articles

Continue exploring topics related to this 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
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
From Task Executors to Outcome Owners
JANUARY 28TH, 2026
Kevin Granger

From Task Executors to Outcome Owners

AI Agents, Product, Culture

AI is transforming data roles from task execution to strategic ownership. Learn how data teams are evolving in 2026 and what skills matter most in the AI era.

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
Lessons from Search
JANUARY 13TH, 2026
Sylvain Utard

Lessons from Search

Performance, Architecture, Engineering

Real-time analytics faces the small-file problem search engines solved. DuckLake's tiered compaction brings those merge strategies to streaming analytics.

READ ARTICLE
Altertable Logo

Wake Up To Insights

Join product, growth, and engineering teams enabling continuous discovery