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.

67

Quality

84%

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

86%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-engineered overview: an index-style quick reference, executable pattern examples for every feature area, a purpose-labeled reference table, and actionable guidelines. The only notable cost is that the body leans toward a pattern cookbook where some full examples could be trimmed in favor of the already excellent reference files.

DimensionReasoningScore

Conciseness

The body is tables, tight code examples, and guideline bullets — no explanations of concepts Claude already knows. It falls just short of the 5-anchor because eleven full inline code examples partially duplicate content in the reference files (e.g., the complete error-handling stored procedure is detail that sql-scripting.md covers), giving minor trim potential consistent with the 4-anchor.

4 / 5

Actionability

Every example is complete, executable SQL with correctly qualified catalog.schema names, real signatures (h3_longlatash3(longitude, latitude, 7), returnType => ..., schemaHints => ..., CREATE CONNECTION with bearer_token secret), and inline comments. Copy-paste-ready examples cover the common case for each of the eleven feature areas, matching the 5-anchor.

5 / 5

Workflow Clarity

The navigation flow (Quick Reference table → example pattern → 'When to Read' column per reference file) is clear, and the final guidelines include a verification step ('Test SQL via CLI ... before deploying', with a DATABRICKS_WAREHOUSE_ID fallback). As a feature-catalog skill it has no multi-step sequence with explicit checkpoints, which fits the 4-anchor's 'clear sequence with most checkpoints; minor validation gaps' better than the 5-anchor.

4 / 5

Progressive Disclosure

The Quick Reference table maps every feature to its reference file, the Reference Files table adds a 'When to Read' column, and all five referenced files exist and are substantive (432–1361 lines). References are exactly one level deep — they link only to internal anchors, with no nested reference chains — matching the 5-anchor's clear overview with well-signaled one-level-deep references.

5 / 5

Total

18

/

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 an exceptionally thorough, synonym-rich trigger list and explicit when-to-invoke guidance in third person. The main weakness is the generic capability statement — 'advanced features and SQL warehouse capabilities' tells the reader little about what the skill actually does beyond the trigger enumeration.

Suggestions

Replace the generic capability phrase with concrete actions, e.g. 'Write SQL scripts, stored procedures, and recursive CTEs; create materialized views; use pipe syntax, geospatial functions, collations, and AI functions on Databricks SQL warehouses.'

Qualify generic trigger terms like 'temp table', 'recursive CTE', and 'geospatial' with Databricks context to reduce overlap with general SQL/PostGIS skills.

DimensionReasoningScore

Specificity

The capability statement 'Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities' names the domain, and the trigger list enumerates many concrete features, but the what is stated as generic nouns with no concrete action verbs, unlike the 5-anchor's 'Extract text and tables... fill forms'. It exceeds the 2-anchor ('names the domain but actions are minimal') thanks to the feature enumeration, but does not list specific actions.

3 / 5

Completeness

Both what and when are explicitly present: 'MUST be invoked when the user mentions: ...' and 'SHOULD also invoke when...' make the when maximally explicit with concrete trigger phrases. Held at 4 rather than 5 because the what ('advanced features and SQL warehouse capabilities') is generic, where the 5-anchor pairs concrete actions with its trigger clause.

4 / 5

Trigger Term Quality

Comprehensive natural-term coverage with synonyms and both syntax and colloquial variants: 'DBSQL', 'Databricks SQL', 'SQL warehouse', 'stored procedure', 'CALL procedure', 'materialized view', 'CREATE MATERIALIZED VIEW', 'pipe syntax', '|>', 'geospatial', 'H3', 'ST_', 'spatial SQL', 'COLLATE', 'ai_query', 'http_request', 'read_files', 'Lakehouse Federation', 'recursive CTE', 'WITH RECURSIVE', 'temp table', 'temporary view', 'pipe operator'. This matches the 5-anchor's coverage of natural terms including synonyms.

5 / 5

Distinctiveness Conflict Risk

Databricks-specific triggers (DBSQL, H3, ai_query, Lakehouse Federation) give it a clear niche with minimal conflict risk, but broadly generic terms like 'temp table', 'temporary view', 'recursive CTE', 'geospatial', and 'ST_' could overlap with general SQL or PostGIS questions and a sibling databricks-core skill — minor overlap risk consistent with the 4-anchor.

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.