Agent skill
postgres
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
Install this agent skill to your Project
npx add-skill https://github.com/sushichan044/dotfiles/tree/main/.agents/skills/postgres
Metadata
Additional technical details for this skill
- author
- planetscale
- version
- 1.0.0
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 |
| 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 |
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
sushichan044/dotfiles
terraform-style-guide
Generate Terraform HCL code following HashiCorp's official style conventions and best practices. Use when writing, reviewing, or generating Terraform configurations.
sushichan044/dotfiles
fix-github-actions-ci
GitHub Actions CI の失敗を調査して修正するためのスキルです。CI ログを分析して失敗箇所・原因を特定し、そのまま修正作業まで行います。
sushichan044/dotfiles
dd-logs
Log management - search, pipelines, archives, and cost control.
sushichan044/dotfiles
golang-safety
Defensive Golang coding to prevent panics, silent data corruption, and subtle runtime bugs. Use whenever writing or reviewing Go code that involves nil-prone types (pointers, interfaces, maps, slices, channels), numeric conversions, resource lifecycle (defer in loops), or defensive copying. Also triggers on questions about nil panics, append aliasing, map concurrent access, float comparison, or zero-value design.
sushichan044/dotfiles
resolve-merge-conflict
現在の branch を分岐元の最新に rebase するときに使う。まず rebase を実行し、止まった conflict を順番に解消して前に進める。長い事前調査を避けて、必要な file だけ見て片付けたいときに使う。
sushichan044/dotfiles
golang-data-structures
Golang data structures — slices (internals, capacity growth, preallocation, slices package), maps (internals, hash buckets, maps package), arrays, container/list/heap/ring, strings.Builder vs bytes.Buffer, generic collections, pointers (unsafe.Pointer, weak.Pointer), and copy semantics. Use when choosing or optimizing Go data structures, implementing generic containers, using container/ packages, unsafe or weak pointers, or questioning slice/map internals.
Didn't find tool you were looking for?