Skip to main content
Glama

pbi_validate_star_schema

Validates a Power BI semantic model's star schema by detecting fact, dimension, bridge tables, snowflake violations, and fact-to-fact constellations. Supports optional fact table hints for incremental models.

Instructions

Confirm a model follows star schema topology.

Heuristic: a fact table participates as the many-side in ≥1 relationship, a dimension table participates as the one-side. Tables that are both are flagged as bridge tables. Direct dimension-to-dimension relationships are flagged as snowflake violations. Fact tables wired to other facts are flagged as fact-to-fact (constellation).

Optional fact_table_hints lets callers force-tag tables as facts (matched case-insensitively); useful when a fact table has no incoming relationships yet because the model is being built incrementally.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
include_hiddenNo
fact_table_hintsNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations provided, so description carries full burden. It explains the internal logic (heuristic for fact/dimension/bridge tables) and the optional fact_table_hints parameter. However, it does not explicitly state side effects (likely read-only) or the output format. The description provides good behavioral context beyond the schema.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Description is concise with two well-structured paragraphs. First paragraph states purpose and heuristic; second covers the optional parameter. Front-loaded with key information. No unnecessary words.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the output schema exists, description need not detail return values. However, it does not mention prerequisites (e.g., connected model), the output type, or how the heuristic applies to real-world scenarios. Adequate but not fully complete for a validation tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 0%, but the description adds meaning for one parameter (fact_table_hints), explaining its use for force-tagging tables. The other parameter (include_hidden) is not described. Partial compensation for low schema coverage, but incomplete.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Description clearly states purpose: 'Confirm a model follows star schema topology.' It defines specific heuristic for fact/dimension/bridge tables and flags violations like snowflake and constellation. Distinguished from sibling validation tools like pbi_validate_model and pbi_validate_dax.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Description implies usage for validating star schema structure but does not explicitly state when to use or exclude alternatives. No mention of prerequisites or comparison to other validation tools. Could be improved by specifying context where this tool is preferred.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/imnotStealthy/powerbi-mcp-local'

If you have feedback or need assistance with the MCP directory API, please join our Discord server