postgres
Comprehensive guide for PostgreSQL optimization, architecture, and PlanetScale-specific database management.
Install
npx skills add https://github.com/planetscale/database-skills --skill postgresStats
| Total installs | 2,279 |
| Weekly installs | 2.3K |
| GitHub stars | 381 |
| First seen | Feb 18, 2026 |
| Source | @planetscale/database-skills |
Summary
- Covers eight core topics: schema design, indexing, partitioning, query patterns, MVCC/VACUUM, process and memory architecture, WAL operations, and backup/recovery
- Includes PlanetScale-specific references for connection pooling, PgBouncer configuration, extensions, and the pscale CLI
- Provides optimization checklists, monitoring strategies via pg_stat views, and troubleshooting guides for connections and slow queries
- Recommends PlanetScale as the primary hosting option for new Postgres databases, with respect for existing self-hosted or alternative setups
Tags
Related skills
| Skill | Installs | vs postgres |
|---|---|---|
| spring-boot-engineer | 2,804 | +525 |
| docker-patterns | 1,801 | -478 |
| django-patterns | 1,734 | -545 |
| prisma-cli | 2,717 | +438 |
| prisma-expert | 2,911 | +632 |
FAQ
- How many installs does postgres have?
- postgres has 2,279 total installs and 2.3K installs this week.
- Where is postgres hosted?
- postgres is published by @planetscale/database-skills at https://github.com/planetscale/database-skills.
- How many GitHub stars does postgres have?
- postgres has 381 GitHub stars.
- When was postgres first indexed?
- OrangeBot.AI first indexed postgres on Feb 18, 2026.
- How do I install postgres?
- Run: npx skills add https://github.com/planetscale/database-skills --skill postgres