Supabase Postgres Best Practices
davila7/claude-code-templates/cli-tool/components/skills/database/supabase-postgres-best-practicesby davila78da17d671b6fMIT32K starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated today
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| AGENTS.md | 43.9 KB | text/markdown |
| metadata.json | 818 B | application/json |
| README.md | 3 KB | text/markdown |
| rules/advanced-full-text-search.md | 1.4 KB | text/markdown |
| rules/advanced-jsonb-indexing.md | 1.4 KB | text/markdown |
| rules/conn-idle-timeout.md | 1.3 KB | text/markdown |
| rules/conn-limits.md | 1.3 KB | text/markdown |
| rules/conn-pooling.md | 1.3 KB | text/markdown |
| rules/conn-prepared-statements.md | 1.5 KB | text/markdown |
| rules/_contributing.md | 4 KB | text/markdown |
| rules/data-batch-inserts.md | 1.3 KB | text/markdown |
| rules/data-n-plus-one.md | 1.3 KB | text/markdown |
| rules/data-pagination.md | 1.3 KB | text/markdown |
| rules/data-upsert.md | 1.4 KB | text/markdown |
| rules/lock-advisory.md | 1.5 KB | text/markdown |
| rules/lock-deadlock-prevention.md | 1.8 KB | text/markdown |
| rules/lock-short-transactions.md | 1.3 KB | text/markdown |
| rules/lock-skip-locked.md | 1.3 KB | text/markdown |
| rules/monitor-explain-analyze.md | 1.4 KB | text/markdown |
| rules/monitor-pg-stat-statements.md | 1.4 KB | text/markdown |
| rules/monitor-vacuum-analyze.md | 1.5 KB | text/markdown |
| rules/query-composite-indexes.md | 1.4 KB | text/markdown |
| rules/query-covering-indexes.md | 1.3 KB | text/markdown |
| rules/query-index-types.md | 1.4 KB | text/markdown |
| rules/query-missing-indexes.md | 1.2 KB | text/markdown |
| rules/query-partial-indexes.md | 1.3 KB | text/markdown |
| rules/schema-data-types.md | 1.4 KB | text/markdown |
| rules/schema-foreign-key-indexes.md | 1.6 KB | text/markdown |
| rules/schema-lowercase-identifiers.md | 1.7 KB | text/markdown |
| rules/schema-partitioning.md | 1.5 KB | text/markdown |
| rules/schema-primary-keys.md | 1.8 KB | text/markdown |
| rules/_sections.md | 1.6 KB | text/markdown |
| rules/security-privileges.md | 1.5 KB | text/markdown |
| rules/security-rls-basics.md | 1.3 KB | text/markdown |
| rules/security-rls-performance.md | 1.5 KB | text/markdown |
| rules/_template.md | 1 KB | text/markdown |
| SKILL.md | 1.8 KB | text/markdown |
Source and attribution
Source:davila7/claude-code-templatesincli-tool/components/skills/database/supabase-postgres-best-practicesat commit8da17d6
License: MIT
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from davila7/claude-code-templates
React Best Practices
davila7
A React and Next.js performance guide with 40+ rules on waterfalls, bundles, rendering and re-renders.
Web Performance Optimization
davila7
Guides developers through measuring and fixing web performance issues such as Core Web Vitals, bundle size, images and caching.
Find Bugs
davila7
Reviews local branch changes for bugs, security vulnerabilities, and code quality issues, reporting findings without making changes.
Browser Automation
davila7
Guides browser automation with Playwright and Puppeteer for testing, scraping, and agentic browser control.
Code Review
davila7
Guides code reviews of pull requests using Sentry engineering practices, covering security, performance, testing and design.
Commit
davila7
Formats Git commit messages using Sentry's conventional-commit conventions, including issue references.
More in Software Development
Playground
anthropics
Builds self-contained interactive HTML playgrounds with controls, live preview, and copyable prompt output.
M5 Onboard
anthropics
Provisions M5Stack ESP32 boards by detecting them on USB, flashing UIFlow 2.0 firmware, and installing a MicroPython app bundle.
Cardputer Buddy
anthropics
Guides iterating on a Cardputer-Adv MicroPython app bundle: adding apps, pushing files over USB-serial, tailing logs, and running REPL commands.
Web Design Guidelines
vercel-labs
Reviews UI code against Web Interface Guidelines fetched from a remote source and reports findings as file:line entries.
Vercel React Native Skills
vercel-labs
React Native and Expo best-practice rules covering list performance, animation, navigation, UI patterns, state, and monorepo setup.
Vercel React Best Practices
vercel-labs
Vercel's React and Next.js performance guidelines, organized as 70 rules for writing, reviewing, and refactoring code.