postgres

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.

Jump to install

Repository: mediar-ai/skillhubz
Last source activity: March 1, 2026 at 23:00
Detected SKILL.md language: English
Stars: 7
Forks: 4

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/mediar-ai/skillhubz --skill postgres

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

SKILL.md

Source instructions · Read-only preview

name	postgres
description	PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
license	MIT
metadata	{"author":"planetscale","version":"1.0.0"}

PlanetScale Postgres

Generic Postgres

Topic	Reference	Use 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

Topic	Reference	Use 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

Topic	Reference	Use for
Connection Pooling	references/ps-connection-pooling.md	PgBouncer, pool sizing, pooled vs direct
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

Back to search Back to installation

shar-production-metadata-validation

Validate rights-aware AI-hybrid video-production metadata with SHAR Production's local read-only MCP tool.

2026-09-08

valet-publish

Publish files, folders, and artifacts to the web. Static hosting for HTML sites, images, PDFs, reports, dashboards, and any file type. Use when asked to publish, host, upload, serve, or share work at a live URL. Also use to propose a rendered page when a report, comparison, chart, design document, or status page would work better than terminal text, but do not create or update a remote site until the user asks or agrees. Account publishing gives a permanent, private-by-default URL visible to org members; --anonymous gives a temporary public URL with no account. Use the valet CLI when available and its MCP server when the CLI cannot run. For deploying an AI agent rather than static files, use the `valet` skill instead.

2026-08-18

valet

Use when the user wants to manage Valet agents, channels, connectors, organizations, or environment variables (secrets and plain config) via the valet CLI. Handles creation, deployment, linking, teardown, and all multi-step workflows. Also use when asked to "create an agent", "deploy an agent", "design an agent", "build me an agent that...", "create a connector", "set up a webhook", or anything involving the Valet platform or any request to create and deploy AI agents. Also use when asked to "learn from this session", "capture this workflow", "save this as an agent", "make this repeatable", or when writing SOUL.md files.

2026-08-18

View all from this repository

name	postgres
description	PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
license	MIT
metadata	{"author":"planetscale","version":"1.0.0"}

PlanetScale Postgres

Generic Postgres

Topic	Reference	Use 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

Topic	Reference	Use 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

Topic	Reference	Use for
Connection Pooling	references/ps-connection-pooling.md	PgBouncer, pool sizing, pooled vs direct
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

postgres

Source facts

Install options

Review the source files

PlanetScale Postgres

Generic Postgres

Operations and Architecture

PlanetScale-Specific

More from this repository

PlanetScale Postgres

Generic Postgres

Operations and Architecture

PlanetScale-Specific

More from this repository