postgres-best-practices
作者： neondatabase
使用 Postgres 的最佳實踐與指南，涵蓋資料表設計、索引策略、查詢最佳化、遷移與常見陷阱。運用…
npx skills add https://github.com/neondatabase/postgres-skills --skill postgres-best-practicesPostgres 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 |
來自 neondatabase 的更多技能
claimable-postgres
neondatabase
即時 Postgres 資料庫，適用於本地開發、展示、原型設計與測試環境。無需註冊帳號。資料庫在 72 小時後到期，除非認領至 Neon 帳號。
neon
neondatabase
Neon平台概述，涵蓋Postgres、Auth、Data API，以及新服務：物件儲存、計算函數和AI閘道。每當提及「Neon」時，用於概述如何操作Neon及入門方式。否則，個別功能即為觸發條件：「物件儲存」或「S3相容儲存」、「無伺服器函數」、「背景任務」或「在資料庫附近執行程式碼」、「AI閘道」、「LLM代理」、「模型路由」或「呼叫LLM」→...
apidatabasedevelopment
plugin-manager
neondatabase
管理此儲存庫在 Cursor 和 Claude Code 中的插件結構與配置。在建立、更新或審查插件資料夾時使用…
skill-creator
neondatabase
建立有效技能的指南。當使用者想要建立新技能（或更新現有技能）以擴展 Claude 的功能時，應使用此技能。
using-neon
neondatabase
使用 Neon Serverless Postgres 的指南與最佳實踐。涵蓋入門、使用 Neon 進行本地開發、選擇連線方式、Neon…
neon-js-react
neondatabase
在 React 應用程式（Vite、CRA）中設定完整的 Neon SDK，包含驗證與資料庫查詢功能。建立型別化客戶端、產生資料庫型別，並配置…
neon-postgres-egress-optimizer
neondatabase
引導使用者診斷並修復應用端查詢模式，這些模式會導致從其 Postgres 資料庫傳輸過多資料（出口流量）。大多數高額出口帳單來自應用程式擷取超出實際使用的資料。
neon-postgres-branches
neondatabase
此技能的成果應為已建立的 Neon 分支（若無法建立，則提供明確且可執行的下一步）。選擇正確的分支類型，然後透過 MCP 或 CLI 執行分支建立。