Skip to main content

Python-native semantic modeling and analysis library for agentic analytics.

Project description

Marivo

Metric-centered analysis runtime for AI agents.

Marivo is a Python library — not a hosted service or a chat UI — that turns a data warehouse into something an AI agent can analyze reliably. It is not a text-to-SQL wrapper: Python declarations are the contract, ibis expressions are the execution language, and typed frames are the boundary between analysis steps.

  • Unified semantics — Datasources, entities, metrics, dimensions, and relationships are declared in Python and addressed by semantic ref (sales.revenue), not raw table or column names.
  • Metric-centered analysis — Sessions start from a trusted metric and chain typed intents (observe, compare, decompose, correlate, forecast), each returning a typed frame.
  • Trustworthy evidence — Every operator records findings, propositions, and assessments, so any conclusion can be traced back to its inputs.
  • Readiness gatescatalog.readiness() blocks incomplete semantic objects from analysis until authoring and access issues are resolved.

Requirements

Python 3.12 or newer.

Installation

pip install marivo

Install the backend extra that matches your datasource:

Backend Install command
DuckDB pip install "marivo[duckdb]"
MySQL pip install "marivo[mysql]"
Postgres pip install "marivo[postgres]"
ClickHouse pip install "marivo[clickhouse]"
Trino pip install "marivo[trino]"
All packaged backends pip install "marivo[all]"

Marivo is deployed by installing the library where the agent runs, checking in the models/ declarations, and providing datasource secrets through environment variables referenced by *_env fields. There is no separate server.

Quick Start

Scaffold a project with the CLI:

marivo init

marivo init creates the project skeleton (marivo.toml, models/, .marivo/) and installs the marivo-semantic and marivo-analysis skills for Claude Code and Codex, so a coding agent can author the semantic layer with you.

Declare semantics under models/semantic/, then load and analyze:

import marivo.semantic as ms
import marivo.analysis as mv

catalog = ms.load()
report = catalog.readiness()
if report.status == "blocked":
    report.show()                       # resolve blockers before analysis

session = mv.session.get_or_create(name="revenue-check", question="Why did Q4 drop?")
revenue = session.catalog.get("sales.revenue")
region = session.catalog.get("sales.orders.region")

current = session.observe(revenue, timescope={"start": "2026-10-01", "end": "2027-01-01"}, grain="month", dimensions=[region])
baseline = session.observe(revenue, timescope={"start": "2025-10-01", "end": "2026-01-01"}, grain="month", dimensions=[region])

delta = session.compare(current, baseline)
session.decompose(delta, axis=region).show()

In-project help is available at every surface: ms.help() and mv.help() list the surface; ms.help("metric") and mv.help("observe") drill into a symbol.

Documentation

Full guides live in the documentation site (built from site/):

  • Installation — install, marivo init, deploy.
  • Quick Start — author declarations, load a catalog, run a first analysis.
  • Concepts — semantic layer, analysis workflow, readiness, and evidence.

Maintained agent guidance lives in marivo/skills/marivo-semantic and marivo/skills/marivo-analysis.

Development

python3 -m venv .venv
.venv/bin/pip install -e ".[dev,duckdb,trino]"

Repository commands run through the local virtualenv via make:

make lint
make typecheck
make examples-check
make test
make check

Read agent-guide.md before contributing. See CONTRIBUTING.md for the full workflow.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

marivo-0.1.0.tar.gz (795.9 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

marivo-0.1.0-py3-none-any.whl (577.9 kB view details)

Uploaded Python 3

File details

Details for the file marivo-0.1.0.tar.gz.

File metadata

  • Download URL: marivo-0.1.0.tar.gz
  • Upload date:
  • Size: 795.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.13

File hashes

Hashes for marivo-0.1.0.tar.gz
Algorithm Hash digest
SHA256 0933f1932b0a74f26e83f387ac9452b6aa3f35faafe0efc1e32c279904e19406
MD5 c028bda309b5158a406876188d201dd4
BLAKE2b-256 333d1ff896490039852a6226ea31954eb254396a672586e233ddb2279183cf78

See more details on using hashes here.

File details

Details for the file marivo-0.1.0-py3-none-any.whl.

File metadata

  • Download URL: marivo-0.1.0-py3-none-any.whl
  • Upload date:
  • Size: 577.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.13

File hashes

Hashes for marivo-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 f7b6fc183bd714ab05c81e4f25a0ab7a3d553b2b4163a2b95517bbc20bc31e36
MD5 abdf5a4ba19b9ec4c172c5403bc624ab
BLAKE2b-256 391484810303c7ab9fb2fcaf30c1eed2f839a99315465e11dbc43d80b610cc46

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page