What is postgres?
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases. Source: planetscale/database-skills.
·postgres
</>
postgres
✓PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
Installation
How to Install postgres
Quickly install postgres AI skill to your development environment via command line
- Open Terminal: Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.)
- Run Installation Command: Copy and run this command: npx skills add https://github.com/planetscale/database-skills --skill postgres
- Verify Installation: Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
Source: planetscale/database-skills.
SKILL.md
View raw| 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 |
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases. Source: planetscale/database-skills.
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/planetscale/database-skills --skill postgres- Category
- </>Dev Tools
- Verified
- ✓
- First Seen
- 2026-02-18
- Updated
- 2026-03-10
Quick answers
How do I install postgres?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/planetscale/database-skills --skill postgres Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
Where is the source repository?
https://github.com/planetscale/database-skills
Details
- Category
- </>Dev Tools
- Source
- skills.sh
- First Seen
- 2026-02-18