Skip to content
Back to skills

Postgres Best Practices

ASecurity

Enforces Supabase and Neon Postgres 8-category best practices covering schema design, zero-downtime migrations, RLS security, indexing, EXPLAIN query plans, and pooling.

  • 2 stars
  • 0 votes
  • 0 copies
  • 0 views
  • Added November 18, 2026
ai-agentsgosqldatabasesecurity

Security analysis

A100/100

Scanned November 18, 2026

npx -y skills add Binbin-miao/workbuddy-expert-team --skill postgres-best-practices --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Postgres Best Practices?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Postgres Best Practices
[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/binbin-miao-postgres-best-practices/badge)](https://www.skillsdirectory.com/skills/binbin-miao-postgres-best-practices)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro
SKILL.md
---
name: postgres-best-practices
description: "Enforces Supabase and Neon Postgres 8-category best practices covering schema design, zero-downtime migrations, RLS security, indexing, EXPLAIN query plans, and pooling."
---

# /postgres-best-practices — 数据库 Schema、零停机迁移、RLS 安全与慢查询优化手册

融合 `supabase/agent-skills` 与 `neondatabase/postgres-skills`,适用于 PostgreSQL 及各类关系型数据库:

## 八大数据库工程铁律
1. **精确类型与约束**:时间统一用 `timestamptz`;金额用 `numeric` 或整数最小货币单位;主键优先 `bigint identity` 或 `UUIDv7`。
2. **零停机安全迁移**:大表建索引使用 `CONCURRENTLY`;分步新增非空约束(`NOT VALID` → `VALIDATE`);迁移设置 `lock_timeout`。
3. **多租户隔离与 RLS 测试**:多租户表强制校验租户边界,并编写跨租户越权访问被拒绝的反向回归测试。
4. **外键与复合索引**:所有外键列必须建索引;复合索引遵循“等值列在前、范围/排序列在后”,高频过滤使用 Partial Index。
5. **消灭 N+1 与深分页慢查询**:严禁循环内查库;大数据集分页采用基于游标的 Keyset Pagination 取代大 `OFFSET`;结合 `EXPLAIN (ANALYZE, BUFFERS)` 实测优化。
6. **短事务原则**:严禁在数据库事务块内发起外部 HTTP 请求、文件上传或大模型调用。
7. **并发原子写入**:状态流转或扣减采用原子条件更新或 `FOR UPDATE SKIP LOCKED`;幂等写入采用 `ON CONFLICT`。
8. **向量与队列扩展**:合理配置 `pgvector` HNSW 索引与队列消费幂等性。

Attribution

Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.

View all in ai-agents →

Comments

Loading comments…

Newsletter

Get the weekly list of safe new skills, and the ones we pulled.