BI Teams & Data Engineers
Design and deploy data warehouses faster and more efficiently.
DataForge
AI ReadyAn innovative tool for collaborative data warehouse design and modeling. Centralized construction and maintenance of the DataMart layer. Visual modeling, automatic generation of models and DDL scripts, and business logic documentation.
DataForge integrates AI agents and the MCP Server to significantly expand the platform’s capabilities. These components automate the creation of the KPI & Measurement Registry, transform existing DWH structures into a fully defined semantic layer, and enable secure, governed access for AI models to both data and metadata.
About the Product
What is DataForge?
DataForge is an innovative platform for collaborative design and visual modeling of enterprise-grade data warehouses (DWH). It enables centralized development and maintenance of the DataMart layer with visual modeling, automatic generation of models and DDL scripts, and comprehensive documentation of business logic.
You can visually design fact tables with drag-and-drop tools, automatically generate logical and physical data models, document metrics and attribute definitions, and export ready-to-run DDL scripts for relational databases.
With built-in AI agents and the MCP Server, DataForge evolves from a traditional data-modeling tool into a complete, intelligent analytics platform. AI can automatically generate KPI registries, answer business questions, build SQL queries, and create HTML dashboards - all using the semantic layer and Data Mart data. DataForge brings together data modeling, semantic governance, and AI-driven analytics into a single, cohesive solution, accelerating the delivery of insights across the enterprise.
Key Features
Data Warehouse Implementation
- Automatic DDL script generation
- Integration with relational databases
- Support for conceptual, logical, and physical modeling layers
- Continuous data synchronization and monitoring
- Data integrity checks
- Model and schema version control
Business-Focused Data Management
- Definition and management of business indicators, dimensions, and metrics
- Creation and maintenance of data marts
- Seamless synchronization with source systems
- Built-in data consistency verification
- Update and maintenance of existing models
Data Modeling & Design
- Drag-and-drop visual fact table designer
- Auto-generation of logical and physical data models
- Entity-Relationship (ER) diagrams
- Documentation of business logic
Flexible DataMart Creation Options
- Single-fact tables with grouping or aggregation
- Multi-fact marts via joins on common dimensions
- Multi-fact marts via UNION ALL with differentiation fields
- Combined marts with UNION ALL and pivoted measures
AI tools
AI Agent for Automatic KPI & Dimension Registry Generation
This AI agent automatically generates a KPI & Dimension Registry based on existing technical artifacts, including database DDL scripts. The algorithm analyzes table structures, data types, relationships, and keys, extracting schema names, tables, and data sources while classifying attributes into “KPI” and “Dimension” categories. Using contextual analysis, the agent is able not only to understand the structure, but also to interpret the meaning of the data, automatically generating clear and business-friendly descriptions.
MCP Server (Model Context Protocol)
The MCP Server acts as a universal integration layer between enterprise data enriched with metadata from DataForge and Large Language Models (LLMs) that use this data for analytics, data mart generation, model creation, and reporting. MCP provides secure and standardized access to the semantic layer, data structures, and DWH repositories, creating a unified interaction point between the data infrastructure and AI agents.
GitHub →Analyst Agent
An AI agent for conversational interaction with enterprise data. The user asks a business question in natural language, and the agent independently determines which data is required, accesses the DataForge semantic layer through the MCP Gateway, explores the database structure when necessary, generates SQL queries, validates the results, and returns a ready-to-use analytical answer. The agent can explain KPIs, build tables and charts, identify anomalies, compare periods, detect leaders and outliers, generate concise conclusions, and suggest follow-up questions to continue the analysis.
Problems DataForge Solves
Why Choose DataForge?
Problems DataForge Solves
Value Proposition
Who is DataForge for?
Enterprise Architects
Maintain consistent, scalable data models across projects and departments.
Business Users
Define key metrics and dimensions for analytics — without technical barriers.
What else
Functionality Overview
Core Capabilities
- Define business indicators and dimensions
- Create fact and reference tables
- Build metrics based on defined measures and dimensions
- Design and manage data marts
- Generate and deploy DDL scripts
- Connect to existing DWH systems
Main Advantages
- Accelerated DWH deployment
- Reduced manual effort and fewer errors
- Improved documentation and governance
- Seamless integration with your current infrastructure
- Data validation and audit tools
- Continuous synchronization of models and real databases
Benefits
How DataForge Benefits Businesses and Data Teams
A centralized KPI and Dimension Registry helps organizations manage business logic, accelerate data mart development, and reduce inconsistencies across enterprise reporting.
Single Source of Truth for Formulas
KPIs and metrics are defined once and reused across data marts, reports, dashboards, and BI platforms.
Faster Data Backend Development
KPIs and dimensions can be modified through registry configuration without rewriting SQL queries, ETL pipelines, or reporting logic.
Clearer Business-to-IT Communication
Business users and developers work with a shared set of KPI definitions, dimensions, and business metrics.
Proactive Data Quality Control
Anomalies, inconsistencies, and potential issues can be detected before they impact reports and business decisions.
More Efficient Teams and Contractors
Analysts and external teams consume ready-to-use metrics instead of manually recreating business logic in every report.
Reliable Foundation for AI Agents
A machine-readable layer of metrics and calculation rules enables AI agents to generate responses based on accurate data and consistent business logic.
Licensing Model
Simple and Transparent Subscription
DataForge is distributed under an annual subscription model. A free trial with limited functionality is available for evaluation purposes.
Available license types:
- Developer — 850 $/year
- Analyst — 280 $/year
Enterprise deployment terms are calculated individually.
Free Trial
Free
For evaluating the platform
Limited functionality
Developer
850 $/year
For platform configuration and maintenance
Analyst
280 $/year
For business users
Working with ready-to-use analytics
License Features
| License Features | Analyst | Developer |
|---|---|---|
| View projects | ✓ | ✓ |
| Generate and view SQL scripts | ✓ | ✓ |
| Create projects | ✓ | ✓ |
| Edit own projects | ✓ | ✓ |
| Edit other users’ projects | — | ✓ |
| Work with RMD | ✓ | ✓ |
| Work with fact tables | ✓ | ✓ |
| Run SQL scripts for fact tables | ✓ | ✓ |
| Work with data marts | — | ✓ |
| Run SQL scripts for data marts | — | ✓ |
| User management | — | — |
| View system logs | — | — |
How It Works
Step 1: Define Business Requirements
Document your key business indicators, dimensions, and relationships.
Step 2: Build and Visualize the Data Model
Use intuitive drag-and-drop tools to design fact and dimension tables.
Step 3: Generate and Deploy SQL Scripts
Export automatically generated SQL scripts for seamless implementation.
Step 4: Synchronize and Maintain
Keep business requirements, data models, and databases perfectly aligned.
Screenshots
Product Roadmap
Upcoming developments include:
- Row-Level Security (RLS) and role-based access control
- Integration with Active Directory and LDAP
- Single Sign-On (SSO) support
- Registration in the Russian software registry
- Enterprise private cloud deployment
- Advanced user activity monitoring and audit
Partners
Technology & Integration Partners
