2d-games
Free2D game development principles. Sprites, tilemaps, physics, camera.
The English summary is being prepared. Showing the original description.
AxelMrak/ai5Updated Feb 20, 2026
FreePublished on 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.
The English summary is being prepared. Showing the original description.
See how to installFiles included (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 (original)
Review the instructions the agent will receive before you install.
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
Reviews
No reviews yet. Tell others what you thought.
Comments
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
More skills from this repository
3d-games
Free3D game development principles. Rendering, shaders, physics, cameras.
The English summary is being prepared. Showing the original description.
AxelMrak/ai5Updated Feb 20, 2026
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.
The English summary is being prepared. Showing the original description.
AxelMrak/ai5Updated Feb 20, 2026
ab-test-setup
FreeStructured guide for setting up A/B tests with mandatory gates for hypothesis, metrics, and execution readiness.
The English summary is being prepared. Showing the original description.
AxelMrak/ai5Updated Feb 20, 2026
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.
The English summary is being prepared. Showing the original description.
AxelMrak/ai5Updated Feb 20, 2026
Use when you need to address review or issue comments on an open GitHub Pull Request using the gh CLI.
The English summary is being prepared. Showing the original description.
AxelMrak/ai5Updated Feb 20, 2026