How it improves accuracy
The AI Guide is the database-understanding layer used by Speak To Your Database. The better that understanding of your schema and its business meaning, the more accurate the queries and answers tend to be.
Where it helps
Better table and column selection
Speak To Your Database is more likely to use the right tables and columns for a question.
Speak To Your Database is more likely to use the right tables and columns for a question.
Better business-language interpretation
Plain-language descriptions and your business terms help Speak To Your Database map your words to the data.
Plain-language descriptions and your business terms help Speak To Your Database map your words to the data.
Fewer wrong joins or metrics
Descriptions that say which rows count or the unit of an amount reduce mismatched joins and miscounted metrics.
Descriptions that say which rows count or the unit of an amount reduce mismatched joins and miscounted metrics.
Clearer assumptions
Good descriptions make the logic behind an answer easier to follow.
Good descriptions make the logic behind an answer easier to follow.
It helps, but does not guarantee
Metadata improves the odds of a correct answer, it does not make Speak To Your Database perfect. Always validate important results, and keep questions clear.
Business definitions, the AI Guide, and Brief your assistant
These pieces work together but have different scopes:
AI Guide
Where you review the table and column descriptions STYD detected for a single database (Settings → AI Guide).
Where you review the table and column descriptions STYD detected for a single database (Settings → AI Guide).
Brief your assistant
Your own words for the same database (this page was called the Learning Center before): for a SQL database, your business terms (a word your team uses and what it means); for Odoo, your definitions and your words.
Your own words for the same database (this page was called the Learning Center before): for a SQL database, your business terms (a word your team uses and what it means); for Odoo, your definitions and your words.
Together they give Speak To Your Database a strong starting understanding of each database (the AI Guide) and the words your team uses (Brief your assistant).