SkillsAdd

neondatabase/postgres-skills · Official

postgres-best-practices

Best practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use when writing SQL, designing database schemas, optimizing queries, or setting up a Postgres database.

All-time #8664 Trending #5170 Hot #5261 First seen Mar 12, 2026
8-week activity · all time api

Installation

$ npx skills add neondatabase/postgres-skills --skill postgres-best-practices
View on skills.sh ↗ GitHub repository ↗

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

supabase-postgres-best-practices Shared topics
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-database-setup Shared topics
prisma/skills

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, Mon…

269.8K installs
prisma-postgres Shared topics
prisma/skills

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, an…

263K installs
prisma-driver-adapter-implementation Shared topics
prisma/skills

Required reference for Prisma ORM 7 SQL driver adapter work.

258.3K installs
prisma-upgrade-v7 Shared topics
prisma/skills

Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.

258.1K installs
prisma-compute Shared topics
prisma/skills

Prisma Compute deployment and hosting guide. Use whenever the user mentions Prisma Compute, `pr…

253.4K installs

Also in this package

Other skills from neondatabase/postgres-skills.

npx skills add neondatabase/postgres-skills
skill-creator 305

Browse all from neondatabase/postgres-skills

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Repository health

Stars 31
License LICENSE
Default branch main
Open issues 1
Status Active

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 3,366 B
  • docs SUMMARY.md 288 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 1,200 installs

SKILL.md

Postgres Best Practices

Guidelines and best practices for working with Postgres, covering schema design, indexing, query optimization, and common pitfalls.

Supported Versions

This skill covers PostgreSQL 14 through 18. Version-specific features are tagged (e.g., [PG15+], [PG18+]); environment-dependent examples identify required privileges, extensions, or multi-node setup.

PostgreSQL provides 5 years of support per major version. Always run the latest minor release.

Version Initial Release End of Life
18 September 2025 November 2030
17 September 2024 November 2029
16 September 2023 November 2028
15 October 2022 November 2027
14 September 2021 November 2026

Source: postgresql.org/support/versioning

References

Area Resource When to Use
Schema Design references/schema-design.md Designing tables, choosing data types, normalizing, partitioning
Indexing references/indexing.md Choosing index types, composite indexes, partial/covering indexes
Query Optimization references/query-optimization.md Reading EXPLAIN ANALYZE, fixing bottlenecks, planner tuning
Query Patterns references/query-patterns.md CTEs, window functions, lateral joins, UPSERT, JSONB, anti-patterns
Performance Diagnostics references/performance-diagnostics.md pg_stat views, lock analysis, VACUUM, connection management
Logical Replication references/logical-replication.md Pub/sub replication, live migrations, CDC
Hot Standby references/hot-standby.md Streaming replication, read replicas, failover
Transaction Isolation references/transaction-isolation.md Isolation levels, lost updates, serialization failures, retry logic
Backup & Restore references/backup-restore.md pgdump/pgrestore, pg_basebackup, PITR, recovery
Security & Roles references/security-roles.md Privileges, RLS, pg_hba.conf, authentication, SSL
Bulk Data Loading references/bulk-loading.md COPY patterns, ETL staging, optimizing large loads, batch ops
Connection Pooling references/connection-pooling.md PgBouncer config, pool modes, prepared statements, sizing
Major Version Upgrades references/major-version-upgrades.md pg_upgrade, logical replication migration, pre/post checklists