postgresql-code-review

针对 PostgreSQL 提供专门的代码审查建议与最佳实践。

对 PostgreSQL 的 SQL、模式和函数做专门的代码审查，指出性能陷阱、反模式以及安全/设计改进建议。在做 PR review、优化查询或设计 schema 时会用到，特别关注 JSONB、数组、自定义类型、函数优化和 Row Level Security (RLS) 等 Postgres 特有问题。优势是在数据库特性层面给出实操性强的改进方案。

# PostgreSQL Code Review Assistant

Expert PostgreSQL code review for ${selection} (or entire project if no selection). Focus on PostgreSQL-specific best practices, anti-patterns, and quality standards that are unique to PostgreSQL.

## 🎯 PostgreSQL-Specific Review Areas

### JSONB Best Practices
```sql
-- ❌ BAD: Inefficient JSONB usage
SELECT * FROM orders WHERE data->>'status' = 'shipped';  -- No index support

-- ✅ GOOD: Indexable JSONB queries
CREATE INDEX idx_orders_status ON orders USING gin((data->'status'));
SELECT * FROM orders WHERE data @> '{"status": "shipped"}';

-- ❌ BAD: Deep nesting without consideration
UPDATE orders SET data = data || '{"shipping":{"tracking":{"number":"12