SQL Database Support for pREST
prest/prest
Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects.
Analyze PostgreSQL git commit history between two commit ids and, when valuable DBA/application-developer changes exist, write a Chinese Markdown article for WeChat/公众号 readers with examples checked…
$ npx skills add digoal/blog --skill postgres-commit-history-article -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install digoal/blog postgres-commit-history-article --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/digoal/blog.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/postgres-commit-history-article .claude/skills/postgres-commit-history-article && 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-commit-history-article" agent skill from https://github.com/digoal/blog/tree/master/skills/postgres-commit-history-article into .claude/skills/postgres-commit-history-article/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-commit-history-article", 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/digoal/blog/tree/master/skills/postgres-commit-history-articleType 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 digoal/blog --skill postgres-commit-history-article -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install digoal/blog postgres-commit-history-article --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/digoal/blog.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/postgres-commit-history-article .agents/skills/postgres-commit-history-article && 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-commit-history-article" agent skill from https://github.com/digoal/blog/tree/master/skills/postgres-commit-history-article into .agents/skills/postgres-commit-history-article/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-commit-history-article", 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 digoal/blog --skill postgres-commit-history-article -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install digoal/blog postgres-commit-history-article --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/digoal/blog.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/postgres-commit-history-article .cursor/skills/postgres-commit-history-article && 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-commit-history-article" agent skill from https://github.com/digoal/blog/tree/master/skills/postgres-commit-history-article into .cursor/skills/postgres-commit-history-article/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-commit-history-article", 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/digoal/blog.git --path skills/postgres-commit-history-article--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 digoal/blog --skill postgres-commit-history-article -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install digoal/blog postgres-commit-history-article --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/digoal/blog.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/postgres-commit-history-article .gemini/skills/postgres-commit-history-article && 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-commit-history-article" agent skill from https://github.com/digoal/blog/tree/master/skills/postgres-commit-history-article into .gemini/skills/postgres-commit-history-article/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-commit-history-article", 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 digoal/blog postgres-commit-history-articleInstalls 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 digoal/blog --skill postgres-commit-history-article -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/digoal/blog.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/postgres-commit-history-article .github/skills/postgres-commit-history-article && 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-commit-history-article" agent skill from https://github.com/digoal/blog/tree/master/skills/postgres-commit-history-article into .github/skills/postgres-commit-history-article/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-commit-history-article", 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 digoal/blog --skill postgres-commit-history-article -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install digoal/blog postgres-commit-history-article --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/digoal/blog.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/postgres-commit-history-article .opencode/skills/postgres-commit-history-article && 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-commit-history-article" agent skill from https://github.com/digoal/blog/tree/master/skills/postgres-commit-history-article into .opencode/skills/postgres-commit-history-article/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "postgres-commit-history-article", 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.
postgres-commit-history-articleAnalyze PostgreSQL git commit history between two commit ids and, when valuable DBA/application-developer changes exist, write a Chinese Markdown article for WeChat/公众号 readers with examples checked…
Postgres Commit History Article is an agent skill from digoal/blog. Analyze PostgreSQL git commit history between two commit ids and, when valuable DBA/application-developer changes exist, write a Chinese Markdown article for WeChat/公众号 readers with examples checked against SQL tests, docs, or relevant source. Use when the user is inside a PostgreSQL source checkout and provides two commit ids, asks to interpret Postgres commits, summarize a release/development window, identify DBA/application-developer value from commit logs, group related commits, exclude reverted commits, and…
Its SKILL.md is about 2.3k tokens, which your agent loads only when the skill is triggered. The skill folder holds 4 other files, including scripts (for example `agents/openai.yaml` and `scripts/collect_pg_commits.py`).
It sits in Databases, covering Commit messages, Messaging and chat bots and SQL. It works with PostgreSQL, SQL and WeChat. The repository describes itself as: AI,Opensource,Database,Business,Finance,Minds. git clone --depth 1 https://github.com/digoal/blog. The licence is GPL-2.0.
7 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit 69fb793. It shows what the files ask for, not the result of running them.
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.
Ships 1 file in scripts/ (Python), which the agent can run.
Shell commands in SKILL.md call:
gitpython3From the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md. Its commands use git, which can reach the network depending on how they are called.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Postgres Commit History Article loads about 2.3k tokens when it runs. Until then it costs about 175 tokens; SKILL.md has 912 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.
The automated check found no risky patterns in SKILL.md.
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); the scripts in this folder are not scanned.
The full file from digoal/blog at commit 69fb793, republished under its GPL-2.0 licence (© digoal). 912 words, ~2,256 tokens.
.claude/skills/postgres-commit-history-article/SKILL.md (or your agent's skills folder). This skill also uses 2 other files; get the full folder from GitHub.Turn a PostgreSQL commit range into a publishable Chinese Markdown article for DBA and application developers when the range contains valuable user-facing or operator-facing changes. Work from commit logs first, then only deep-read full commit messages for selected valuable groups. Before writing usage examples, inspect relevant SQL tests, documentation, or source context so examples are rich and correct. Do not analyze code diffs unless needed to understand a mechanism or produce a practical example.
Expect the user to run the skill from a PostgreSQL git checkout and provide:
commitid1 commitid2Treat the range as inclusive of both endpoints. If the order is unclear, test both ancestry directions and use the direction that produces a valid range; otherwise ask for clarification.
Verify context.
git rev-parse --show-toplevel succeeds.src/backend, src/include, and configure.ac exist.markdown/ in the current project if missing.Collect commit metadata without diffs.
scripts/collect_pg_commits.py from this skill.python3 /path/to/postgres-commit-history-article/scripts/collect_pg_commits.py commitid1 commitid2 --output markdown/postgres-commit-range.jsonFirst-pass analysis from short descriptions only.
Group related commits.
Deep-read only selected groups.
git show -s --format=fuller <commit>.Verify example material before writing usage examples.
使用示例, inspect nearby authoritative material for that feature:src/test/regress/sql/, src/test/isolation/specs/, src/test/subscription/t/, src/test/recovery/t/, extension test SQL, or TAP tests.doc/src/sgml/, especially pages for SQL commands, functions, catalogs, GUCs, monitoring views, replication, backup/recovery, and release notes.Write the article.
markdown/ in the current project. Use a filename like:markdown/postgres-commit-history-<short1>-<short2>.mdWhen the selected range has no commits worth a DBA/application-developer article, return a concise Chinese analysis instead of creating a Markdown file:
本次范围:<commit1>..<commit2>(含两端),共 <n> 个提交。
结论:未发现值得面向 DBA 或应用开发者单独成文解读的提交。
原因:
- 已剔除 range 内 revert 的提交:<ids or 无>
- 其余提交主要属于:<测试/文档/拼写/构建/内部重构/无用户可见行为变化等>
- 未发现明确的性能、可靠性、可观测性、SQL 行为、复制恢复、运维接口、应用兼容性或迁移风险变化。
可保留记录:
| commit | 作者 | 简短描述 | 判断 |
|---|---|---|---|
| abc1234 | ... | ... | 不成文:... |
未输出文章文件。Do not create markdown/postgres-commit-history-*.md in this case. It is acceptable to keep the collector JSON only if it was already generated as working data.
Use a consistent structure for every selected item or group:
## N. 标题(commit: abc1234, def5678)
一句话简介:...
出现背景:...
解决什么痛点:...
用的什么方法:...
效果对比:
- 补丁前:...
- 补丁后:...
使用场景:...
最佳实践:...
使用示例:
```sql
...
```If a SQL example is not appropriate, use a shell, config, monitoring query, operational checklist, or "无需用户侧改动,但建议验证..." example.
Every usage example must be backed by one of: a PostgreSQL SQL regression/isolation/TAP test, SGML documentation, or relevant source context. Prefer citing the path briefly after the example, for example: 示例依据:src/test/regress/sql/xxx.sql, doc/src/sgml/yyy.sgml.
Recommended outline:
# PostgreSQL 提交解读:从 <commit1> 到 <commit2>,哪些变化最值得 DBA 和开发者关注?
> 范围:<commit1>..<commit2>(含两端),共 <n> 个提交;剔除 range 内 revert 后重点解读 <m> 组。
## 先给结论
## 这批提交的主线
```mermaid
flowchart LR
A["可靠性"] --> B["运维成本下降"]
C["性能/优化器"] --> D["查询体验改善"]
E["开发者接口"] --> F["应用改造更少"]
```
## 值得关注的改进
... repeat the required per-group structure ...
## DBA 落地清单
## 应用开发者落地清单
## 版本升级与验证建议
## 附:commit 分组表Add Mermaid diagrams where they clarify relationships, such as:
Use inline SVG only if Mermaid cannot express the concept clearly. Keep diagrams readable in WeChat Markdown.
# Confirm both endpoints exist
git rev-parse --verify <commitid1>^{commit}
git rev-parse --verify <commitid2>^{commit}
# Show only subjects for the inclusive range
git log --reverse --format='%h%x09%an%x09%ad%x09%s' --date=short <older>^..<newer>
# Show full message for selected commits, no diff
git show -s --format=fuller <commit>© digoal, GPL-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 2 other files (scripts) in skills/postgres-commit-history-article of digoal/blog.
Open the folder on GitHubat commit 69fb793
Postgres Commit History Article 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 Commit History Article this skilldigoal/blog | 8.6k | — | ~2.3k | Automated safety check: Pass | GPL-2.0 | |
| SQL Database Support for pRESTprest/prest | 4.6k | — | ~1.6k | Automated safety check: Pass | MIT | |
| Chdb SQLvemetric/vemetric | 394 | 1 repos | ~1.2k | Automated safety check: Pass | Apache-2.0 | |
| Schema Explorationtimescale/pg-aiguide | 1.9k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | |
| Mz BenchmarkMaterializeInc/materialize | 6.4k | — | ~2.8k | Automated safety check: Pass | Custom licence | |
| Dingtalk AitableDingTalk-Real-AI/dingtalk-workspace-cli | 3.2k | — | ~5.4k | Automated safety check: Pass | Apache-2.0 |
prest/prest
Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects.
vemetric/vemetric
A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse…
timescale/pg-aiguide
Explore an existing PostgreSQL database before answering questions about its data or writing SQL.
MaterializeInc/materialize
Add/modify/debug Materialize perf benchmark scenarios. An agent skill from MaterializeInc/materialize.
DingTalk-Real-AI/dingtalk-workspace-cli
钉钉 AI 表格(多维表)业务操作。Use when 用户需要操作 AI 表格/多维表/Base/Table、应用模式/App 页面/Widget、建表、查写记录、字段、记录评论、评论回复、访问密钥(API Key)、SQL/PostgreSQL/SELECT/JOIN、筛选、排序、公式、模板、批量导入 CSV 或 JSON、导出、仪表盘、图表、上传附件、数据源配置与同步、按任务 ID…
ystemsrx/sql_to_ER
A skill your agent uses when the user wants a Chen-model ER diagram from SQL CREATE TABLE statements or DBML, wants to rearrange or clean up an existing sql2er state, wants a skeleton-only overview…
digoal/blog
三层审查模型,逐段逐句验证文章真伪、证据链与逻辑结构。Use when the user asks to fact-check, verify, audit, or evaluate the credibility of an article, essay, report, opinion piece, social-media post, or any written claim —…
digoal/blog
Find latent bugs in a local PostgreSQL source tree (RELxxSTABLE branch or HEAD) the way a core hacker does: build a heavily-poisoned debug instance (cassert + cache-discard + -O0/-ggdb3 + core…
digoal/blog
Portable digital employee distilled from digoal's personal blog for PostgreSQL, PolarDB, DuckDB, AI+database, vector/RAG, database operations, source-code reading, technical content creation…
digoal/blog
从论文 PDF 文件或论文 PDF URL 生成通俗易懂、图文并茂、带批判性评估的中文 Markdown 解读,并保存到当前项目的 markdown 目录。Use when the user asks to interpret,精读,解读,summarize,explain,analyze, or write an article from an academic paper PDF…
digoal/blog
Analyze a product from documentation, websites, PDFs, articles, release notes, pricing pages, app listings, reviews, filings, or related links; save separate intermediate analyses from seven roles…
digoal/blog
Turn a blog post, article, notes, or any source material into a set of vertical poster images — one cover plus several coherent content slides that explain the core points.
Works with
Categories
Analyze PostgreSQL git commit history between two commit ids and, when valuable DBA/application-developer changes exist, write a Chinese Markdown article for WeChat/公众号 readers with examples checked…. Postgres Commit History Article is an agent skill from digoal/blog. Analyze PostgreSQL git commit history between two commit ids and, when valuable DBA/application-developer changes exist, write a Chinese Markdown article for WeChat/公众号 readers with examples checked against SQL tests, docs, or relevant source.
Postgres Commit History Article fits situations like: the user is inside a PostgreSQL source checkout and provides two commit ids; asks to interpret Postgres commits; summarize a release/development window; identify DBA/application-developer value from commit logs.
Run `npx skills add digoal/blog --skill postgres-commit-history-article -a claude-code`. Or copy the skill folder (skills/postgres-commit-history-article in digoal/blog) into .claude/skills/postgres-commit-history-article in your project. Claude Code loads it when a task matches its description.
Run `npx skills add digoal/blog --skill postgres-commit-history-article -a codex`. Or copy the skill folder (skills/postgres-commit-history-article in digoal/blog) into .agents/skills/postgres-commit-history-article in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add digoal/blog --skill postgres-commit-history-article -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-commit-history-article, .gemini/skills/postgres-commit-history-article, .github/skills/postgres-commit-history-article and .opencode/skills/postgres-commit-history-article in your project.
Going by SKILL.md and its folder, Postgres Commit History Article needs Python for the scripts in its folder and the command-line tools its instructions call (git and python3). Our summary lists: Python 3.
SKILL.md contains no URLs. Its commands use git, which can reach the network depending on how they are called. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.
Postgres Commit History Article is published under the GPL-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 2.3k tokens (SKILL.md is roughly 9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Postgres Commit History Article: SQL Database Support for pREST (prest/prest, 4.6k stars), Chdb SQL (vemetric/vemetric, 394 stars), Schema Exploration (timescale/pg-aiguide, 1.9k stars) and Mz Benchmark (MaterializeInc/materialize, 6.4k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
digoal (a GitHub user) maintains it in digoal/blog, which has 8,587 GitHub stars. The repository holds 98 skills in this directory. The repository was last updated on September 28, 2026.
Source: digoal/blog on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.