odbc

odbc is a skill for Claude Code, Codex from LeoLin990405/r-analytics-skill. It costs 23 tokens per session (340 once invoked), scanned A, original, MIT.

An R package that connects programs to databases through ODBC, a standard interface supported by many database drivers. It can connect using a saved data source or explicit connection details.

In plain words
What is it for?
Connecting to databases such as SQL Server, MySQL, and MariaDB; running SQL queries and updates; writing tables; listing available drivers and data sources; and closing connections.
Why use it?
It gives R a common way to read and change data in different ODBC-compatible databases without using a separate connection method for each one.

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/leolin990405/r-analytics-skill/odbc
Any agent
npx skills add LeoLin990405/r-analytics-skill --skill odbc
Clone the repo
git clone --depth 1 https://github.com/LeoLin990405/r-analytics-skill

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 odbc

README.md
[![agentmods](https://agentmods.dev/badge/skills/leolin990405/r-analytics-skill/odbc.svg)](https://agentmods.dev/skills/leolin990405/r-analytics-skill/odbc)
Your own site
<a href="https://agentmods.dev/skills/leolin990405/r-analytics-skill/odbc"><img src="https://agentmods.dev/badge/skills/leolin990405/r-analytics-skill/odbc.svg" alt="Measured on agentmods" height="20"></a>
Per session 23 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 340 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original 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.00023 $0.00340
Opus 5 $0.00012 $0.00170
Sonnet 5 $0.00005 $0.00068
Haiku 4.5 $0.00002 $0.00034

Measured 5d ago against content hash 1a401f767cf5, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

odbc 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.

sub-skills/r-data/r-data-database/odbc/SKILL.md · 78 lines

What it actually says

odbc Package

ODBC database connections.

Connect

library(DBI)
library(odbc)

# DSN connection
con <- dbConnect(odbc(), dsn = "MyDSN")

# Connection string
con <- dbConnect(odbc(),
  Driver = "SQL Server",
  Server = "server.example.com",
  Database = "mydb",
  UID = "user",
  PWD = "password"
)

# List available drivers
odbcListDrivers()

# List DSNs
odbcListDataSources()

SQL Server

con <- dbConnect(odbc(),
  Driver = "ODBC Driver 17 for SQL Server",
  Server = "server.example.com",
  Database = "mydb",
  UID = "user",
  PWD = "password",
  Port = 1433
)

MySQL/MariaDB

con <- dbConnect(odbc(),
  Driver = "MySQL ODBC 8.0 Driver",
  Server = "localhost",
  Database = "mydb",
  UID = "user",
  PWD = "password"
)

Basic Operations

# Query
df <- dbGetQuery(con, "SELECT * FROM table")

# Write
dbWriteTable(con, "new_table", df)

# Execute
dbExecute(con, "UPDATE table SET col = 'value'")

Disconnect

dbDisconnect(con)
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 · 78 lines · 23 tokens per session scan A 1a401f767cf5

Subscribe to this mod's changes

odbc is a skill published in the GitHub repository LeoLin990405/r-analytics-skill (5 stars, last pushed 5mo ago), licensed MIT. It adds 23 tokens to every session and 340 once invoked, about $0.0001 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-31.

Related

Other skills, from other repositories

databricks-live-unity-catalog-grant-guard-at-azure

Mutating-runtime live guard for Unity Catalog privilege management on Azure Databricks. Executes exactly ONE GRANT or REVOKE of a single privilege on a single Unity Catalog securable (schema, table, or volume) to a single principal — with explicit written human approval, dry-run preflight, prior-state capture, and a…

VincentChuWaiChow/vanguard-frontier-agentic · 113 tokens

alibaba-live-rds-polardb-mutation-guard

Gate RDS/PolarDB instance deletion, spec downgrade, and backup policy removal — database deletion without verified backup is permanently destructive.

VincentChuWaiChow/vanguard-frontier-agentic · 39 tokens

alibaba-waf-reliability-review

Assess Alibaba Cloud workload reliability: multi-AZ ECS topology, SLB/ALB/NLB load balancing, Auto Scaling health policies, RDS/PolarDB HA failover, backup and cross-region DR, and Cloud Monitor/ARMS observability coverage.

VincentChuWaiChow/vanguard-frontier-agentic · 61 tokens

alibaba-analyticdb-realtime

Operate AnalyticDB for MySQL and PostgreSQL, Hologres real-time OLAP analytics, and DAS real-time diagnostics for sub-second interactive analytics workloads.

VincentChuWaiChow/vanguard-frontier-agentic · 40 tokens

azure-cosmosdb-performance-investigator

Use this skill for Azure Cosmos DB performance investigation, especially RU spikes, query latency, throttling, hot partitions, indexing inefficiency, partition-skew analysis, request-charge profiling, diagnostic-log review, and evidence-driven remediation planning.

VincentChuWaiChow/vanguard-frontier-agentic · 54 tokens

alibaba-polardb-rds-dba

Operate PolarDB (MySQL/PG/Oracle) clusters and RDS instances — DAS diagnostics, database proxy, Global Database Network, backup strategy, and performance tuning.

VincentChuWaiChow/vanguard-frontier-agentic · 44 tokens