postgresql-psql

A guide to using psql, the interactive command-line program for connecting to PostgreSQL databases. PostgreSQL is a database system used to store and query application data.

In plain words
What is it for?
Use it to connect to databases, run queries, manage tables and databases, format results, write psql scripts, configure connections, and work with transactions.
Why use it?
It collects the commands and settings needed to work with PostgreSQL from a terminal or script.

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

Made for: Claude Code, Codex.

Per session 64 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 8,774 The whole file, excluding the scripts and references it only reads on demand.
Security scan B 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.00064 $0.08774
Opus 5 $0.00032 $0.04387
Sonnet 5 $0.00013 $0.01755
Haiku 4.5 $0.00006 $0.00877

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

Security

Grade B, and why

postgresql-psql scanned grade B 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 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.

Asks for rootmediumPrivilege escalation

A mod that escalates privileges can change anything on the machine, not only the project.

# ~/.pgpass (chmod 600)
claude/skills/postgresql-psql/SKILL.md · 1,337 lines

The source is not reproduced here

Licensed GPL-3.0

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

Read it on GitHub

Files

What ships with it

2 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

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. 3d ago First seen · 1,337 lines · 64 tokens per session scan B 4627e8c8370a

Subscribe to this mod's changes

postgresql-psql is a skill published in the GitHub repository einverne/dotfiles (121 stars, last pushed 5d ago), licensed GPL-3.0. It adds 64 tokens to every session and 8,774 once invoked, about $0.0003 per session on Opus 5. A static security scan graded it B with 1 finding (asks for root). 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

verify-behavior

Verify or reproduce visible product behavior by driving the real UI with pi-computer-use's checked tools, requiring verified expect postconditions and durable state evidence for meaningful UI flows. Use when triage needs visual reproduction, implementation needs behavioral proof, review needs interactive confirmation…

nicknisi/dotfiles · 68 tokens

add-theme

Add a new named theme pack to the dotfiles theme system (bin/theme). Use when the user pastes an omarchy/omacosy-style theme repo URL, says "add this theme", "new theme pack", or wants another entry for theme next to cycle.

nicknisi/dotfiles · 58 tokens

source-drafting

Use when drafting documents, reports, posts, presentations, or review comments from source materials, or conducting research across provided documents. Enforces read-first drafting, a source map for every claim, agent verification, and separation of verified from unverified claims.

nicknisi/dotfiles · 54 tokens

bro

Restate the last message in plain human language, with no jargon.

nicknisi/dotfiles · 16 tokens

supabase-expert

Supabase database optimization specialist.

Vinix24/vnx-orchestration · 10 tokens

gh-stack

Manages stacked PRs and splits multi-part work into reviewable branches with gh-stack. Use for stack creation, viewing, edits, push, submit, sync, rebase, merge, or checkout; when asked to split or isolate work for review; whenever a user mentions a stack, branch layers, dependent PRs, or gh stack; or when a stack is…

nicknisi/dotfiles · 80 tokens