Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities. This skill MUST be invoked when the user mentions: "DBSQL", "Databricks SQL", "SQL warehouse", "SQL scripting", "stored procedure", "CALL procedure", "materialized view", "CREATE MATERIALIZED VIEW", "pipe syntax", "|>", "geospatial", "H3", "ST_", "spatial SQL", "collation", "COLLATE", "ai_query", "ai_classify", "ai_extract", "ai_gen", "AI function", "http_request", "remote_query", "read_files", "Lakehouse Federation", "recursive CTE", "WITH RECURSIVE", "multi-statement transaction", "temp table", "temporary view", "pipe operator". SHOULD also invoke when the user asks about SQL best practices, data modeling patterns, or advanced SQL features on Databricks.
72
88%
Does it follow best practices?
Impact
—
No eval scenarios have been run
Advisory
Suggest reviewing before use
Quality
Discovery
89%Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.
This description excels at trigger term coverage and completeness, providing an exhaustive list of when to invoke the skill. Its main weakness is that it reads as a keyword/trigger catalog rather than describing concrete actions the skill performs—it tells Claude *when* to use it very well but is weaker on *what specific tasks* it accomplishes. Adding action verbs describing capabilities (e.g., 'writes stored procedures', 'creates materialized views', 'builds geospatial queries') would strengthen it.
Suggestions
Replace or supplement the opening clause with specific concrete actions, e.g., 'Writes stored procedures, creates materialized views, builds geospatial queries, configures Lakehouse Federation, and uses AI SQL functions on Databricks SQL warehouses.'
Consolidate the trigger term list slightly—the current exhaustive enumeration is effective for matching but could be more readable if grouped by category (e.g., 'AI functions: ai_query, ai_classify, ai_extract, ai_gen').
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | The description names the domain ('Databricks SQL advanced features and SQL warehouse capabilities') and lists many specific features/keywords, but it reads more like a keyword list than a description of concrete actions. It doesn't say what it *does* with these features (e.g., 'creates materialized views', 'writes stored procedures'). | 2 / 3 |
Completeness | The description answers both 'what' (Databricks SQL advanced features and SQL warehouse capabilities) and 'when' with an extensive explicit trigger list using 'MUST be invoked when' and 'SHOULD also invoke when' clauses. The 'when' guidance is exceptionally detailed. | 3 / 3 |
Trigger Term Quality | Excellent coverage of natural trigger terms users would actually say, including abbreviations ('DBSQL'), full names ('Databricks SQL'), specific syntax ('|>', 'ST_', 'WITH RECURSIVE'), function names ('ai_query', 'ai_classify'), and conceptual terms ('geospatial', 'Lakehouse Federation'). Very comprehensive keyword coverage. | 3 / 3 |
Distinctiveness Conflict Risk | Highly distinctive due to the Databricks-specific terminology and the extensive list of unique trigger terms like 'DBSQL', 'SQL warehouse', 'ai_query', 'Lakehouse Federation', and 'pipe syntax'. Unlikely to conflict with generic SQL skills or other platform-specific skills. | 3 / 3 |
Total | 11 / 12 Passed |
Implementation
87%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This is a very strong skill file that serves as an effective index and quick-start guide for Databricks SQL advanced features. Its greatest strengths are the token-efficient quick reference table, fully executable code examples covering all major features, and excellent progressive disclosure to detailed reference files. The main weakness is the lack of explicit validation/verification steps integrated into the workflows, particularly for destructive or complex operations like procedure creation and materialized view management.
Suggestions
Add validation checkpoints to key workflows, e.g., after CREATE PROCEDURE show a verification step like 'DESCRIBE PROCEDURE catalog.schema.upsert_customers' or a test CALL with expected output
Include a brief troubleshooting pattern or error-recovery flow for common failure modes (e.g., AI function timeouts, materialized view refresh failures) to improve workflow clarity
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The content is highly efficient — no unnecessary explanations of what SQL is, what Databricks does, or how basic concepts work. Every section jumps straight to syntax and executable examples. The quick reference table is an excellent token-efficient way to provide an overview. | 3 / 3 |
Actionability | Every feature is demonstrated with complete, executable SQL examples including realistic table references (catalog.schema.table), proper syntax, and invocation patterns. Examples cover error handling, parameterized procedures, and real-world use cases like upserts and hierarchy traversal. | 3 / 3 |
Workflow Clarity | While individual examples are clear and well-sequenced, there are no explicit validation checkpoints or feedback loops. For operations like stored procedures with error handling or materialized view creation, there's no 'verify the result' step. The guidelines mention using MCP tools to test SQL but this is a brief bullet point rather than an integrated workflow step. | 2 / 3 |
Progressive Disclosure | Excellent structure: a quick reference table maps features to reference files, common patterns provide just enough inline examples to be useful, and a clear 'Reference Files' table tells exactly when to load each detailed file. References are one level deep and well-signaled with descriptive 'When to Read' guidance. | 3 / 3 |
Total | 11 / 12 Passed |
Validation
100%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 11 / 11 Passed
Validation for skill structure
No warnings or errors.
93cb4e3
Table of Contents
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.