56 results available
Sign in
Skills directory

postgres

planetscale

·

Last changed
Hardened

This skill has been hardened by Chainguard

Last changed

This version passed the hardening gate. Hardening updated the skill content and independently checked the resulting changes. Classified findings before hardening: 8. Classified findings closed: 2. Classified findings remaining: 6. Unclassified scanner findings remaining: 0. Review findings closed: 0. Review findings remaining: 15.

Open before hardening

1

Medium

7

Low
Open after hardening

1

Medium

5

Low
Expand
File
Group
Subtype
Severity
Status
references/query-patterns.md

Excessive Agency & Rogue Autonomy

—

Medium
Open
references/ps-insights.md

Prompt Injection

Third-party content as instructions

Low
Open
SKILL.md

Prompt Injection

Third-party content as instructions

Low
Open
references/ps-insights.md

Malicious Code & Command Execution

—

Low
Open
references/partitioning.md

Tool & MCP Manipulation

MCP configuration abuse

Low
Open
references/monitoring.md

Malicious Code & Command Execution

—

Low
Closed
references/monitoring.md

Supply Chain & Install-Time Trust

Install-time download and execute

Low
Closed
references/ps-insights.md

Supply Chain & Install-Time Trust

Install-time download and execute

Low
Open

8 findings

SKILL.md

PlanetScale Postgres

Generic Postgres

TopicReferenceUse for

Schema Design

references/schema-design.md

Tables, primary keys, data types, foreign keys

Indexing

references/indexing.md

Index types, composite indexes, performance

Index Optimization

references/index-optimization.md

Unused/duplicate index queries, index audit

Partitioning

references/partitioning.md

Large tables, time-series, data retention

Query Patterns

references/query-patterns.md

SQL anti-patterns, JOINs, pagination, batch queries

Optimization Checklist

references/optimization-checklist.md

Pre-optimization audit, cleanup, readiness checks

MVCC and VACUUM

references/mvcc-vacuum.md

Dead tuples, long transactions, xid wraparound prevention

Operations and Architecture

TopicReferenceUse for

Process Architecture

references/process-architecture.md

Multi-process model, connection pooling, auxiliary processes

Memory Architecture

references/memory-management-ops.md

Shared/private memory layout, OS page cache, OOM prevention

MVCC Transactions

references/mvcc-transactions.md

Isolation levels, XID wraparound, serialization errors

WAL and Checkpoints

references/wal-operations.md

WAL internals, checkpoint tuning, durability, crash recovery

Replication

references/replication.md

Streaming replication, slots, sync commit, failover

Storage Layout

references/storage-layout.md

PGDATA structure, TOAST, fillfactor, tablespaces, disk mgmt

Monitoring

references/monitoring.md

pg_stat views, logging, pg_stat_statements, host metrics

Backup and Recovery

references/backup-recovery.md

pg_dump, pg_basebackup, PITR, WAL archiving, backup tools

PlanetScale-Specific

TopicReferenceUse for

Connection Pooling

references/ps-connection-pooling.md

PgBouncer, pool sizing, pooled vs direct

PgBouncer Config

references/pgbouncer-configuration.md

default_pool_size, max_user_connections, pool limits

Extensions

references/ps-extensions.md

Supported extensions, compatibility

Connections

references/ps-connections.md

Connection troubleshooting, drivers, SSL

Insights

references/ps-insights.md

Slow queries, MCP server, pscale CLI

CLI Commands

references/ps-cli-commands.md

pscale CLI reference, branches, deploy requests, auth

CLI API Insights

references/ps-cli-api-insights.md

Query insights via pscale api, schema analysis

Install

Install with chainctl
chainctl skill install public/planetscale/postgres:latest
Get started with chainctl
View source

Harden your own skills

Bring Chainguard's hardening pipeline to your first-party skills — custom rulesets, automated remediation, full audit trail.

Provenance

Upstream sourcehttps://github.com/planetscale/database-skills
Upstream commit03694ddca75eace792f40f04799f3c3e7a6ff9ec
OCI reference

skills.cgr.dev/public/github.com/planetscale/skills/postgres:latest

License

MIT

Files

HARDENING.md

LICENSE

SKILL.md

references/backup-recovery.md

references/index-optimization.md

references/indexing.md

references/memory-management-ops.md

references/monitoring.md

references/mvcc-transactions.md

references/mvcc-vacuum.md

references/optimization-checklist.md

references/partitioning.md

references/pgbouncer-configuration.md

references/process-architecture.md

references/ps-cli-api-insights.md

references/ps-cli-commands.md

references/ps-connection-pooling.md

references/ps-connections.md

references/ps-extensions.md

references/ps-insights.md

references/query-patterns.md

references/replication.md

references/schema-design.md

references/storage-layout.md

references/wal-operations.md

The trusted source for open source

Talk to an expert
PrivacyTerms

Product

Chainguard ContainersChainguard LibrariesChainguard VMsChainguard OS PackagesChainguard ActionsChainguard Agent SkillsIntegrationsPricing

Solutions

FedRAMPPCI DSSCMMC 2.0SOC 2Golden ImagesCVE RemediationPublic SectorStartups

Customers

Customer StoriesChainguard Reviews

Resources

Events & WebinarsSupply Chain Security 101Chainguard CoursesDocumentationTrust CenterChainguard Slack Community

Company

About UsBlogOpen Source LeadershipPartnersNewsroomCareersLegal
© 2026 Chainguard, Inc. All Rights Reserved.
Chainguard® and the Chainguard logo are registered trademarks of Chainguard, Inc. in the United States and/or other countries.
The other respective trademarks mentioned on this page are owned by the respective companies and use of them does not imply any affiliation or endorsement.