DataGrout.ai Logo
Tool Suite ยท Prism

Transform Data.
Analyze. Visualize. Export.

Prism is DataGrout's data transformation, analysis, and visualization layer. Describe what you want in natural language โ€” Prism generates verified, sandboxed code that runs deterministically on every subsequent call.

9 tools

refract ยท analyze ยท chart ยท focus ยท render ยท export ยท paginate ยท orient ยท horizon

Self-healing & cached

first call generates code ยท every repeat skips AI entirely

Inline on any tool

pipe refract or chart onto any discovery.perform result

Free to start ยท No credit card required

Nine Tools. Every Data Operation Your Agent Needs.

From natural language transforms to type bridging, charting, and paginated exports โ€” Prism handles the full data lifecycle between your tools.

prism.refract

Natural Language Transform

Reshape any data structure using plain English. Describe the transformation โ€” group, flatten, rename, filter, sum, merge โ€” and Prism generates sandboxed executable code. The first call uses AI; every repeat with the same intent hits the cache and runs deterministically at near-zero cost.

Best for: Reshaping tool outputs between pipeline steps

Key capabilities

  • Any JSON shape: arrays, nested maps, mixed structures
  • Self-healing: failed edge cases auto-correct and re-cache
  • Verbose mode returns transformation metadata
  • Inline: add refract to any discovery.perform call
  • Progressive efficiency: same intent = skip AI entirely
๐Ÿ’ณ First call: AI credits. Repeat calls: near-zero (cache hit)
View prism.refract docs โ†’

What Prism Solves

Every agent workflow generates data that needs reshaping, bridging, analyzing, or presenting. Prism handles all of it without leaving the platform.

Reshape Data Between Pipeline Steps

Agent retrieves raw Salesforce leads โ€” 47 fields each. Prism.refract extracts just name, email, and annual revenue in one call. Cached on first run; every repeat skips AI and executes deterministically.

prism.refract

Cross-System Type Bridging

Qualified Salesforce leads need to become QuickBooks customers. Prism.focus bridges crm.lead@1 โ†’ billing.customer@1 automatically โ€” no manual field mapping, no glue code. discovery.plan inserts it for you.

prism.focus

Instant Charts From Any Tool Output

Add a chart parameter to any discovery.perform call and get back a hosted SVG URL, sparkline, and summary statistics โ€” no separate visualization step, no extra round-trip.

prism.chart

Decision Support & Anomaly Detection

Feed a dataset to prism.analyze with mode: 'exploratory' and get back structured findings, evidence citations, and confidence scores โ€” not just data, but reasoned conclusions.

prism.analyze

Automated Report Generation

Chain tool results into prism.render for branded reports in any format โ€” markdown summaries, PDF decks, XLSX tables, or HTML dashboards โ€” from a single natural language instruction.

prism.renderprism.export

Progressive Efficiency Over Time

The first time an agent runs a Prism transform, AI generates verified executable code. Every subsequent call with the same intent runs from cache โ€” zero AI cost, deterministic output. Agents get faster the more they run.

prism.refractprism.chart
Power-Up Combos

Prism Amplifies Every Other DataGrout Tool

The real power of Prism is how it slots into the rest of the platform โ€” transforming, analyzing, and presenting results from any tool without leaving your workflow.

Prism+Discovery

Inline Transform on Any Tool Call

Add refract or chart as a parameter directly to any discovery.perform call. The result is automatically piped through Prism server-side before reaching your agent โ€” no extra round-trip, no re-fetching the raw data.

discovery.perform(tool, refract="sum totals by region", chart="bar chart")

โœฆ One call from raw tool output to formatted, visualized result

Prism+Flow

Automated Reporting Pipelines

Chain prism.render or prism.export as the final step of a flow.into plan. Every time the workflow runs โ€” on a schedule or event trigger โ€” it outputs a fresh PDF report or XLSX export automatically.

flow.into([fetch_data_step, prism.render(format='pdf')])

โœฆ Hands-free, repeatable report generation at any cadence

Prism+Data / Frame

Filter First, Transform Cheaper

Use free Data or Frame tools to filter and slim a dataset before passing it to prism.refract or prism.analyze. Smaller payloads = lower AI costs and faster cache hits.

frame.filter(cache_ref) โ†’ prism.analyze(cache_ref, mode='causal')

โœฆ 10โ€“100x cheaper AI transforms by pre-filtering with free tools

Prism+Governor

Continuous Analytical Monitoring

Schedule a prism.analyze call via Governor to run on a recurring basis against live data. Governor's symbolic reflex layer checks preconditions for free; analysis only fires when the data actually changes.

discovery.perform(skill_handle, schedule="every hour")

โœฆ Always-on analysis that only burns tokens when it matters

Conduit SDK

Integrate Prism in Minutes

One import. Auth, retries, and caching all handled by the Conduit SDK.

prism.refract ยท Python ยท Conduit SDK
from datagrout.conduit import Client

async with Client(
    "https://gateway.datagrout.ai/servers/{uuid}/mcp",
    auth={"bearer": "your-access-token"}
) as client:

    # Transform raw invoice data
    result = await client.perform("data-grout@1/prism.refract@1", {
        "goal": "group invoices by customer and sum totals",
        "payload": [
            {"customer": "Acme", "amount": 500, "status": "paid"},
            {"customer": "Globex", "amount": 300, "status": "unpaid"},
            {"customer": "Acme", "amount": 200, "status": "unpaid"},
        ]
    })
    # result["result"] = [
    #   {"customer": "Acme", "total": 700, "count": 2},
    #   {"customer": "Globex", "total": 300, "count": 1}
    # ]

    # Use cache_ref from a prior tool call โ€” data stays server-side
    transformed = await client.perform("data-grout@1/prism.refract@1", {
        "goal": "extract only name and email fields, flatten address to one line",
        "payload": prior_cache_ref
    })

Also available in TypeScript, Rust, Elixir, and Ruby. View Conduit SDK โ†’

Frequently Asked Questions

Common questions from developers integrating Prism into their agents and workflows.

More questions? Read the full Prism documentation.

Stop writing data glue. Start describing outcomes.

Prism transforms, bridges, analyzes, and visualizes your data โ€” in natural language, with verified code, from any tool in your mesh.

Free to start ยท No credit card required

We use cookies to improve your experience, analyze site traffic, and serve personalized content. By clicking "Accept All", you consent to our use of cookies. See our Privacy Policy for details.

Ask the Advisor