postgresql-development-cloudbase

postgresql-development-cloudbase is a skill for Claude Code, Codex from sutchan/Agent-Skills-Hub. It costs 77 tokens per session (7,170 once invoked), scanned A, a copy of postgresql-development-cloudbase, MIT.

A development guide for applications that use CloudBase PostgreSQL, a relational database, including database setup, queries, access rules, and web administration screens.

In plain words
What is it for?
It is for building or debugging CloudBase PostgreSQL apps, setting up schemas, reading and changing data, configuring row-level access rules, adding login-based access, and creating CMS or admin screens.
Why use it?
It helps choose the correct PostgreSQL connection and permission approach instead of mixing it with NoSQL, MySQL, or unrelated APIs.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit It is for building or debugging CloudBase PostgreSQL apps, setting up schemas, reading and changing data, configuring row-level access rules, adding login-based access, and creating CMS or admin screens.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/sutchan/agent-skills-hub/postgresql-development-cloudbase
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 sutchan/Agent-Skills-Hub --skill postgresql-development-cloudbase
Clone the repo
git clone --depth 1 https://github.com/sutchan/Agent-Skills-Hub

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.

agentmods badge for postgresql-development-cloudbase

README.md
[![agentmods](https://agentmods.dev/badge/skills/sutchan/agent-skills-hub/postgresql-development-cloudbase/github.svg)](https://agentmods.dev/skills/sutchan/agent-skills-hub/postgresql-development-cloudbase)
Your own site
<a href="https://agentmods.dev/skills/sutchan/agent-skills-hub/postgresql-development-cloudbase"><img src="https://agentmods.dev/badge/skills/sutchan/agent-skills-hub/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.

agentmods 80×15 button for postgresql-development-cloudbase

Your own site · 80×15
<a href="https://agentmods.dev/skills/sutchan/agent-skills-hub/postgresql-development-cloudbase"><img src="https://agentmods.dev/badge/skills/sutchan/agent-skills-hub/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 7,170 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 97% 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.

ModelPer sessionOnce invoked
Fable 5.1 $0.00077 $0.07170
Opus 5.5 $0.00031 $0.02868
Sonnet 5.5 $0.00015 $0.01434
Haiku 4.5 $0.00008 $0.00717

Measured 1mo ago against content hash 30f81a63316c, 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 1mo ago.

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

97% identical to postgresql-development-cloudbase — 76 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 · 286 lines

How it starts

The opening of the file, as written. The whole thing — 286 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

  • 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 -> 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 · 286 lines

Files

What ships with it

8 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.

  1. 1mo ago First seen · 286 lines · 77 tokens per session scan A 30f81a63316c

Subscribe to this mod's changes

postgresql-development-cloudbase is a skill published in the GitHub repository sutchan/Agent-Skills-Hub (2 stars, last pushed today), licensed MIT. It adds 77 tokens to every session and 7,170 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. It is 97% identical to postgresql-development-cloudbase, differing in 76 lines, and is treated as a copy.

Related

Other skills, from other repositories

erd-expert

Designs entity-relationship schemas for the hotel domain (reservations, guests, rooms, rate plans, folios) on PostgreSQL, following Archipelago International's Sentec platform conventions — hotelid LIST partitioning, naming, and required audit columns. Use when designing a new table or ERD for Sentec PMS, Sentec…

shennawardana23/skillme · 100 tokens

postgres-patterns

Guides PostgreSQL query design, indexing strategy, data types, and row-level security patterns — the query/schema layer, as distinct from the migration-execution safety covered by database-migrations and the hotelid partition-pruning rules covered by postgres-hotel-partitioning. Use when choosing an index type…

shennawardana23/skillme · 95 tokens

golang-database

This skill should be used when the user asks to "configure a Go database connection pool", "use database/sql in Go", "set up pgxpool", "why is my Go app running out of connections", "scan rows into a Go struct", "handle sql.ErrNoRows", or writes Go code that opens, pools, queries, or scans a PostgreSQL/MySQL…

shennawardana23/skillme · 160 tokens

postgres-hotel-partitioning

This skill should be used when the user asks to "write a query for a hotel-partitioned table", "review this SQL for partition safety", "add a hotelid filter", "check partition pruning", "write a migration for a partitioned table", or writes/reviews Go or SQL code touching any PostgreSQL table partitioned by hotelid.…

shennawardana23/skillme · 91 tokens

database-migrations

Guides safe, reversible PostgreSQL schema and data migrations using golang-migrate, Prisma, Drizzle, or Django migrations. Use when creating or altering tables, adding or removing columns or indexes, planning a zero-downtime schema change, or reviewing a migration before it runs against production. For tables…

shennawardana23/skillme · 84 tokens

timescaledb

MANDATORY when working with time-series data, hypertables, continuous aggregates, or compression - enforces TimescaleDB 2.24.0 best practices including lightning-fast recompression, UUIDv7 continuous aggregates, and Direct Compress.

troykelly/claude-skills · 50 tokens