CtrlK
BlogDocsLog inGet started
Tessl Logo

databricks-dbsql

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

Quality

88%

Does it follow best practices?

Impact

No eval scenarios have been run

SecuritybySnyk

Advisory

Suggest reviewing before use

SKILL.md
Quality
Evals
Security

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').

DimensionReasoningScore

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

DimensionReasoningScore

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.

Validation11 / 11 Passed

Validation for skill structure

No warnings or errors.

Repository
databricks-solutions/ai-dev-kit
Reviewed

Table of Contents

Is this your skill?

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.