postgresql-psql SKILL.md skillA

postgresql-psql from unique-divine/jiyuu is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add unique-divine/jiyuu/postgresql-psql@git:20261019.3364445

Pins git:20261019.3364445 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
unique-divine/jiyuu
Path
ai-skills/postgresql-psql/SKILL.md
Versions recorded
2
Latest version
git:20261019.3364445, committed Oct 19, 2026
First version recorded
Jan 16, 2026
Size
2,884 bytes
Repository stars
6
License
MIT

Comprehensive guide for PostgreSQL psql - the interactive terminal client for PostgreSQL. Use when connecting to PostgreSQL databases, executing queries, managing databases/tables, configuring connection options, formatting output, writing scripts, managing transactions, and using advanced psql features for database administration and development.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# PostgreSQL psql Skill

Version: 1.0.0.

PostgreSQL psql (PostgreSQL interactive terminal) is the primary command-line client for interacting with PostgreSQL databases. It provides both interactive query execution and powerful scripting capabilities for database management and administration.

## When to Use This Skill

Use this skill when:

- Connecting to PostgreSQL databases from the command line
- Executing SQL queries interactively
- Writing SQL scripts for automation
- Creating and managing databases and schemas
- Managing database objects (tables, views, indexes, functions)
- Backing up and restoring databases
- Configuring connections and authentication
- Formatting and exporting query results
- Managing transactions and permissions
- Debugging SQL queries
- Automating database administration tasks
- Setting up replication and high availability
- Creating stored procedures and functions

## Core Concepts

### REPL Model

- psql operates as an interactive REPL (Read-Eval-Print Loop)
- Accepts SQL commands and meta-commands (backslash commands)
- Maintains connection state across commands within a session
- Supports command history and editing

### Command Types
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add unique-divine/jiyuu/postgresql-psql@sha256:d7724b8c506743c5

The line at the top of this page pins the label git:20261019.3364445, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_5jpglq6rvopuq33u.svg)](https://markdownregistry.com/a/art_5jpglq6rvopuq33u)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 2 versions of this file, between Jan 16, 2026 and Oct 19, 2026, about one every 276 days.

versioncommittedcommitsizeaudit
git:20261019.3364445 latest2026-10-19 3364445 2,884 BA view · diff
v1.0.02026-01-16 3150800 2,882 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (2884 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

unique-divine/jiyuu · 6 stars · license MIT · pushed 2026-10-19 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_5jpglq6rvopuq33u
GET https://markdownregistry.com/api/v1/resolve?ref=unique-divine/jiyuu/postgresql-psql
GET https://markdownregistry.com/api/v1/blob/d7724b8c506743c561cefe08bac3a9f707b3eb85e1c66e0d547da3eec1ecaf2d

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from unique-divine/jiyuu

AGENTS.md AGENTS.md file
unique-divine/jiyuu · AGENTS.md
git:20261018.6f4c2d7 · audit B · 6 stars
bash-defensive-patterns SKILL.md skill
unique-divine/jiyuu · ai-skills/bash-defensive-patterns/SKILL.md · Master defensive Bash programming techniques for production-grade scripts. Use when writing robust shell scripts, CI/CD…
git:20260314.ee0306a · audit A · 6 stars
drill-spec SKILL.md skill
unique-divine/jiyuu · ai-skills/drill-spec/SKILL.md · Interview the user relentlessly about a plan, spec, or design until reaching shared understanding, resolving each…
git:20260920.e63d7f9 · audit A · 6 stars
evm-rpc SKILL.md skill
unique-divine/jiyuu · ai-skills/evm-rpc/SKILL.md · Query EVM JSON-RPC methods for transaction debugging and endpoint
git:20260920.cf13e30 · audit A · 6 stars
gh-actionlint SKILL.md skill
unique-divine/jiyuu · ai-skills/gh-actionlint/SKILL.md · Validate GitHub Actions workflow YAML with actionlint when editing files under `.github/workflows/`, checking CI…
git:20260612.ca1fbc5 · audit A · 6 stars
gh-ci-watch SKILL.md skill
unique-divine/jiyuu · ai-skills/gh-ci-watch/SKILL.md · Watch GitHub PR checks with gh, poll until green/failure/timeout, fetch failed GitHub Actions logs, save logs locally…
git:20260810.c46c0a3 · audit A · 6 stars
gh-labels SKILL.md skill
unique-divine/jiyuu · ai-skills/gh-labels/SKILL.md · Reference for what GitHub issue/PR labels mean in this workspace (S-triage, S-needs-scope, S-impl, prio-p0-critical…
git:20261006.baec912 · audit A · 6 stars
gh-pr-review SKILL.md skill
unique-divine/jiyuu · ai-skills/gh-pr-review/SKILL.md · Review GitHub pull requests for correctness, design quality, test coverage, security, performance, and backward…
git:20261019.d94b888 · audit A · 6 stars
gh-pr SKILL.md skill
unique-divine/jiyuu · ai-skills/gh-pr/SKILL.md · Writes clear pull request descriptions from the current branch diff against a base branch. Defaults to `main`, but…
git:20260920.c6c9f1b · audit A · 6 stars
gh-rev SKILL.md skill
unique-divine/jiyuu · ai-skills/gh-rev/SKILL.md · Use the gh-rev CLI to maintain a persistent Markdown review ledger for local branches and pull requests. Trigger when…
git:20261019.d94b888 · audit A · 6 stars
herdr SKILL.md skill
unique-divine/jiyuu · ai-skills/herdr/SKILL.md · Control or customize Herdr, a terminal multiplexer for coding agents. Use when the user explicitly mentions Herdr, asks…
git:20261019.52b07d6 · audit A · 6 stars
just SKILL.md skill
unique-divine/jiyuu · ai-skills/justfile/SKILL.md · Prefer the nearest relevant `justfile` as the default command surface for build, test, lint, format, run, deploy, and…
git:20260810.c46c0a3 · audit A · 6 stars

Every file in unique-divine/jiyuu

Browse by kind, by grade A, or by owner.