What is postgresql-development-cloudbase?

A development guide for apps that use CloudBase PostgreSQL, a hosted PostgreSQL database service. It covers database setup, queries, JavaScript database operations, permissions, login, and admin content management.

Use it for CloudBase PostgreSQL schemas, data access, row-level permissions, username-and-password authentication, and web CMS or admin CRUD screens.

It gives agents the relevant instructions for building or debugging CloudBase apps that store business data in PostgreSQL.

postgresql-development-cloudbase — Skill by TencentCloudBase

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add TencentCloudBase/cloudbase-skills --skill postgresql-development-cloudbase

Clone the repo

git clone --depth 1 https://github.com/TencentCloudBase/cloudbase-skills

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/tencentcloudbase/cloudbase-skills/postgresql-development-cloudbase/github.svg)](https://agentmods.dev/skills/tencentcloudbase/cloudbase-skills/postgresql-development-cloudbase)

Your own site

<a href="https://agentmods.dev/skills/tencentcloudbase/cloudbase-skills/postgresql-development-cloudbase"><img src="https://agentmods.dev/badge/skills/tencentcloudbase/cloudbase-skills/postgresql-development-cloudbase/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/tencentcloudbase/cloudbase-skills/postgresql-development-cloudbase"><img src="https://agentmods.dev/badge/skills/tencentcloudbase/cloudbase-skills/postgresql-development-cloudbase.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 77 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 8,243 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin 100% copy Near-identical to another mod in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00077	$0.08243
Opus 5.5	$0.00031	$0.03297
Sonnet 5.5	$0.00015	$0.01649
Haiku 4.5	$0.00008	$0.00824

Measured today against content hash f2f14418cf0f, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

postgresql-development-cloudbase scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured today.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

This is a copy

100% identical to postgresql-development-cloudbase — 0 lines differ, which has more behind it and is treated as the original. This page carries a canonical link to it rather than competing with it.

skills/cloudbase/references/postgresql-development-cloudbase/SKILL.md · 340 lines

How it starts

The opening of the file, as written. The whole thing — 340 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Sibling skills (local only)

Sibling CloudBase skills ship beside this skill. Use local relative paths such as ../auth-tool-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.

CloudBase PostgreSQL Development

Activation Contract

Use this first when

The task says CloudBase PG, PostgreSQL, Postgres, PG mode, RLS, JS SDK v3 PostgreSQL, app.rdb(), queryPgDatabase, or managePgDatabase.
A Web app or CMS must persist business data in CloudBase PostgreSQL instead of NoSQL or MySQL.

Then also read

Access-pattern design or slow-query work -> ../postgresql-best-practices-cloudbase/SKILL.md
Web auth provider readiness -> ../auth-tool-cloudbase/SKILL.md
Web login implementation -> ../auth-web-cloudbase/SKILL.md
General Web implementation and verification -> ../web-development/SKILL.md
Browser storage upload -> ../cloud-storage-web/SKILL.md
Raw HTTP API details only when SDK coverage is blocked -> ../http-api-cloudbase/SKILL.md
PG reference index -> references/index.md
PG mode overview -> references/pg-mode-overview.md
Auth / GRANT / RLS details -> references/auth-and-rls.md
End-to-end PG app closure -> references/app-workflow.md
PG storage details — MUST read before writing any bucket / upload / URL code -> references/storage-pg.md
HTTP API fallback -> references/http-api.md
Troubleshooting -> references/troubleshooting.md

Do NOT use first

relational-database-mcp-cloudbase / queryMysqlDatabase / manageMysqlDatabase: those are MySQL-oriented.
cloudbase-document-database-web-sdk / collection APIs for business data that must live in CloudBase PG.

Required Flow

🚨 CRITICAL: PG mode API is NOT the same as NoSQL

CloudBase PG (app.rdb(), app.storage.from('bucket')) uses different API method names than CloudBase NoSQL (app.database(), app.uploadFile()). Low-capability models often paste legacy NoSQL/auth snippets from training; reject that path immediately. If this task is PG-backed, do not write app.database(), db.collection(...), app.uploadFile(), getLoginState(), or route guards based on auth.getUser(). Use app.rdb(), PG storage v3, and auth.getSession() instead. If you are used to writing .where(), .orderBy(), .count() from other ORMs or NoSQL — stop and read the table below.

Read the full file on GitHub · 340 lines

Files

What ships with it

10 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

today Changed · +1 lines f2f14418cf0f
3d ago Changed 7550fdca5336
7d ago Changed · +1 lines 5a8edcc8f290
16d ago Changed 723367328eef
25d ago Changed de6f23cdef1b
26d ago Changed · -1 lines eda5aeeb69ba
1mo ago Changed · +1 lines 1ebf97112963
1mo ago Changed 3599cc092cb4
1mo ago Changed 9475b403da1e
1mo ago First seen · 338 lines · 77 tokens per session scan A 1014e8459178

Subscribe to this mod's changes

postgresql-development-cloudbase is a skill published in the GitHub repository TencentCloudBase/cloudbase-skills (36 stars, last pushed today), licensed MIT. It adds 77 tokens to every session and 8,243 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. It is 100% identical to postgresql-development-cloudbase, differing in 0 lines, and is treated as a copy.

Databases PostgreSQL

alloydb-basics

Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database operations. Use when creating, configuring, or administering AlloyDB databases. Do NOT use for general PostgreSQL instances (e.g. Cloud SQL) or other GCP databases.

google/skills · 72 tokens

postgresql-table-design

Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features.

wshobson/agents · 37 tokens

db-repair

Auto-fix gbrain's Postgres access so the brain stays available. When any gbrain command or MCP tool result carries a GBRAINDBACCESS marker (or an operator reports the brain database is down), run the hardcoded gbrain db-repair ladder: diagnose, apply the safe tier, verify. The action is ALWAYS the hardcoded command …

garrytan/gbrain · 96 tokens

dsql

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL and PostgreSQL-to-DSQL schema conversion, foreign key…

awslabs/agent-plugins · 246 tokens

volcengine-rds-postgresql

A tool for operating PostgreSQL databases hosted by Volcano Engine's managed database service. PostgreSQL is a relational database used to store structured application data.

bytedance/agentkit-samples · 63 tokens

analyzing-insights-across-teams

Analyze PostHog insights, dashboards, or teams beyond the current project by querying the prod Postgres replicas synced into the dogfood data warehouse (US project 2, "PostHog App + Website"). Use when asked to analyze insights across all teams or projects, another team's insights, or fleet-wide insight/dashboard…

PostHog/posthog-foss · 115 tokens