Semantic Layer Definition And Management With Business Entity Modeling

An open-source text-to-SQL and generative BI agent with a semantic layer. [#opensource](https://github.com/Canner/WrenAI)

Unique: Implements a declarative semantic layer that serves as a persistent knowledge base for business concepts, enabling consistent interpretation across text-to-SQL, visualization generation, and other downstream capabilities — this is distinct from inline semantic hints or prompt-based approaches because it creates a reusable, version-controlled artifact

vs others: More maintainable and scalable than embedding business logic in prompts or LLM context, because the semantic layer is a single source of truth that can be versioned, validated, and reused across multiple LLM calls and applications

via “schema documentation and metadata enrichment”

Python-based AI SQL agent trained on your schema