Tag: data-modeling
Migrate Metabase to Bonnard Semantic Layer
This skill guides the development of a semantic layer by analyzing an existing Metabase instance. It walks the user through connecting to Metabase, generating an intelligence report, and subsequently building structured cubes and views usin…
Semantic Layer Setup and Deployment Guide
This skill guides users through the end-to-end process of building and deploying a semantic layer using the Bonnard CLI. It facilitates connecting data sources, defining structured cubes with measures and dimensions, and creating curated vi…
Semantic Layer Design Guide for AI Agents
This guide outlines best practices for designing semantic data layers, ensuring views are audience-centric and optimized for consumption by both human users and AI agents. It covers principles like starting from user questions, implementing…
Advanced data model creation and diagramming
This skill facilitates complex, multi-entity relational design by generating structured data models and Mermaid class diagrams. It is intended for the initial modeling pass, allowing developers to define schemas before implementing direct S…
Advanced Data Model Creation via Mermaid Diagrams
This skill facilitates advanced, diagram-driven data modeling, generating Mermaid class diagrams for complex, multi-entity relational schemas. It is designed to establish the conceptual structure and relationships before direct SQL implemen…
Managing Elasticsearch Indices for Front Application
This skill guides the creation and maintenance of versioned Elasticsearch indices within the front application layer. It details best practices for managing mappings, utilizing stable aliases, and implementing robust indexing and querying l…
Connect SaaS Data to Wren for SQL Analysis
This skill guides the user through connecting various SaaS APIs using dlt to populate a local DuckDB database. It then automatically introspects this data to generate and validate a complete Wren semantic project, ensuring the resulting SQL…
Migrate Metabase Metrics to Semantic Layer
This skill guides the process of analysing an existing Metabase instance and building a comprehensive semantic layer. It facilitates the extraction of core metrics, dimensions, and relationships to model data within a structured semantic la…
Semantic Layer Setup and Deployment Guide
This skill guides the user through the end-to-end process of building and deploying a semantic layer using the Bonnard CLI. It systematically covers data source connection, cube definition, view design, validation, and final deployment.
Semantic Layer Design Guide for AI Agents
Provides architectural principles for designing audience-centric semantic layers, ensuring that data views and measures are optimized for natural language querying by AI agents. It guides developers on moving beyond schema-mirroring to buil…
Advanced Data Model Creation and Mermaid Modeling
Facilitates complex multi-entity relational design using Mermaid class diagrams to generate structured data models. It allows for inspecting, listing, and creating new models through a diagram-driven workflow.
Wren MDL YAML Project Management
Converts Wren MDL JSON manifests into human-readable YAML project directories for version control and back again. It also enables compiling YAML-based projects into deployable mdl.json files.