postgres

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

Ir a la instalación

Repositorio: mediar-ai/skillhubz
Última actividad en el origen: 1 de marzo de 2026 a las 23:00
Idioma detectado de SKILL.md: inglés
Estrellas: 7
Forks: 4

Opciones de instalación

De forma predeterminada está seleccionado el prompt que primero revisa el origen. Puedes cambiar a un comando directo o descargar una copia local.

Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.

Un comando directo omite el prompt de revisión. Revisa el origen antes de ejecutarlo.

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

El comando permanece en una sola línea. Desplázate horizontalmente para revisarlo antes de copiarlo.

¿Prefieres una copia local? Descarga los archivos que SkillsMP tiene disponibles ahora.

Revisa los archivos de origen

Lee SKILL.md y los archivos complementarios que muestra SkillsMP antes de decidir si quieres instalarlo.

SKILL.md

Instrucciones de origen · Vista previa de solo lectura

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

Volver a la búsqueda Volver a la instalación

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

Ver todos los de este repositorio

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

Datos de origen

Opciones de instalación

Revisa los archivos de origen

PlanetScale Postgres

Generic Postgres

Operations and Architecture

PlanetScale-Specific

Más de este repositorio

PlanetScale Postgres

Generic Postgres

Operations and Architecture

PlanetScale-Specific

Más de este repositorio