Claude MarketplacesSubmit
secondsky avatar

Supabase Postgres Best Practices

secondsky/claude-skills

This is Supabase's official Postgres optimization guide packaged as a Claude skill. It covers 8 categories of performance rules, from critical query optimization and connection pooling to advanced features, with each rule including incorrect vs correct SQL examples and EXPLAIN plan analysis. You'd reach for this when writing queries, designing schemas, or debugging performance issues in Postgres or Supabase projects. The rules are prioritized by impact, which is helpful since you can focus on the critical stuff like missing indexes and connection management before diving into incremental optimizations. It's basically Supabase's internal knowledge about how to not shoot yourself in the foot with Postgres, now available to Claude for code review and generation.

skills.sh installs
319
GitHub stars
248
last updated
Aug 21, 2026
View on GitHub

Install

$ npx -y skills add secondsky/claude-skills --skill supabase-postgres-best-practices --agent claude-code

Installs into .claude/skills of the current project.

Files

This is Supabase's official Postgres optimization guide packaged as a Claude skill. It covers 8 categories of performance rules, from critical query optimization and connection pooling to advanced features, with each rule including incorrect vs correct SQL examples and EXPLAIN plan analysis. You'd reach for this when writing queries, designing schemas, or debugging performance issues in Postgres or Supabase projects. The rules are prioritized by impact, which is helpful since you can focus on the critical stuff like missing indexes and connection management before diving into incremental optimizations. It's basically Supabase's internal knowledge about how to not shoot yourself in the foot with Postgres, now available to Claude for code review and generation.

Browse the repository on GitHub

Sponsors

Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthlyAgent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any language

Details

Repository
github.com/secondsky/claude-skills
Categories
Backend & APIs, Documentation, Debugging, Databases
First seen
Jun 3, 2026

More from secondsky/claude-skills

All 146

Recommended

More Backend & APIs
1decebals avatarapi-contract-reviewdecebals/claude-code-javaReview REST API contracts for HTTP semantics, versioning, backward compatibility, and response consistency. Use when user asks "review API", "check endpoints", 315skills.sh installs
2davila7 avatarfda-databasedavila7/claude-code-templatesQuery openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data anal313skills.sh installs
3patricio0312rev avatarprisma-migration-assistantpatricio0312rev/skillsPlans and executes safe Prisma schema migrations with data backfills, rollback strategies, and SQL preview. Handles complex schema changes including data transf313skills.sh installs
4charlietlamb avataropenlogs-server-logscharlietlamb/openlogsFetch and inspect recent local server logs in repos that use openlogs or the `ol` CLI. Use when a user asks what happened in the server, wants recent dev-server273skills.sh installs
5davila7 avatargene-databasedavila7/claude-code-templatesQuery NCBI Gene via E-utilities/Datasets API. Search by symbol/ID, retrieve gene info (RefSeqs, GO, locations, phenotypes), batch lookups, for gene annotation a272skills.sh installs
6martinholovsky avatarwebsocketmartinholovsky/claude-skills-generatorReal-time bidirectional communication with security focus on CSWSH prevention, authentication, and message validation269skills.sh installs