postgres-best-practices

Name: postgres-best-practices
Author: neondatabase

github.com/neondatabaseData & databases531.9k installsUpdated 9w ago

About postgres-best-practices

postgres-best-practices is a practical guide for PostgreSQL users, covering versions 14 through 18. Its topic-based references address database design, query performance, operations, security, and migrations.

Key features

01Covers PostgreSQL 14 through 18
02Guidance on schema design and indexing
03Query optimization and common patterns
04Performance diagnostics and connection pooling
05Replication, backup, and recovery guidance
06Security, upgrades, and bulk loading

Use cases

01Design tables, data types, and partitions
02Analyze EXPLAIN ANALYZE and diagnose bottlenecks
03Plan logical replication or a major-version upgrade
04Configure privileges, backups, and connection pooling

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/neondatabase/postgres-skills --skill postgres-best-practices

After installing, type/postgres-best-practicesin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

references/

backup-restore.md

bulk-loading.md

connection-pooling.md

hot-standby.md

indexing.md

logical-replication.md

major-version-upgrades.md

performance-diagnostics.md

query-optimization.md

query-patterns.md

schema-design.md

security-roles.md

transaction-isolation.md

Details

From the project README

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`	pg_dump/pg_restore, 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

Comments

Markdown supported

Details

Author: neondatabase
Repository: neondatabase/postgres-skills
Category: Data & databases
Installs: 1,898
GitHub stars: 53

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).