bsl-query-expert
Query BSL semantic models with group_by, aggregate, filter, and visualizations. Use for data analysis from existing semantic tables.
Security Assessment
About bsl-query-expert
The bsl-query-expert skill allows users to query semantic models using the Boring Semantic Layer (BSL) for advanced data analysis. It solves the challenge of analyzing and visualizing data from existing semantic tables without needing deep technical expertise in querying. By leveraging built-in functions for grouping, aggregating, filtering, and visualizing data, this skill simplifies the process of interacting with complex data models while ensuring accuracy and efficiency in the results. It is particularly useful for users seeking a streamlined way to explore and analyze data from BSL semantic models, focusing on quick, automated insights with minimal setup.
Key features include the ability to easily list available models, retrieve schemas, and execute queries that automatically display results. It supports flexible querying with functions such as `group_by`, `aggregate`, and `filter`, enabling users to refine their data exploration process. Additionally, it offers automatic chart generation based on query results and provides a smooth user experience by maintaining context throughout the session, reducing the need to repeat tool calls. The skill also allows users to explore data values first (without charts) before finalizing their queries with visualizations.
This skill is ideal for data analysts, business intelligence professionals, or anyone working with BSL semantic tables who requires an efficient way to query and analyze data. It's particularly helpful for discovering patterns, summarizing data, and presenting insights visually through charts, which make the results easier to interpret and share.
FAQ
How do I query data using the bsl-query-expert skill?
To query data, first use `list_models()` to discover available models, then retrieve the schema with `get_model(name)`. Before querying, use `get_documentation('query-methods')` to learn the correct syntax. Finally, execute queries using `query_model(query)`.
Can I use the bsl-query-expert skill with any semantic table?
Yes, the skill works with any semantic model that is part of the Boring Semantic Layer (BSL). However, you must retrieve the schema for the model first using `get_model(name)` before performing queries.
What should I do if my query fails?
If your query fails, make sure to call `get_documentation('query-methods')` to learn the correct syntax before retrying the query. This ensures that the query is formulated properly.
Are charts automatically generated after every query?
Charts are automatically generated after queries that include aggregation and grouping (e.g., `group_by` and `aggregate`), but can be disabled with the `get_chart=false` parameter for discovery or exploration queries.
What are the requirements for using the bsl-query-expert skill?
To use this skill, you must have access to a BSL semantic model and be familiar with basic querying syntax. Additionally, you need to call `get_documentation('query-methods')` before your first query to understand the correct syntax.
Install bsl-query-expert
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
boringdata/boring-semantic-layer