postgres-adopt SKILL.md skillA

postgres-adopt from garrytan/gbrain is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add garrytan/gbrain/postgres-adopt@git:20261007.590bb9a

Pins git:20261007.590bb9a in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
garrytan/gbrain
Path
skills/postgres-adopt/SKILL.md
Versions recorded
5
Latest version
git:20261007.590bb9a, committed Oct 7, 2026
First version recorded
Aug 27, 2026
Size
8,485 bytes
Repository stars
31,587
License
MIT

Detect which gbrain engine is in use (PGLite vs Postgres), prefer Postgres for agent-harness installs, install/provision Postgres (Supabase discovery via SUPABASE_ACCESS_TOKEN, local Postgres, opt-in Docker), and move an existing PGLite brain to Postgres with its history (plan, ask, run). Detection is one engine-free command; the install ladder is one flag.

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 Adopt

> The engine is the brain's foundation: PGLite is the zero-config floor,
> Postgres is where concurrency, multi-machine access, and 1000+ pages live.
> This skill answers "which one am I on?", prefers Postgres when the
> operator wants it, and moves data safely — never by flipping config.

## Contract

This skill guarantees:
- Detection is engine-free and read-only: `gbrain engine status --json`
  answers with the database down (that is the point of the command).
- Engine changes NEVER happen by editing config. A PGLite brain moves with
  `gbrain migrate --to postgres` (alias `--to supabase`), which graduates it:
  plan first (exit 3), run only with the user's `--yes --expect <plan_hash>`,
  verify every table, then flip routing. This skill wraps it; it never
  reimplements it.
- The target URL never appears in a command, transcript or output: it lives
  in `GBRAIN_TARGET_URL` and every command uses `--url-env GBRAIN_TARGET_URL`.
- Provisioning consent is explicit: the docker rung needs `--allow-docker`,
  creating a database on a local server needs `--allow-create-db`. Headless
  mutation of infrastructure the operator didn't opt into never happens.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add garrytan/gbrain/postgres-adopt@sha256:8cf801e2e0d29da5

The line at the top of this page pins the label git:20261007.590bb9a, 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_wttlpuzyejmfd4yt.svg)](https://markdownregistry.com/a/art_wttlpuzyejmfd4yt)

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

Versions

The registry has recorded 5 versions of this file, between Aug 27, 2026 and Oct 7, 2026, about one every 10 days.

versioncommittedcommitsizeaudit
git:20261007.590bb9a latest2026-10-07 590bb9a 8,485 BA view · diff
git:20261004.cf7c4842026-10-04 cf7c484 8,443 BA view · diff
git:20261004.9d7b8ef2026-10-04 9d7b8ef 8,435 BA view · diff
git:20261004.739e5cc2026-10-04 739e5cc 6,106 BA view · diff
git:20260827.534a27a2026-08-27 534a27a 5,485 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 (8485 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

garrytan/gbrain · 31,587 stars · license MIT · pushed 2026-11-06 · branch master

API

GET https://markdownregistry.com/api/v1/artifacts/art_wttlpuzyejmfd4yt
GET https://markdownregistry.com/api/v1/resolve?ref=garrytan/gbrain/postgres-adopt
GET https://markdownregistry.com/api/v1/blob/8cf801e2e0d29da525a8c4ba275b91e6caffc8aae8e648cbcc8bceaab865c890

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 garrytan/gbrain

AGENTS.md AGENTS.md file
garrytan/gbrain · AGENTS.md
git:20261104.3b81f1a · audit B · 31,587 stars
CLAUDE.md CLAUDE.md file
garrytan/gbrain · CLAUDE.md
git:20261026.fe9154d · audit A · 31,587 stars
DESIGN.md DESIGN.md file
garrytan/gbrain · DESIGN.md
git:20260519.3a0e111 · audit A · 31,587 stars
DESIGN.md@admin DESIGN.md file
garrytan/gbrain · admin/DESIGN.md
git:20260503.f082501 · audit A · 31,587 stars
gbrain SKILL.md skill
garrytan/gbrain · docs/integrations/qm-harness-snippets/SKILL.md · Search and write the company knowledge brain. Use for any question about the org, people, projects, decisions, or…
git:20260801.aff34a4 · audit A · 31,587 stars
reference-pack SKILL.md skill
garrytan/gbrain · examples/skillpack-reference/skills/reference-pack/SKILL.md · Reference skill demonstrating the 10/10 skillpack contract. Adds a "what does this skillpack do" answer to the user's…
git:20260520.bc9f777 · audit A · 31,587 stars
llms-full.txt llms.txt file
garrytan/gbrain · llms-full.txt
git:20261106.dd98008 · audit F · 31,587 stars
llms.txt llms.txt file
garrytan/gbrain · llms.txt
git:20261104.dea361e · audit A · 31,587 stars
brain-ingest-gate SKILL.md skill
garrytan/gbrain · plugin-variants/gbrain-coding/skills/brain-ingest-gate/SKILL.md · Pre-write quality gate for content entering the brain. No raw copies: a bare cp/mv into the brain repo is a bug. Before…
v1.0.0 · audit A · 31,587 stars
brain-link-discipline SKILL.md skill
garrytan/gbrain · plugin-variants/gbrain-coding/skills/brain-link-discipline/SKILL.md · When you report a brain page to the user — created, edited, committed, or relayed from a subagent — a working link is…
v1.0.0 · audit A · 31,587 stars
brain-ops SKILL.md skill
garrytan/gbrain · plugin-variants/gbrain-coding/skills/brain-ops/SKILL.md · Brain knowledge base operations. The core read/write cycle: brain-first lookup, read-enrich-write loop, source…
v1.2.0 · audit A · 31,587 stars
concept-synthesis SKILL.md skill
garrytan/gbrain · plugin-variants/gbrain-coding/skills/concept-synthesis/SKILL.md · Deduplicate and synthesize raw concept stubs into a tiered intellectual map (T1 Canon to T4 Riff), tracing idea…
v0.2.0 · audit A · 31,587 stars

Every file in garrytan/gbrain

Other files named postgres-adopt

postgres-adopt SKILL.md skill
garrytan/gbrain · plugin/skills/postgres-adopt/SKILL.md · Detect which gbrain engine is in use (PGLite vs Postgres), prefer Postgres for agent-harness installs…
git:20261007.590bb9a · audit A · 31,587 stars
postgres-adopt SKILL.md skill
garrytan/gbrain · plugin-variants/gbrain-coding/skills/postgres-adopt/SKILL.md · Detect which gbrain engine is in use (PGLite vs Postgres), prefer Postgres for agent-harness installs…
git:20261007.590bb9a · audit A · 31,587 stars
postgres-adopt SKILL.md skill
garrytan/gbrain · plugin-variants/gbrain-daily/skills/postgres-adopt/SKILL.md · Detect which gbrain engine is in use (PGLite vs Postgres), prefer Postgres for agent-harness installs…
git:20261007.590bb9a · audit A · 31,587 stars

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