AI-powered Kimball modeling with an interactive visual builder. Paste your source schema, get a complete star schema in seconds — then drag, edit, and export.
datamodelassistant.com accepts SQL DDL statements, CSV files, and ERD screenshots as input and generates complete Kimball star schemas or Data Vault 2.0 models using AI. The interactive visual builder lets you drag, edit, and refine tables and relationships, then export to PostgreSQL, Snowflake, BigQuery, Mermaid ERD, or full documentation.
Drag-and-drop fact and dimension tables. Edit columns inline, draw relationships, and auto-layout your star schema.
Paste your source schema and get a complete Kimball dimensional model in seconds. Refine with follow-up chat.
Export SQL DDL, Mermaid ERD diagrams, and full model documentation. Save your work and iterate.
The tool accepts SQL DDL statements, CSV files, and ERD screenshots via Vision AI. Paste your DDL directly or upload a file to get started.
datamodelassistant.com generates Kimball star schemas and Data Vault 2.0 models. You can specify your preferred methodology in the chat, and the AI applies the correct grain, hub, satellite, and link patterns accordingly.
Yes. The AI has specific knowledge of SAP FI/CO, Salesforce, Oracle EBS, and Workday source schemas and applies the correct grain and foreign key relationships for those systems.
After the AI generates a model, you can drag tables, edit column names and data types inline, draw or remove relationships, and auto-layout the diagram. Changes update the underlying model in real time.
Models export to PostgreSQL, Snowflake, and BigQuery DDL SQL, Mermaid ERD syntax, and full documentation in Markdown.
Yes. The interactive demo at /demo runs without an account and lets you paste a source schema and see a generated dimensional model immediately.
One plan with everything you need.
Join data engineers who are building better data warehouses with AI assistance.
Start Modeling Now