aidp-ai-sql

aidp-ai-sql is a skill for Claude Code, Codex from oracle-samples/oracle-aidp-samples. It costs 77 tokens per session (1,074 once invoked), scanned A, original, UPL-1.0.

A way to call language models from Spark SQL through the aigenerate() function. Spark SQL is a system for querying and processing large datasets across a cluster.

In plain words
What is it for?
Use it to summarize, classify, extract information from, or enrich rows, generate text from grouped results, and perform grounded retrieval-based analysis in a data lakehouse.
Why use it?
It lets you apply language-model work to table rows within SQL instead of moving the data into a separate application.

Skill for Claude CodeCodex

Part of the oracle-ai-data-platform-workbench-engineer-agent plugin — 37 skills, 1 hook shipped together

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/oracle-samples/oracle-aidp-samples/aidp-ai-sql
Any agent
npx skills add oracle-samples/oracle-aidp-samples --skill aidp-ai-sql
Clone the repo
git clone --depth 1 https://github.com/oracle-samples/oracle-aidp-samples

Made for: Claude Code, Codex.

Or install oracle-ai-data-platform-workbench-engineer-agent, the plugin that ships this one along with the rest of its 37 skills, 1 hook.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for aidp-ai-sql

README.md
[![agentmods](https://agentmods.dev/badge/skills/oracle-samples/oracle-aidp-samples/aidp-ai-sql.svg)](https://agentmods.dev/skills/oracle-samples/oracle-aidp-samples/aidp-ai-sql)
Your own site
<a href="https://agentmods.dev/skills/oracle-samples/oracle-aidp-samples/aidp-ai-sql"><img src="https://agentmods.dev/badge/skills/oracle-samples/oracle-aidp-samples/aidp-ai-sql.svg" alt="Measured on agentmods" height="20"></a>
Per session 77 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,074 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin unknown No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00077 $0.01074
Opus 5 $0.00039 $0.00537
Sonnet 5 $0.00015 $0.00215
Haiku 4.5 $0.00008 $0.00107

Measured 5d ago against content hash 8f66742e426c, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-05, from the pricing page.

Security

Grade A, and why

aidp-ai-sql scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 5d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

ai/claude-code-plugins/oracle-ai-data-platform-workbench-engineer-agent/skills/aidp-ai-sql/SKILL.md · 76 lines

The source is not reproduced here

Licensed UPL-1.0

The repository is licensed UPL-1.0, which this catalogue does not treat as permission to reproduce the file. Read it at the source.

Read it on GitHub

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 5d ago First seen · 76 lines · 77 tokens per session scan A 8f66742e426c

Subscribe to this mod's changes

aidp-ai-sql is a skill published in the GitHub repository oracle-samples/oracle-aidp-samples (46 stars, last pushed 4d ago), licensed UPL-1.0. It adds 77 tokens to every session and 1,074 once invoked, about $0.0004 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

add-ollama-tool

Add Ollama MCP server so the container agent can call local models and optionally manage the Ollama model library.

nanocoai/nanoclaw · 28 tokens

zarr-python

Chunked N-D arrays for cloud storage. Compressed arrays, parallel I/O, S3/GCS integration, NumPy/Dask/Xarray compatible, for large-scale scientific computing pipelines.

synthetic-sciences/openscience · 42 tokens

aeon

This skill should be used for time series machine learning tasks including classification, regression, clustering, forecasting, anomaly detection, segmentation, and similarity search. Use when working with temporal data, sequential patterns, or time-indexed observations requiring specialized algorithms beyond standard…

synthetic-sciences/openscience · 74 tokens

hdf5-pde-data-loading

Patterns for loading PDE simulation datasets (PDEBench, PhiFlow, JAX-CFD) from HDF5 files. Handles layout detection (single tensor vs separate variables), spatial/temporal downsampling, multi-variable systems, HuggingFace and DaRUS data sources, and efficient PyTorch DataLoader creation. Use when preparing PDE data…

synthetic-sciences/openscience · 82 tokens

llama-cpp

Run LLM inference with llama.cpp on CPU, Apple Silicon, AMD/Intel GPUs, or NVIDIA — plus GGUF model conversion and quantization (2–8 bit with K-quants and imatrix). Covers CLI, Python bindings, OpenAI-compatible server, and Ollama/LM Studio integration. Use for edge deployment, M1/M2/M3/M4 Macs, CUDA-less…

moltis-org/moltis · 91 tokens

openai-whisper-api

Transcribe audio via OpenAI Audio Transcriptions API (Whisper).

moltis-org/moltis · 20 tokens