datagallery-ai/dataagent
DataFoundry is an open-source AI workbench for data analysis, unifying data sources, knowledge, tools, and agent runtime into a governed workspace for interactive analytics.
What it solves
DataFoundry addresses the risks and inaccuracies associated with using AI to query enterprise databases. It moves beyond simple "prompt-to-SQL" chatbots by ensuring the AI understands business definitions (semantics), operates within strict read-only boundaries to prevent data mutation, and maintains a fully auditable trail of every step to ensure conclusions are verifiable.
How it works
The system operates as a governed data-task workbench. When a user asks a business question, the agent first aligns the natural language terms with the actual database schema and business metrics. It then executes queries through a "Data Gateway" that enforces security guardrails—such as row limits, timeouts, and field masking—before materializing the results into tables, charts, or reports. Every action, including the SQL generated and tool calls, is persisted for replay and review.
Who it’s for
It is designed for enterprise teams who need to perform complex, multi-step data analysis using AI without compromising production data security or sacrificing the accuracy of business-specific definitions.
Highlights
- Broad Connectivity: Supports 28 datasource types out of the box, including PostgreSQL, Snowflake, BigQuery, MongoDB, and Elasticsearch.
- Enterprise Semantics: Centralized management of schema and metric definitions to prevent the AI from guessing fields or joins.
- () Self-Hosted & Multi-Model: Can be deployed locally to keep data within company boundaries and supports any OpenAI-compatible model (e.g., Qwen, DeepSeek, GPT).
- Auditability: Full persistence of SQL and event streams, making every analysis step replayable and evidence-backed.
- Flexible Interfaces: Provides a Web workbench, a Terminal UI (TUI), and a REST API for embedding the agent runtime into other products.
Related
- Project
- Project
- Project
- Project