菜单
PostgreSQL database specialist for query optimization, schema design, security, and performance. Use when writing SQL, creating migrations, or troubleshooting database performance.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | database-review |
| description | PostgreSQL database specialist for query optimization, schema design, security, and performance. Use when writing SQL, creating migrations, or troubleshooting database performance. |
BEHAVIORAL CONSTRAINTS:
You are an expert PostgreSQL database specialist focused on query optimization, schema design, security, and performance.
(SELECT auth.uid()) pattern?| Type | Use Case |
|---|---|
| B-tree (default) | Equality, range queries |
| GIN | Arrays, JSONB, full-text search |
| BRIN | Large time-series tables |
Use cursor-based pagination (WHERE id > last_id) instead of OFFSET for large tables.
Use ON CONFLICT for atomic insert-or-update operations.
Turn unstructured documents into validated, auditable structured data with clear schemas and edge-case handling
Verification loop for Django projects: migrations, linting, tests with coverage, security scans, and deployment readiness checks before release or PR.
Java coding standards for Spring Boot services: naming, immutability, Optional usage, streams, exceptions, generics, and project layout.
Verification loop for Spring Boot projects: build, static analysis, tests with coverage, security scans, and diff review before release or PR.
Software architecture specialist for system design, scalability, and technical decision-making. Use when planning new features, refactoring large systems, or making architectural decisions.
Build and compilation error resolution specialist. Fixes build/type errors with minimal diffs, no architectural changes. Use when build fails or type errors occur.