Cloudrun Development
TencentCloudBase/CloudBase-AI-Toolkit
CloudBase Run backend development rules (Function mode/Container mode).
PostgreSQL 安装子技能。支持 apt/dnf/Docker 方式安装指定版本的 PostgreSQL，强制获取密码，幂等检测。当用户说「安装 PostgreSQL」「装 PG」时触发。
Install Postgres Install Skill
$ npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install jiushiwon/wg-skills postgres-install-skill --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill .claude/skills/postgres-install-skill && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "postgres-install-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill into .claude/skills/postgres-install-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-install-skill", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skillType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install jiushiwon/wg-skills postgres-install-skill --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill .agents/skills/postgres-install-skill && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "postgres-install-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill into .agents/skills/postgres-install-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-install-skill", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install jiushiwon/wg-skills postgres-install-skill --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill .cursor/skills/postgres-install-skill && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "postgres-install-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill into .cursor/skills/postgres-install-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-install-skill", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/jiushiwon/wg-skills.git --path vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install jiushiwon/wg-skills postgres-install-skill --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill .gemini/skills/postgres-install-skill && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "postgres-install-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill into .gemini/skills/postgres-install-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-install-skill", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install jiushiwon/wg-skills postgres-install-skillInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill .github/skills/postgres-install-skill && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "postgres-install-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill into .github/skills/postgres-install-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-install-skill", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install jiushiwon/wg-skills postgres-install-skill --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/jiushiwon/wg-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill .opencode/skills/postgres-install-skill && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "postgres-install-skill" agent skill from https://github.com/jiushiwon/wg-skills/tree/main/vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill into .opencode/skills/postgres-install-skill/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-install-skill", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
postgres-install-skill- GitHub stars
- 110
- Token cost
- ~422 tokens
- SKILL.md length
- 61 words
- Files
- 4 (incl. references)
- Skills in repo
- 121
- Repo updated
- First seen
- Licence
- Apache-2.0
At a glance
PostgreSQL 安装子技能。支持 apt/dnf/Docker 方式安装指定版本的 PostgreSQL，强制获取密码，幂等检测。当用户说「安装 PostgreSQL」「装 PG」时触发。
- Tasks that involve Skill management
- SKILL.md covers Overview, When to Use, 交互流程 and 安装方式, plus 4 more sections
- Calls docker
- Tasks that involve Containers
What it does
Postgres Install Skill is an agent skill from jiushiwon/wg-skills. PostgreSQL 安装子技能。支持 apt/dnf/Docker 方式安装指定版本的 PostgreSQL，强制获取密码，幂等检测。当用户说「安装 PostgreSQL」「装 PG」时触发。
Its SKILL.md is about 420 tokens, which your agent loads only when the skill is triggered. The skill folder holds 4 other files, including reference files (for example `README.md`, `references/install-commands.md` and `references/password-scripts.md`).
It sits in Databases, covering Skill management and Containers. It works with PostgreSQL and Docker. The licence is Apache-2.0.
When your agent uses it
- Tasks that involve Skill management
- Tasks that involve Containers
Example prompts
- “/postgres-install-skill”
Requirements
- Docker
What it can do on your machine
Read from SKILL.md and the folder at commit a4a640b. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Shell commands in SKILL.md call:
docker
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md. Its commands use docker, which can reach the network depending on how they are called.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Postgres Install Skill loads about 422 tokens when it runs, and up to ~2.9k if it reads all its reference files. Until then it costs about 30 tokens; SKILL.md has 61 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check: notes
The automated check noted patterns worth knowing about, such as sudo or a known installer.
- NoteRuns commands with sudoSKILL.md:76
- [ ] 启动服务: sudo systemctl start postgresql - NoteRuns commands with sudoSKILL.md:86
sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '你的密码';" - NoteRuns commands with sudoSKILL.md:89
sudo pg_ctlcluster 16 main stop - NoteRuns commands with sudoSKILL.md:90
sudo pg_ctlcluster 16 main start -o "-c auth=trust" - NoteRuns commands with sudoSKILL.md:91
sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '新密码';" - NoteRuns commands with sudoSKILL.md:92
sudo pg_ctlcluster 16 main restart
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from jiushiwon/wg-skills at commit a4a640b, republished under its Apache-2.0 licence (© jiushiwon). 61 words, ~422 tokens.
Download SKILL.mdSave it as
.claude/skills/postgres-install-skill/SKILL.md (or your agent's skills folder). This skill also uses 3 other files; get the full folder from GitHub.- name
- postgres-install-skill
- description
- PostgreSQL 安装子技能。支持 apt/dnf/Docker 方式安装指定版本的 PostgreSQL，强制获取密码，幂等检测。当用户说「安装 PostgreSQL」「装 PG」时触发。
PostgreSQL Install Skill
Overview
本技能负责在目标服务器上安装 PostgreSQL。支持多种安装方式，强制获取密码，幂等检测。
When to Use
触发词：
- 安装 PostgreSQL
- 装 PG
- install postgresql
交互流程
1. 检测当前系统（OS + 版本 + 包管理器）
2. 询问安装方式（包管理器 / Docker）
3. 询问版本（16 / 15 / 14）
4. [强制] 获取数据库 root 密码 → 不输入则拒绝
5. 执行安装（幂等）
6. 不执行初始化，输出初始化清单
7. 输出修改密码和重置密码脚本安装方式
包管理器安装
| OS | 安装命令 |
|---|---|
| Ubuntu/Debian | 添加 PGDG 仓库 + apt install postgresql-16 |
| CentOS/RHEL | dnf install postgresql16-server |
| macOS | brew install postgresql@16 |
| Windows | winget install PostgreSQL.PostgreSQL.16 |
Docker 安装
docker pull postgres:16版本选择
- PostgreSQL 16（最新）
- PostgreSQL 15
- PostgreSQL 14
密码安全
- 强制获取密码：不输入密码则直接拒绝安装
- 不显示输入：交互式输入时不显示密码
- 不记录密码：不将密码写入脚本或日志
输出
# PostgreSQL 安装完成
## 系统信息
- OS: Ubuntu 22.04 LTS
- 包管理器: apt
## 安装结果
- 版本: PostgreSQL 16
- 安装方式: apt
- 状态: ✅ 已安装
## 下一步（手动执行）
- [ ] 启动服务: sudo systemctl start postgresql
- [ ] 初始化数据库
## 初始化清单
- [ ] 1. 启动 PostgreSQL 服务
- [ ] 2. 修改 postgres 用户密码
- [ ] 3. 创建业务数据库
- [ ] 4. 创建业务用户并授权
## 修改密码脚本
sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '你的密码';"
## 忘记密码急救脚本
sudo pg_ctlcluster 16 main stop
sudo pg_ctlcluster 16 main start -o "-c auth=trust"
sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD '新密码';"
sudo pg_ctlcluster 16 main restartResources
- references/install-commands.md — 各 OS 安装命令
- references/password-scripts.md — 密码相关脚本
© jiushiwon, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 3 other files (references) in vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill of jiushiwon/wg-skills.
- SKILL.md
- README.md
- references/install-commands.md
- references/password-scripts.md
Open the folder on GitHubat commit a4a640b
Compare with similar skills
Postgres Install Skill next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Postgres Install Skill this skilljiushiwon/wg-skills | 110 | — | ~422 | Automated safety check: Notes | Apache-2.0 | |
| Cloudrun DevelopmentTencentCloudBase/CloudBase-AI-Toolkit | 1.1k | 1 repos | ~7.2k | Automated safety check: Pass | MIT | |
| Postgres Health Checkfmflurry/settings-opencode | 171 | — | ~3.3k | Automated safety check: Pass | MIT | |
| Monstermq Broker Configvogler75/monster-mq | 142 | — | ~2.2k | Automated safety check: Pass | GPL-3.0 | |
| Local Platform E2Ecomputesdk/benchmarks | 126 | — | ~3k | Automated safety check: Notes | MIT | |
| Fly Io DeployerLeoYeAI/openclaw-master-skills | 2.2k | — | ~6.3k | Automated safety check: Notes | MIT |
Similar skills
Postgres Health Check
fmflurry/settings-opencode
Read-only PostgreSQL instance health battery: connectivity/uptime, cache hit ratio, dead tuples & autovacuum hotspots, XID wraparound distance, long-running & idle-in-transaction sessions, unused…
Monstermq Broker Config
vogler75/monster-mq
Guide for configuring, deploying, and operating the MonsterMQ broker.
Local Platform E2E
computesdk/benchmarks
Stand up benchmarks-platform locally (Postgres + MinIO + ClickHouse in docker) and run a real @benchsdk/runner benchmark against it, with no cloud or provider credentials.
Fly Io Deployer
LeoYeAI/openclaw-master-skills
Deploy and operate Node, Python, Go, Rust, Elixir, and Docker apps on Fly.io with production-grade fly.toml authoring, Machines API orchestration, region selection (latency vs sovereignty vs…
Cognee Docker Setup
topoteretes/cognee
Runs the Cognee AI memory platform in Docker, from a one-file prebuilt image to a full compose stack with UI, MCP server, Postgres and Neo4j.
More from jiushiwon/wg-skills
All 121 skills in this repoFrontend UI Foundry
jiushiwon/wg-skills
A skill your agent uses when generating UI for a specific scenario (mobile/PC/官网/管理端/营销页/文档/金融/原生/3D), when refactoring an existing HTML/Vue/React project to a unified design system, when extracting…
Workflow Diagram Skill
jiushiwon/wg-skills
A skill your agent uses when 用户想用一句话生成流程图、工作流图解、开发流程图、AI 流程图或任何步骤型图解，支持多风格输出（flat icon / 暖白手账风 / dark / cute），并提供现成模板一键出图。
Uniapp App Generate Skill
jiushiwon/wg-skills
This skill should be used when the user wants to create a standardized uni-app project for WeChat mini-program, H5, and App from scratch.
Fastapi Init Skill
jiushiwon/wg-skills
FastAPI 项目一键初始化技能。面向零基础小白，提供环境探测、自动安装、完整 Web 骨架生成、SSE 流式框架、JWT 鉴权、统一响应封装、文件上传接口、一键启动/重启脚本、Swagger 文档，内置 MySQL（默认）/ PostgreSQL / MongoDB 数据库选择。用户只需说"帮我搭一个 FastAPI 项目"即可一条命令完成从零到跑的完整链路。触发词："FastAPI…
Ffmpeg Skill
jiushiwon/wg-skills
FFmpeg 多媒体处理技能 — 将自然语言描述转为正确的 ffmpeg 命令，覆盖视频剪辑、转码、水印、合成、提取、生成等操作。内置一键安装脚本（Windows/Mac/Linux）。触发词：ffmpeg、视频剪辑、视频裁剪、视频转码、视频压缩、去水印、加水印、视频拼接、视频合成、提取音频、视频转…
Frontend Request Skill
jiushiwon/wg-skills
A skill your agent uses when designing or reviewing the request layer of a frontend project (web / uni-app / mini-program), including request.ts wrappers, interceptors, deduplication, mocks, error…
Related
Works with
Categories
Questions about Postgres Install Skill
What does Postgres Install Skill do?
PostgreSQL 安装子技能。支持 apt/dnf/Docker 方式安装指定版本的 PostgreSQL，强制获取密码，幂等检测。当用户说「安装 PostgreSQL」「装 PG」时触发。. Postgres Install Skill is an agent skill from jiushiwon/wg-skills.
When should I use Postgres Install Skill?
Postgres Install Skill fits situations like: tasks that involve Skill management; tasks that involve Containers.
How do I install Postgres Install Skill in Claude Code?
Run `npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a claude-code`. Or copy the skill folder (vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill in jiushiwon/wg-skills) into .claude/skills/postgres-install-skill in your project. Claude Code loads it when a task matches its description.
How do I install Postgres Install Skill in Codex?
Run `npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a codex`. Or copy the skill folder (vibeCoding/super-deploy-skills/database-install-skill/children/postgres-install-skill in jiushiwon/wg-skills) into .agents/skills/postgres-install-skill in your project. Codex loads it when a task matches its description.
Can I use Postgres Install Skill in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jiushiwon/wg-skills --skill postgres-install-skill -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/postgres-install-skill, .gemini/skills/postgres-install-skill, .github/skills/postgres-install-skill and .opencode/skills/postgres-install-skill in your project.
What does Postgres Install Skill need to run?
Going by SKILL.md and its folder, Postgres Install Skill needs the command-line tools its instructions call (docker). Our summary lists: Docker.
Does Postgres Install Skill access the network?
SKILL.md contains no URLs. Its commands use docker, which can reach the network depending on how they are called. This is read from the text; nothing was executed.
Is Postgres Install Skill safe to install?
Our automated static check of SKILL.md found notes only (runs commands with sudo), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.
What licence does Postgres Install Skill use?
Postgres Install Skill is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Postgres Install Skill use?
About 422 tokens (SKILL.md is roughly 1.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 2.4k tokens, read only when the agent opens those files.
What are the alternatives to Postgres Install Skill?
Skills that share tags, products or a category with Postgres Install Skill: Cloudrun Development (TencentCloudBase/CloudBase-AI-Toolkit, 1.1k stars), Postgres Health Check (fmflurry/settings-opencode, 171 stars), Monstermq Broker Config (vogler75/monster-mq, 142 stars) and Local Platform E2E (computesdk/benchmarks, 126 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Postgres Install Skill?
jiushiwon (a GitHub user) maintains it in jiushiwon/wg-skills, which has 110 GitHub stars. The repository holds 121 skills in this directory. The repository was last updated on October 4, 2026.
Source: jiushiwon/wg-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.