optimizing-databricks-sql SKILL.md skillA

optimizing-databricks-sql from altimateai/data-engineering-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add altimateai/data-engineering-skills/optimizing-databricks-sql@git:20260925.705c68b

Pins git:20260925.705c68b in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
altimateai/data-engineering-skills
Path
skills/databricks/optimizing-databricks-sql/SKILL.md
Versions recorded
1
Latest version
git:20260925.705c68b, committed Sep 25, 2026
Size
26,846 bytes
Repository stars
129
License
MIT

Analyze DBSQL queries, including SQL embedded in notebooks (`spark.sql(...)`, `%sql` cells), for anti-patterns, lint issues, and performance problems, using Databricks-specific dialect and platform knowledge (Delta, Photon, Unity Catalog) layered on top of altimate-code's generic SQL engine. Use when a user asks to optimize, review, or lint DBSQL queries on Databricks, whether standalone or embedded in a notebook.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Databricks Optimize (DBSQL)

A Databricks/Delta-platform **overlay**, not a standalone optimizer. The
generic rewrite/analyze/verify pipeline (Steps 1, 5, 6) is the same
pipeline altimate-code's native `query-optimize` skill runs — same tool
calls, same composition. This skill's only job is the part `query-optimize`
structurally can't do: detecting Databricks/Delta platform-specific issues
(Z-ordering, table statistics, Photon UDF blocking) that need table
metadata and Databricks docs knowledge, not just query text, and folding
those findings in alongside the generic ones.

If `query-optimize` is installed in the current environment, prefer
invoking it for Steps 1/5/6 and layer Steps 2–4's Databricks-specific
findings on top of its output, the same way `sql-review` defers to
sibling skills instead of duplicating them. If it isn't available (e.g.
this skill is running standalone, outside altimate-code), fall back to
calling the same tools directly as described below — the tool calls are
identical either way, so behavior doesn't change based on which path ran.

No rewrite is reported as "optimized" until it clears the validation gate
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add altimateai/data-engineering-skills/optimizing-databricks-sql@sha256:ddf5474c0a2501ae

The line at the top of this page pins the label git:20260925.705c68b, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_4ivgvuvcfbwjsa5y.svg)](https://markdownregistry.com/a/art_4ivgvuvcfbwjsa5y)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Sep 25, 2026.

versioncommittedcommitsizeaudit
git:20260925.705c68b latest2026-09-25 705c68b 26,846 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (26846 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

altimateai/data-engineering-skills · 129 stars · license MIT · pushed 2026-10-23 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_4ivgvuvcfbwjsa5y
GET https://markdownregistry.com/api/v1/resolve?ref=altimateai/data-engineering-skills/optimizing-databricks-sql
GET https://markdownregistry.com/api/v1/blob/ddf5474c0a2501aefe704e2e9ae579d477c7442e66c7e8ff7a8ecff63bf765fa

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from altimateai/data-engineering-skills

altimate-code SKILL.md skill
altimateai/data-engineering-skills · skills/altimate-code/SKILL.md · Delegates dbt and warehouse work to altimate-code, a specialized CLI agent with 100+ purpose-built data tools. USE THIS…
git:20260615.a13847e · audit A · 129 stars
creating-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/creating-dbt-models/SKILL.md · Creates dbt models following project conventions. Use when working with dbt models for: (1) Creating new models (any…
git:20260121.476f750 · audit A · 129 stars
debugging-dbt-errors SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/debugging-dbt-errors/SKILL.md · Debugs and fixes dbt errors systematically. Use when working with dbt errors for: (1) Task mentions "fix", "error"…
git:20260121.476f750 · audit A · 129 stars
developing-incremental-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/developing-incremental-models/SKILL.md · Develops and troubleshoots dbt incremental models. Use when working with incremental materialization for: (1) Creating…
git:20260206.c45120a · audit A · 129 stars
documenting-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/documenting-dbt-models/SKILL.md · Documents dbt models and columns in schema.yml. Use when working with dbt documentation for: (1) Adding model…
git:20260121.476f750 · audit A · 129 stars
migrating-sql-to-dbt SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/migrating-sql-to-dbt/SKILL.md · Converts legacy SQL to modular dbt models. Use when migrating SQL to dbt for: (1) Converting stored procedures, views…
git:20260121.476f750 · audit A · 129 stars
refactoring-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/refactoring-dbt-models/SKILL.md · Safely refactors dbt models with downstream impact analysis. Use when restructuring dbt models for: (1) Task mentions…
git:20260121.476f750 · audit A · 129 stars
testing-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/testing-dbt-models/SKILL.md · Adds schema tests and data quality validation to dbt models. Use when working with dbt tests for: (1) Adding or…
git:20260121.476f750 · audit A · 129 stars
finding-expensive-queries SKILL.md skill
altimateai/data-engineering-skills · skills/snowflake/finding-expensive-queries/SKILL.md · Finds and ranks expensive Snowflake queries by cost, time, or data scanned. Use when: (1) User asks to find slow…
git:20260121.476f750 · audit A · 129 stars
optimizing-query-by-id SKILL.md skill
altimateai/data-engineering-skills · skills/snowflake/optimizing-query-by-id/SKILL.md · Optimizes Snowflake query performance using query ID from history. Use when optimizing Snowflake queries for: (1) User…
git:20260121.476f750 · audit A · 129 stars
optimizing-query-text SKILL.md skill
altimateai/data-engineering-skills · skills/snowflake/optimizing-query-text/SKILL.md · Optimizes Snowflake SQL query performance from provided query text. Use when optimizing Snowflake SQL for: (1) User…
git:20260121.5b69ef4 · audit A · 129 stars
snowflake-dbt-model-refactoring SKILL.md skill
altimateai/data-engineering-skills · skills/snowflake/snowflake-dbt-model-refactoring/SKILL.md · Refactor a bloated dbt model on Snowflake safely and produce a quantified before/after report that explains **which…
git:20261015.01c534a · audit A · 129 stars

Every file in altimateai/data-engineering-skills

Browse by kind, by grade A, or by owner.