2d-games
免费2D game development principles. Sprites, tilemaps, physics, camera.
中文简介正在准备中。当前显示原文说明。
AxelMrak/ai52026年2月20日 更新
免费在 GitHub 公开
supabase-postgres-best-practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
中文简介正在准备中。当前显示原文说明。
查看安装方法包含的文件（37）
- SKILL.md2.5 KB
- AGENTS.md2.1 KB
- README.md3.1 KB
- references/_contributing.md4.1 KB
- references/_sections.md1.6 KB
- references/_template.md1.0 KB
- references/advanced-full-text-search.md1.4 KB
- references/advanced-jsonb-indexing.md1.4 KB
- references/conn-idle-timeout.md1.3 KB
- references/conn-limits.md1.3 KB
- references/conn-pooling.md1.3 KB
- references/conn-prepared-statements.md1.5 KB
- references/data-batch-inserts.md1.3 KB
- references/data-n-plus-one.md1.3 KB
- references/data-pagination.md1.3 KB
- references/data-upsert.md1.4 KB
- references/lock-advisory.md1.5 KB
- references/lock-deadlock-prevention.md1.8 KB
- references/lock-short-transactions.md1.3 KB
- references/lock-skip-locked.md1.3 KB
- references/monitor-explain-analyze.md1.4 KB
- references/monitor-pg-stat-statements.md1.4 KB
- references/monitor-vacuum-analyze.md1.5 KB
- references/query-composite-indexes.md1.4 KB
- references/query-covering-indexes.md1.3 KB
- references/query-index-types.md1.5 KB
- references/query-missing-indexes.md1.2 KB
- references/query-partial-indexes.md1.3 KB
- references/schema-constraints.md1.8 KB
- references/schema-data-types.md1.4 KB
- references/schema-foreign-key-indexes.md1.6 KB
- references/schema-lowercase-identifiers.md1.7 KB
- references/schema-partitioning.md1.5 KB
- references/schema-primary-keys.md1.8 KB
- references/security-privileges.md1.5 KB
- references/security-rls-basics.md1.3 KB
- references/security-rls-performance.md1.5 KB
SKILL.md（原文）
安装前可以查看交给 AI 代理的指令内容。
Supabase Postgres Best Practices
Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.
When to Apply
Reference these guidelines when:
- Writing SQL queries or designing schemas
- Implementing indexes or query optimization
- Reviewing database performance issues
- Configuring connection pooling or scaling
- Optimizing for Postgres-specific features
- Working with Row-Level Security (RLS)
Rule Categories by Priority
| Priority | Category | Impact | Prefix |
|---|---|---|---|
| 1 | Query Performance | CRITICAL | query- |
| 2 | Connection Management | CRITICAL | conn- |
| 3 | Security & RLS | CRITICAL | security- |
| 4 | Schema Design | HIGH | schema- |
| 5 | Concurrency & Locking | MEDIUM-HIGH | lock- |
| 6 | Data Access Patterns | MEDIUM | data- |
| 7 | Monitoring & Diagnostics | LOW-MEDIUM | monitor- |
| 8 | Advanced Features | LOW | advanced- |
How to Use
Read individual rule files for detailed explanations and SQL examples:
references/query-missing-indexes.md
references/schema-partial-indexes.md
references/_sections.md
Each rule file contains:
- Brief explanation of why it matters
- Incorrect SQL example with explanation
- Correct SQL example with explanation
- Optional EXPLAIN output or metrics
- Additional context and references
- Supabase-specific notes (when applicable)
References
评价
还没有评价。欢迎分享你的使用感受。
评论
无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。
还没有评论。来写第一条吧。
同一仓库的技能
3d-games
免费3D game development principles. Rendering, shaders, physics, cameras.
中文简介正在准备中。当前显示原文说明。
AxelMrak/ai52026年2月20日 更新
Expert in building 3D experiences for the web - Three.js, React Three Fiber, Spline, WebGL, and interactive 3D scenes. Covers product configurators, 3D portfolios, immersive websites, and bringing depth to web experiences. Use when: 3D website, three.js, WebGL, react three fiber, 3D experience.
中文简介正在准备中。当前显示原文说明。
AxelMrak/ai52026年2月20日 更新
Structured guide for setting up A/B tests with mandatory gates for hypothesis, metrics, and execution readiness.
中文简介正在准备中。当前显示原文说明。
AxelMrak/ai52026年2月20日 更新
This skill should be used when the user asks to "attack Active Directory", "exploit AD", "Kerberoasting", "DCSync", "pass-the-hash", "BloodHound enumeration", "Golden Ticket", "Silver Ticket", "AS-REP roasting", "NTLM relay", or needs guidance on Windows domain penetration testing.
中文简介正在准备中。当前显示原文说明。
AxelMrak/ai52026年2月20日 更新
Use when you need to address review or issue comments on an open GitHub Pull Request using the gh CLI.
中文简介正在准备中。当前显示原文说明。
AxelMrak/ai52026年2月20日 更新