← Back to Skills Marketplace
Kansodata Databricks
by
Marcos CF.
· GitHub ↗
· v0.1.1
· MIT-0
177
Downloads
1
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install kansodata-databricks
Description
Execute conservative read-only Databricks SQL through the Databricks plugin and provide safe planning output for unsupported workflows.
README (SKILL.md)
Use this skill when a user asks for Databricks SQL analysis or execution.
Runtime Scope
Available runtime tool:
databricks_sql_readonly
Supported statement shapes:
- Single
SELECT - Single
WITH ... SELECT
Policy constraints:
- Read-only only
- Multi-statement SQL blocked
- Mutating keywords blocked
- Optional catalog/schema allowlists enforced fail-closed
- Ambiguous SQL target resolution rejected when allowlists are active
Unsupported in This Version
- Jobs API execution
- Unity Catalog lineage API calls
- Mutating SQL operations
For unsupported requests, provide planning output only.
Required Inputs
- Databricks workspace URL and environment (
dev,staging,prod) - SQL warehouse identifier
- Catalog and schema scope
- Target table set
Output Defaults
- Objective
- Assumptions
- Read-only SQL draft
- Validation checklist
- Risk notes and rollback signals
Usage Guidance
This skill appears coherent and low-risk as an instruction-only, read-only Databricks helper. Before installing: confirm your agent runtime actually provides the referenced databricks_sql_readonly tool and that it will supply authentication (the skill itself doesn't ask for credentials); ensure the platform's Databricks connector is configured with least-privilege, read-only access and auditing enabled; and test the skill in a non-production environment to verify the stated multi-statement/mutation protections and any catalog/schema allowlists behave as documented.
Capability Analysis
Type: OpenClaw Skill
Name: kansodata-databricks
Version: 0.1.1
The skill bundle defines a read-only Databricks SQL execution interface with explicit safety constraints, including the blocking of mutating keywords and multi-statement SQL. The instructions in SKILL.md emphasize conservative execution and fail-closed policies for catalog/schema allowlists, showing no signs of malicious intent, data exfiltration, or prompt injection.
Capability Assessment
Purpose & Capability
Name/description (read-only Databricks SQL and planning) match the SKILL.md: it enumerates supported statement shapes, read-only policy, and required inputs (workspace URL, warehouse id, catalog/schema, target tables). Nothing requested (binaries, env vars, or installs) appears extraneous to a read-only SQL helper.
Instruction Scope
SKILL.md limits runtime actions to a specific runtime tool (databricks_sql_readonly), enforces read-only and single-statement constraints, and instructs planning output for unsupported requests. It does not instruct reading unrelated files, environment variables, or transmitting data to external endpoints.
Install Mechanism
No install spec and no code files — this is instruction-only, which minimizes on-disk risk. The skill assumes a runtime tool (databricks_sql_readonly) is available from the platform rather than installing anything itself.
Credentials
The skill declares the logical inputs it needs (workspace URL, environment, SQL warehouse id, catalog/schema, target tables) and requests no environment variables or credentials. This is proportionate for a description-level skill, but in practice executing Databricks SQL requires authentication; the skill relies on the platform's connector/tool to provide credentials. Verify that the platform plugin supplies least-privilege credentials rather than the skill asking for broad secrets.
Persistence & Privilege
always:false and default autonomous invocation are appropriate. The skill does not request persistent system modifications or global config changes.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install kansodata-databricks - After installation, invoke the skill by name or use
/kansodata-databricks - Provide required inputs per the skill's parameter spec and get structured output
Version History
v0.1.1
Initial ClawHub skill release for the Kansodata Databricks integration.
Includes a conservative read-only Databricks skill designed to work with the databricks_sql_readonly runtime tool. Supports single SELECT and WITH ... SELECT workflows, defines required inputs, output defaults, and documents safety constraints and unsupported operations.
Metadata
Frequently Asked Questions
What is Kansodata Databricks?
Execute conservative read-only Databricks SQL through the Databricks plugin and provide safe planning output for unsupported workflows. It is an AI Agent Skill for Claude Code / OpenClaw, with 177 downloads so far.
How do I install Kansodata Databricks?
Run "/install kansodata-databricks" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Kansodata Databricks free?
Yes, Kansodata Databricks is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Kansodata Databricks support?
Kansodata Databricks is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Kansodata Databricks?
It is built and maintained by Marcos CF. (@kansodata); the current version is v0.1.1.
More Skills