Postgres

What it does

The guide covers indexing, connection management and architecture, with additional provider-oriented references. That separation helps avoid applying a hosted-platform command to a self-managed instance or assuming a general Postgres recommendation has identical operational consequences everywhere.

Best for

Developers reviewing Postgres performance, schema design or connection problems in a known environment.

Tradeoffs and requirements

Query plans depend on data distribution, statistics and configuration. Maintenance and migration operations can affect locks and availability, and a hosted connection pool may impose semantics different from a direct session to the database.

Unknown; inspect source requirements and supporting scripts.

Install from the source

Inspect the pinned source snapshot and its supporting files first. The command selects this skill through the open-source skills CLI. Node.js and agent-specific setup may be required. Installation can download code. Catalog ingestion never executes skill instructions or install scripts.

npx skills add https://github.com/planetscale/database-skills/tree/f6ed002d03084cb39c01d1d58904d47a36f5322a/skills/postgres --skill postgres

Review pinned skill folder ↗ · CLI documentation ↗

After source review, use npx skills check and npx skills update to inspect and apply upstream updates. Re-check changed instructions before running them.

Safety & review signals

Static review only. This is not a security audit or a guarantee of safety.

SKILL.md text only; scripts, dependencies and runtime behavior not audited.

• Network Access — review the source context.

Allowed tools declaration: Unknown. Runtime permissions and network behavior: Unknown.

Offline package integrity

A temporary folder-copy check, not an agent installation or runtime safety verdict.

23 files copied and checksummed from this exact source snapshot. No package code or installation scripts were executed.

Inventory SHA-256: d8fb0b75f61a421187112fd00c629969207094e10f29ca75fe08db0218c203c9

AI Craft Pad Skill Score

85/100 · Metadata coverage 100% · Model 1.0

Scores summarize observable discovery signals. Popularity and repository activity apply to the whole repository. Unknown runtime safety earns no certification.

Documentation

98/100

98

Maintenance

100/100

100

License Clarity

100/100

100

Repository Health

100/100

100

Compatibility Evidence

80/100

80

Popularity

52/100

52

Originality

80/100

80

Static Safety

60/100

60

Suggested workflow

Identify the server and hosting model, inspect a representative plan and gather relevant connection and workload evidence. Propose a focused query, index or pooling change, preserving transaction assumptions and a safe method for applying any persistent modification.

How to judge the result

Compare result correctness and measured latency, inspect concurrency and transaction behavior and repeat the same workload after the change. Record provider-specific steps explicitly and avoid inferring production improvement from a small local dataset or an estimated plan alone.