CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

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.

Quality

82%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

80%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A well-structured, highly actionable reference skill with excellent progressive disclosure (verified one-level-deep references with explicit 'When to Read' routing) and executable examples throughout. Its weaknesses are moderate: version-specific details live inline rather than in a compatibility section, and validation guidance is a single closing bullet instead of checkpoints in the destructive/batch SQL workflows.

Suggestions

Add inline validation checkpoints to the mutating patterns (e.g. after the upsert procedure and before the scheduled materialized view), such as 'query the row count or a sample before and after MERGE, and roll back / skip refresh if counts look wrong', turning the final test note into a per-pattern loop.

Move the DBR version matrix ('Since' column) into a dedicated compatibility section (or into the version table in references/sql-scripting.md) so time-sensitive version numbers don't sit inline in the main file.

Merge the Quick Reference and Reference Files tables (add a 'When to Read' column to the single feature table) to remove the duplicated reference routing.

DimensionReasoningScore

Conciseness

The body is lean: 16 compact, comment-light code examples, a quick-reference table, and terse directive bullets with no explanation of concepts Claude already knows. Minor trimmable material keeps it below 5: the 'Since' column embeds time-sensitive version numbers ('DBR 16.3+', 'GA') outside any deprecated/old-patterns section, and the 'Reference Files' table duplicates the reference column of the Quick Reference table. It is noticeably above the anchor-3 midpoint (no unnecessary explanations, just minor redundancy), so 4.

4 / 5

Actionability

Every pattern is a complete, copy-paste-ready SQL block covering the common case: a full procedure with EXIT HANDLER and CALL invocation, a scheduled materialized view, pipe-syntax rewrite, ai_query with returnType, an H3 join with ST_Distance filter, a CREATE CONNECTION plus http_request, read_files with schemaHints, and a concrete CLI test command ('databricks experimental aitools tools query') with an env-var fallback. This matches anchor 5; anchor 4 would imply minor gaps in the examples themselves, which are absent.

5 / 5

Workflow Clarity

The body is a pattern catalog rather than a sequenced procedure, and the multi-step flows it does contain (e.g. create connection then call http_request, or MERGE-based upserts that mutate data) have no inline validation checkpoints — the only verification guidance is one final bullet ('Test SQL via CLI ... before deploying'), with no fix-and-retry loop. Per the rubric's cap for database operations without feedback loops, workflow clarity cannot exceed 3; a score of 4 would require checkpoints embedded at each risky step.

3 / 5

Progressive Disclosure

The body is a clear overview: a feature-to-reference routing table, one worked example per feature kept inline, and a 'Reference Files' table with an explicit 'When to Read' column. All five referenced files exist and contain only internal anchor links, so references are exactly one level deep with no nesting — matching anchor 5's clear overview with well-signaled one-level-deep references.

5 / 5

Total

17

/

20

Passed

Description

77%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description with excellent, explicit trigger coverage and clear third-person framing. Its main weakness is the 'what' statement, which names the domain generically ('advanced features and capabilities') rather than enumerating concrete actions.

Suggestions

Replace 'Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities' with named concrete actions, e.g. 'Write SQL scripts and stored procedures, create materialized views, run geospatial and AI-function queries, and ingest files via read_files in Databricks SQL.'

Tighten the broad 'SHOULD also invoke' clause ('SQL best practices, data modeling patterns, or advanced SQL features on Databricks') by scoping each phrase explicitly to Databricks to reduce overlap with generic SQL skills.

Consider trimming near-duplicate trigger pairs (e.g. 'pipe syntax' / 'pipe operator', 'temp table' / 'temporary view') in favor of a few missing natural phrases users say, such as 'schedule refresh' or 'federated query'.

DimensionReasoningScore

Specificity

The 'what' is a generic domain statement ('Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities') with no concrete action verbs, but the enumerated trigger terms ('stored procedure', 'materialized view', 'recursive CTE', 'collation', 'http_request') do convey concrete capabilities. It matches anchor 3 (domain plus some concrete items but not framed as specific actions); anchor 4 requires several specific action statements ('Extracts...', 'Fills...') which are absent, while anchor 2 would require the trigger list to be generic jargon, which it is not.

3 / 5

Completeness

Both parts are explicitly present: a 'what' ('Databricks SQL advanced features and SQL warehouse capabilities') and an unusually explicit 'when' ('This skill MUST be invoked when the user mentions: ... SHOULD also invoke when...'). The 'when' exceeds anchor 4's bar, but the 'what' is vague ('advanced features and capabilities' rather than named actions like the anchor-5 example's 'Extract text and tables from PDF files, fill forms, merge documents'), keeping it below 5.

4 / 5

Trigger Term Quality

Comprehensive natural-term coverage including synonyms and exact syntax users would type: 'DBSQL' and 'Databricks SQL', 'recursive CTE' and 'WITH RECURSIVE', 'temp table' and 'temporary view', 'pipe syntax', '|>' and 'pipe operator', plus specific function names ('ai_query', 'http_request', 'read_files'). This matches the anchor-5 example's coverage breadth (synonyms, exact operators, function identifiers); anchor 4 would leave noticeable natural terms missing, which is not the case.

5 / 5

Distinctiveness Conflict Risk

Mostly distinct: the majority of triggers are Databricks-specific tokens ('DBSQL', 'ai_query', 'h3'/'H3', 'remote_query') with minimal conflict risk. A few broad terms ('AI function', 'temp table', 'SQL best practices, data modeling patterns') could overlap with generic SQL or sibling Databricks skills (note 'parent: databricks-core'), which is the minor overlap of anchor 4 rather than the clear niche of anchor 5.

4 / 5

Total

16

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

15

/

16

Passed

Repository

databricks/databricks-agent-skills

Path

plugins/databricks/claude/skills/databricks-dbsql/SKILL.md

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.