Product · since 2024
DataPilot
ask, query, govern and automate enterprise data
One analyst's afternoon on the demo: a question becomes a grounded answer with a table and a chart, the same question as SQL with its profile and plan, quality rules on the invoices table and a run that scores it and lists the failing rows, the assistant's assumptions vetted by a person, the knowledge graph behind it, a Weave flow quarantining bad rows, an agent pausing for approval, a coordinator investigating with SQL tools, faceted search, a narrated data story, and the access matrix that governs it all.
The 14 scenes, in order
Primary use. One platform to ask, query, govern and automate enterprise data. Chat streams answers over WebSocket through four engines — plain LLM, agentic (live tool calls), RAG (knowledge-graph-grounded SQL) and an auto-router that picks the engine per turn and shows why — with voice in/out, attachments, inline tables and charts, and per-response cost. A multi-tab SQL workbench (schema-aware autocomplete, database navigator, cache-backed grid) with analysis tabs for AI-to-SQL, pivot, profiling, execution plan and data-quality rules. A three-layer semantic catalog (physical → logical → canonical) with a schema graph. Weave: a visual data-flow builder — CSV/Parquet/Trino sources, joins, transforms, quality nodes, SQL/stored-procedure/API call-outs — run as scheduled tasks with parameters, variable sets, retries and notifications. Orchestrate: agentic workflows on the same canvas — manual, chat, cron or webhook triggers; LLM prompt, intent router and field extraction; SQL, HTTP, Slack and Weave steps; branching, loops and merges. A Monitor over every flow, task and workflow run; Projects and masked variable sets; Facets (faceted-search dashboards), data Stories, Notebooks and a control-room Home with KPIs, run feed and next scheduled runs. Connects 30+ database engines, REST APIs and files, plus a Trino data-lake admin. Ships as an 11-container Docker Compose stack.
Differentiator.Grounded, not guessing — every connection carries its own knowledge graph (abbreviations, discovered relationships, golden question→SQL pairs) that RAG retrieves before writing SQL, and the assistant clarifies instead of guessing when a question is ambiguous.
Agents that do work, with a human in the loop: a Coordinator Agent spins up dynamic sub-agents, delegates or fans out to other workflows, streams its run live, and pauses at a Wait for Approval step (suspend/resume) before anything consequential; any workflow can be exposed as an agent inside Chat. Governance built in: roles are data behind an auditable permission switchboard; every route declares its authorization check and coverage tests fail the build when one doesn't; object-level data access, per-role tool permissions (run / export / AI / share / DQ), SSO via Keycloak or Entra ID with ID-token verification, PKCE, back-channel logout and session revocation. External systems are chat tools over MCP — Jira/Confluence, GitHub, SharePoint (with RAG indexing) and any connected database as read-only SQL — each toggled per conversation.
Governance. Built in, not bolted on. Auditable role permissions, object-level data access, coverage tests that fail the build when a route lacks an authorization check, and SSO via Keycloak or Entra ID.






