Home / tencentcloudbase / cloudbase-ai-toolkit · connectors/cloudbase-intl/skills/references/postgresql-best-practices-cloudbase/SKILL.md · GitHub

postgresql-best-practices-cloudbase skillA

postgresql-best-practices-cloudbase is agent-read markdown (skill) from tencentcloudbase/cloudbase-ai-toolkit: CloudBase PostgreSQL access-pattern and slow-query quality guidance. Use when designing how tables are read and written, eliminating per-row database calls, adding indexes for filters or joins, reviewing high-traffic data access, or explaining a slow SQL query. Not for first-time PG SDK setup, login UI, or NoSQL collections..

Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.

What the file says

# CloudBase PostgreSQL Best Practices

This skill turns a working CloudBase PG implementation into a reviewable access design. It makes query paths, indexes, row authorization, and launch capacity explicit before code is considered complete.

## Sibling skills (local only)

Sibling CloudBase skills ship beside this skill. Use local relative paths such as `../postgresql-development-cloudbase/SKILL.md`.

If a referenced sibling skill file is missing from this environment, ask the user to install the full CloudBase plugin (or the missing skill). Do **not** HTTP-fetch remote skill or protocol markdown into the agent context.

## When to use

- A feature needs a new or changed access pattern.
- Application code performs repeated, serial, or high-frequency PG queries.
- A SQL query, RPC, endpoint, or polling path is slow.
- A high-traffic launch needs a database readiness review.

## Do NOT use for

- PG environment setup, `app.rdb()` syntax, migrations, GRANTs, or base RLS correctness: use `../postgresql-development-cloudbase/SKILL.md`.
- Login provider or UI implementation: use the matching auth skill.
- Confirmed NoSQL collection work: use the document database skill.
…

Read the whole file at its exact version.

How to install

Latest version
mdr add tencentcloudbase/cloudbase-ai-toolkit/postgresql-best-practices-cloudbase@v2.34.6
Exact content
mdr add tencentcloudbase/cloudbase-ai-toolkit/postgresql-best-practices-cloudbase@sha256:45104c03d10c00fe

Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.

Badge

mdr badge

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

1 badge views in 30 days

Versions

versioncommittedcommitsizeaudit
v2.34.6 latest2026-09-21 dac6cae 5,228 BA view · diff
v2.34.52026-09-20 8649887 5,228 BA view · diff
v2.34.42026-09-20 bc53199 5,228 BA view

Audit of the latest version

A  17 of 17 checks passed. Deterministic, no model, 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 (5228 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

tencentcloudbase/cloudbase-ai-toolkit · 1,123 stars · license MIT · pushed 2026-09-24 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_vwq36q2f7s2nfdba
GET https://markdownregistry.com/api/v1/resolve?ref=tencentcloudbase/cloudbase-ai-toolkit/postgresql-best-practices-cloudbase
GET https://markdownregistry.com/api/v1/blob/45104c03d10c00fec9053b4894471127bcc215e742b78e19eb0ab96a20f3099a

Your agent 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.

More from tencentcloudbase/cloudbase-ai-toolkit

project rules
tencentcloudbase/cloudbase-ai-toolkit · .cursor/rules/project.mdc
git:20250814.0b2a2ca · audit A · 1,123 stars
AGENTS.md agents
tencentcloudbase/cloudbase-ai-toolkit · AGENTS.md
git:20260924.42f9654 · audit A · 1,123 stars
CLAUDE.md claude
tencentcloudbase/cloudbase-ai-toolkit · CLAUDE.md
git:20260625.bd0be5f · audit B · 1,123 stars
ai-model-nodejs skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/ai-model-nodejs/SKILL.md · Use this skill for Node.js backend AI via @cloudbase/node-sdk (>=3.16.0) — cloud functions, CloudRun…
v2.34.6 · audit A · 1,123 stars
ai-model-web skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/ai-model-web/SKILL.md · Use this skill when a browser/Web app (React, Vue, Next, Nuxt, static sites, SPAs, dashboards, AI chat UI, 页面, 前端, 网页)…
v2.34.6 · audit A · 1,123 stars
ai-model-wechat skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/ai-model-wechat/SKILL.md · Use this skill for WeChat Mini Program AI via wx.cloud.extend.AI (小程序, wx.cloud apps). Covers generateText and…
v2.34.6 · audit A · 1,123 stars
auth-nodejs-cloudbase skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/auth-nodejs-cloudbase/SKILL.md · CloudBase Node SDK auth guide for server-side identity, user lookup, and custom login tickets. This skill should be…
v2.34.6 · audit A · 1,123 stars
auth-tool-cloudbase skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/auth-tool-cloudbase/SKILL.md · CloudBase auth provider configuration and login-readiness guide. This skill should be used when users need to inspect…
v2.34.6 · audit A · 1,123 stars
auth-web-cloudbase skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/auth-web-cloudbase/SKILL.md · CloudBase Web Authentication Quick Guide for frontend integration after auth-tool has already been checked. Provides…
v2.34.6 · audit B · 1,123 stars
auth-wechat-miniprogram skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/auth-wechat-miniprogram/SKILL.md · CloudBase WeChat Mini Program native authentication guide. This skill should be used when users need mini program…
v2.34.6 · audit A · 1,123 stars
cloud-api-operations skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/cloud-api-operations/SKILL.md · Operate Tencent Cloud control-plane resources (monitoring/alarms, CLB, CAM roles, COS, MySQL, SCF) via cloud APIs when…
v2.34.6 · audit A · 1,123 stars
cloud-functions skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/cloud-functions/SKILL.md · CloudBase function runtime guide for building, deploying, and debugging your own Event Functions or HTTP Functions…
v2.34.6 · audit C · 1,123 stars

Every file in tencentcloudbase/cloudbase-ai-toolkit

Other files named postgresql-best-practices-cloudbase

postgresql-best-practices-cloudbase skill
tencentcloudbase/cloudbase-ai-toolkit · config/.claude/skills/postgresql-best-practices-cloudbase/SKILL.md · CloudBase PostgreSQL access-pattern and slow-query quality guidance. Use when designing how tables are read and…
v2.34.4 · audit A · 1,123 stars
postgresql-best-practices-cloudbase skill
tencentcloudbase/cloudbase-ai-toolkit · config/source/skills/postgresql-best-practices-cloudbase/SKILL.md · CloudBase PostgreSQL access-pattern and slow-query quality guidance. Use when designing how tables are read and…
v2.34.4 · audit A · 1,123 stars
postgresql-best-practices-cloudbase skill
tencentcloudbase/cloudbase-ai-toolkit · plugin/cloudbase/skills/postgresql-best-practices-cloudbase/SKILL.md · CloudBase PostgreSQL access-pattern and slow-query quality guidance. Use when designing how tables are read and…
v2.34.4 · audit A · 1,123 stars

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