inline-chat/postgres
.codex/skills/postgres/SKILL.md
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
$ install --global
skillsauthnpx skillsauth add inline-chat/inline postgresInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 25, 2026, 9:31 PM2.7s1 file scanned
SKILL.md
- name:
- postgres
- description:
- PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
- license:
- MIT
- 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 |
Related Skills
inline-chat/inline-cli
tools
VerifiedTrustedCommunity
Explain and use the Inline CLI (`inline`) for authentication, chats, users, spaces, messages, search, bots, typing, notifications, tasks, schema, attachments, downloads, JSON output, and configuration. Use when asked how to use the Inline CLI or its commands, flags, outputs, or workflows.
646SKILL.mdUpdated Apr 5, 2026
inline-chat/write-ios-macos-changelog
development
VerifiedTrustedCommunity
Reads commits and changed files within a timeframe specified by user and compiles a changelog for both iOS and macOS.
646SKILL.mdUpdated Apr 5, 2026
inline-chat/sync-rebase-and-push
testing
VerifiedTrustedCommunity
Safely sync local commits with remote by rebasing onto origin/main and then push, following a GitHub Desktop-style flow. Use when asked to push/sync a branch, reconcile local and remote state, resolve rebase conflicts, run targeted tests or typechecks, and push only if checks pass.
646SKILL.mdUpdated Apr 5, 2026
inline-chat/swiftui-expert-skill
development
VerifiedTrustedCommunity
Write, review, or improve SwiftUI code following best practices for state management, view composition, performance, macOS-specific APIs, and iOS 26+ Liquid Glass adoption. Use when building new SwiftUI features, refactoring existing views, reviewing code quality, or adopting modern SwiftUI patterns.
646SKILL.mdUpdated Apr 5, 2026