aidp-postgresql

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

A notebook connector for reading from or writing to PostgreSQL. PostgreSQL is an open-source relational database that stores data in tables and supports SQL queries.

In plain words
What is it for?
Use it to load PostgreSQL tables into Spark or write processed Spark data back to PostgreSQL.
Why use it?
It provides the connection setup needed to exchange data between PostgreSQL and Spark.

Skill for Claude CodeCodex

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-postgresql
Any agent
npx skills add oracle-samples/oracle-aidp-samples --skill aidp-postgresql
Clone the repo
git clone --depth 1 https://github.com/oracle-samples/oracle-aidp-samples

Made for: Claude Code, Codex.

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-postgresql

README.md
[![agentmods](https://agentmods.dev/badge/skills/oracle-samples/oracle-aidp-samples/aidp-postgresql.svg)](https://agentmods.dev/skills/oracle-samples/oracle-aidp-samples/aidp-postgresql)
Your own site
<a href="https://agentmods.dev/skills/oracle-samples/oracle-aidp-samples/aidp-postgresql"><img src="https://agentmods.dev/badge/skills/oracle-samples/oracle-aidp-samples/aidp-postgresql.svg" alt="Measured on agentmods" height="20"></a>
Per session 90 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,568 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 1 finding. 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 $0.00090 $0.01568
Opus 5 $0.00045 $0.00784
Sonnet 5 $0.00018 $0.00314
Haiku 4.5 $0.00009 $0.00157

Measured yesterday against content hash 9e042d248d84, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

aidp-postgresql scanned grade A with 1 finding 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 yesterday.

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.

Makes network callslowCapability

Not a fault in itself. Listed so you know the mod talks to something, and to what.

import os, urllib.request
ai/claude-code-plugins/oracle-ai-data-platform-workbench-spark-connectors/skills/aidp-postgresql/SKILL.md · 132 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. yesterday First seen · 132 lines · 90 tokens per session scan A 9e042d248d84

Subscribe to this mod's changes

aidp-postgresql is a skill published in the GitHub repository oracle-samples/oracle-aidp-samples (46 stars, last pushed 3d ago), licensed UPL-1.0. It adds 90 tokens to every session and 1,568 once invoked, about $0.0005 per session on Opus 5. A static security scan graded it A with 1 finding (makes network calls). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.

Related

Other skills, from other repositories

database-schema-changes

Guide for making database schema changes in Platypus using Drizzle ORM — editing the schema, pushing to a dev database, and generating the migration that ships.

willdady/platypus · 37 tokens

postgres

Query and manage PostgreSQL databases -- run SQL, inspect schemas, manage tables, and perform database administration.

clawdata/clawdata · 23 tokens

safe-sql-execution

Use whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix and never says "security," "injection," or "SafeSqlFragment." This covers: writing or editing any pg-meta function, query builder, or endpoint…

supabase/supabase · 221 tokens

ha-logs

Self-service diagnostics — query Hope Agent's local SQLite databases (logs / sessions / background jobs) directly via the exec tool to investigate problems, analyze usage, and locate root causes. Trigger on: user reports something broken / failing / slow / stuck / not responding ('X 不工作', 'X 报错', 'X 卡住', '为什么 X 失败'…

shiwenwen/hope-agent · 183 tokens

dbt-pr-review

Cloudflare-style AI code review for dbt/SQL pull requests. Produces a signed APPROVE/COMMENT/REQUESTCHANGES verdict where every blocking finding is backed by a deterministic engine call — column-lineage blast radius, query equivalence, PII classification, and A–F grade. Use to review a dbt PR or the working-tree…

AltimateAI/altimate-code · 79 tokens

lineage-diff

Compare column-level lineage between two versions of a SQL query to show added, removed, and changed data flow edges.

AltimateAI/altimate-code · 28 tokens