AGENT SKILL

postgres

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

License 许可
MIT
最近更新
2026-10-23
Stars
★ 1
Forks
0

01 前言 Front Matter

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

02 资源文件 21

03 SKILL.md 正文

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

04 同仓库更多 Skills

sohelshaik-143
sohelshaik-143/KASUMIO

ui-styling

Create beautiful, accessible user interfaces with shadcn/ui components (built on Radix UI + Tailwind), Tailwind CSS utility-first styling, and canvas-based visual designs. Use when building user interfaces, implementing design systems, creating responsive layouts, adding accessible components (dialogs, dropdowns, forms, tables), customizing themes and colors, implementing dark mode, generating visual designs and posters, or establishing consistent styling patterns across applications.

★ 1
sohelshaik-143
sohelshaik-143/KASUMIO

design

Comprehensive design skill: brand identity, design tokens, UI styling, logo generation (55 styles, Gemini AI), corporate identity program (50 deliverables, CIP mockups), HTML presentations (Chart.js), banner design (22 styles, social/ads/web/print), icon design (15 styles, SVG, Gemini 3.1 Pro), social photos (HTML→screenshot, multi-platform). Actions: design logo, create CIP, generate mockups, build slides, design banner, generate icon, create social photos, social media images, brand identity, design system. Platforms: Facebook, Twitter, LinkedIn, YouTube, Instagram, Pinterest, TikTok, Threads, Google Ads.

★ 1
sohelshaik-143
sohelshaik-143/KASUMIO

design-system

Token architecture, component specifications, and slide generation. Three-layer tokens (primitive→semantic→component), CSS variables, spacing/typography scales, component specs, strategic slide creation. Use for design tokens, systematic design, brand-compliant presentations.

★ 1
sohelshaik-143
sohelshaik-143/KASUMIO

banner-design

Design banners for social media, ads, website heroes, creative assets, and print. Multiple art direction options with AI-generated visuals. Actions: design, create, generate banner. Platforms: Facebook, Twitter/X, LinkedIn, YouTube, Instagram, Google Display, website hero, print. Styles: minimalist, gradient, bold typography, photo-based, illustrated, geometric, retro, glassmorphism, 3D, neon, duotone, editorial, collage. Uses ui-ux-pro-max, frontend-design, ai-artist, ai-multimodal skills.

★ 1
sohelshaik-143
sohelshaik-143/KASUMIO

vercel-react-best-practices

React and Next.js performance optimization guidelines from Vercel Engineering. This skill should be used when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.

★ 1
sohelshaik-143
sohelshaik-143/KASUMIO

prd-creator

Guides creation of comprehensive Product Requirement Documents (PRDs) for software projects through structured questioning and validation, then generates implementation task lists in JSON format. Use when users want to document a software idea, create specifications for development, plan a new application feature/bug, or break down requirements into actionable tasks. Transforms ideas into implementation-ready documents with verifiable pass criteria.

★ 1