postgres SKILL.md skillA

postgres from lynricsy/hyperskills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned

mdr add lynricsy/hyperskills/postgres@v2026.11.04

Pins v2026.11.04 in mdr.lock. Pin the fingerprint instead.

Audit grade: A, 17 of 17 checks passed
Kind: SKILL.md skill
Repository: lynricsy/hyperskills
Path: skills/postgres/SKILL.md
Versions recorded: 5
Latest version: v2026.11.04, committed Nov 4, 2026
First version recorded: Sep 12, 2026
Size: 20,194 bytes
Repository stars: 25
License: MIT

Designs and tunes PostgreSQL schemas, SQL queries, indexes, locks, vacuum and connection pooling. Use when writing or reviewing a Postgres schema, migration or query, a query got slow or EXPLAIN shows a sequential scan, writes block on locks or a table bloats, or PgBouncer breaks prepared statements, including adding a column or index to a live table.

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

# postgres

## Scope

Covers PostgreSQL itself: schema and type selection, constraints, indexes and index
maintenance, plan reading and query rewriting, transactions and locking, MVCC and vacuum,
row-level security, online schema change, connection limits and pooling, JSONB, built-in
full-text search, pgvector, and the catalogue queries that answer "why is it slow".

The body is written against **PostgreSQL 18** (current stable; 18.6 at time of writing).
Rules that need a newer server than 14 carry a gate such as `(PG 15+)`. Nothing here
assumes 19, which had not reached general availability at time of writing (release
candidate only).

Not covered:

- The Supabase platform — Auth, Storage, Realtime, Edge Functions, the CLI and the
  dashboard. Use the `supabase` skill.
- ORM query-builder and migration-tool syntax. Use the `java-spring`, `laravel`,
  `fastapi` or `nodejs-backend` skill for the framework side; this skill only covers what
  an ORM does *to the database* — prepared statements under a pooler, N+1 round trips,
  migration locks, connection-per-request.
- Managed-hosting control planes: instance sizing, provider backups and PITR, IAM
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint

mdr add lynricsy/hyperskills/postgres@sha256:ca2f38e6663d8da3

The line at the top of this page pins the label v2026.11.04, 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](https://markdownregistry.com/badge/art_jcedu3dvb5bpopsd.svg)](https://markdownregistry.com/a/art_jcedu3dvb5bpopsd)

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

Versions

The registry has recorded 5 versions of this file, between Sep 12, 2026 and Nov 4, 2026, about one every 13 days.

version	committed	commit	size	audit
v2026.11.04 latest	2026-11-04	79f8f0d	20,194 B	A	view · diff
v2026.11.01	2026-11-01	8966742	19,925 B	A	view · diff
v2026.10.15	2026-10-15	d33235e	19,861 B	A	view · diff
v2026.09.30	2026-09-30	2be8c08	19,861 B	A	view · diff
v2026.09.12	2026-09-12	173c5f4	19,861 B	A	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 (20194 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

lynricsy/hyperskills · 25 stars · license MIT · pushed 2026-11-04 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_jcedu3dvb5bpopsd
GET https://markdownregistry.com/api/v1/resolve?ref=lynricsy/hyperskills/postgres
GET https://markdownregistry.com/api/v1/blob/ca2f38e6663d8da3c7d6909cdca14b4ffb291ae7a55df98fc6bfc3a4411974ed

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 lynricsy/hyperskills

AGENTS.md AGENTS.md file

lynricsy/hyperskills · AGENTS.md

git:20261015.8cec18e · audit A · 25 stars

ai-engineering SKILL.md skill

lynricsy/hyperskills · skills/ai-engineering/SKILL.md · Builds LLM apps: prompts, tool-using agents, RAG context and evals; not vector-index tuning.