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.
npx agentmods add skills/leolin990405/r-analytics-skill/rpostgresnpx skills add LeoLin990405/r-analytics-skill --skill rpostgresgit clone --depth 1 https://github.com/LeoLin990405/r-analytics-skillWrote 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.
[](https://agentmods.dev/skills/leolin990405/r-analytics-skill/rpostgres)<a href="https://agentmods.dev/skills/leolin990405/r-analytics-skill/rpostgres"><img src="https://agentmods.dev/badge/skills/leolin990405/r-analytics-skill/rpostgres.svg" alt="Measured on agentmods" height="20"></a>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.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5 | $0.00025 | $0.00346 |
| Opus 5 | $0.00013 | $0.00173 |
| Sonnet 5 | $0.00005 | $0.00069 |
| Haiku 4.5 | $0.00003 | $0.00035 |
Grade A, and why
RPostgres 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 3d 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.
What it actually says
RPostgres Package
PostgreSQL database interface.
Connect
library(DBI)
library(RPostgres)
con <- dbConnect(
Postgres(),
dbname = "mydb",
host = "localhost",
port = 5432,
user = "user",
password = "password"
)
# With connection string
con <- dbConnect(
Postgres(),
"postgresql://user:password@localhost:5432/mydb"
)
Basic Operations
# Query
df <- dbGetQuery(con, "SELECT * FROM users LIMIT 100")
# Write table
dbWriteTable(con, "new_table", df)
# Append
dbWriteTable(con, "existing", df, append = TRUE)
# Overwrite
dbWriteTable(con, "existing", df, overwrite = TRUE)
Parameterized Queries
dbGetQuery(con,
"SELECT * FROM users WHERE id = $1 AND status = $2",
params = list(123, "active")
)
COPY Protocol (Fast)
# Fast bulk insert
dbWriteTable(con, "big_table", big_df, copy = TRUE)
Schemas
# Specify schema
dbWriteTable(con, Id(schema = "analytics", table = "events"), df)
dbReadTable(con, Id(schema = "analytics", table = "events"))
Disconnect
dbDisconnect(con)
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.
- 3d ago First seen · 77 lines · 25 tokens per session scan A dc54b3e927cd
RPostgres is a skill published in the GitHub repository LeoLin990405/r-analytics-skill (5 stars, last pushed 5mo ago), licensed MIT. It adds 25 tokens to every session and 346 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.
Other skills, from other repositories
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.
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.
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.
fused-html-artifacts
Authoring standalone HTML artifacts — scripts/ /main.html documents that Fused and Flow serve full-bleed and wire to a window.fused runtime (callUdf / runSql / params). Use when the output of a project is a bespoke interactive HTML page — a custom chart, a form, a report, a small app — that calls UDFs and runs SQL…
json-ui-schemas
JSON schemas for Fused canvas UI widget components (text, text-input, button, dropdown, charts, maps, sql-table, form, transformer, etc.). Use when authoring or editing widget JSON files (e.g. widget.json in canvas directories), validating widget props, or answering questions about which fields a given widget type…
bio-core-biological-databases
Fetch sequences via NCBI Entrez (esearch/efetch/elink), UniProt REST, and RCSB PDB APIs with BioPython/urllib. Use when picking a database, decoding accession prefixes (NM/XM/GSE/SRR), or cross-linking a gene NCBI-UniProt-PDB.