postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
Target: Databases. Automatically collected · unverified.
Excerpt from the author’s documentation
Extracted from a fixed version of SKILL.md in its original language. This is the author’s documentation; installation, compatibility and runtime results have not been verified by this site.
Read the original Chinese text
Topics in the source
- PostgreSQL 模式
- 何時啟用
- 快速參考
- 索引速查表
- 資料類型快速參考
- 常見模式
- 反模式偵測
- 設定範本
PostgreSQL 最佳實務快速參考。詳細指南請使用 database-reviewer agent。 撰寫 SQL 查詢或 migrations 設計資料庫 schema 疑難排解慢查詢 實作 Row Level Security 設定連線池 | 查詢模式 | 索引類型 | 範例 | |---------|---------|------| | WHERE col = value | B-tree（預設） | CREATE INDEX idx ON t (col) | | WHERE col > value | B-tree | CREATE INDEX idx ON t (col) | | WHERE a = x AND b > y | 複合 | CREATE INDEX idx ON t (a, b) | | WHERE jsonb @> '{}' | GIN | CREATE INDEX idx ON t USING gin (col) | | WHERE tsv @@ query | GIN | CREATE INDEX idx ON t USING gin (col) | | 時間序列範圍 | BRIN | CREATE INDEX idx ON t USING brin (col) | | 使用情況 | 正確類型 | 避免 | |---------|---------|------| | IDs | bigint | int、隨機 UUID | | 字串 | text | varchar(255) | | 時間戳 | timestamptz | timestamp | | 金額 | numeric(10,2) | float | | 旗標 | boolean | varchar、int | 複合索引順序： 覆蓋索引： 部分索引： RLS 政策（優化）： UPSERT： 游標分頁： 佇列處理： Agent：database-reviewer - 完整資料庫審查工作流程 Skill：clickhouse-io - ClickHouse 分析模式 Skill：backend-patterns - API 和後端模式 -- 基於 Supabase Agent Skills)（MIT 授權）
- Source repository
- affaan-m/ECC
- Source file
- docs/zh-TW/skills/postgres-patterns/SKILL.md
- Fixed revision
- d2ef2680594f9a17526a6e1a2e18b3d242c5d17b
Requirements
- Only the author’s Skill metadata is included. Read the full instructions to check dependencies, licensing and conditions of use.
A small first task
先阅读原作者说明，再决定是否在自己的 AI 工具中使用。
Instructions for your AI tool
- Claude Desktop: resource-specific guide not available yet
- Claude Code: resource-specific guide not available yet
- Cursor: resource-specific guide not available yet
- Codex: resource-specific guide not available yet
Author documentation is not live verification by this site. Without evidence, we do not mark a resource as compatible, safe or free.
Sources and evidence
This record was collected automatically. Its documentation, suitability and runtime behavior have not been manually verified.
Author: affaan-m/ECC · original repository metadata. Documentation review: Not reviewed. Last source check: 2026-11-09T15:01:42.760Z.
Categories are inferred from names, descriptions and paths. They do not establish compatibility.
License and attribution
MIT. Third-party content and copyright remain with their authors. Refer to the original license and terms.
Original license ↗Synchronization, copying and user-reported success do not mark a resource as runtime-tested.
Limitations and notes
- Collecting metadata does not mean this site has installed, adapted, runtime-tested or security-reviewed the resource.