Labsco
supabase logo

Postgres Best Practices

✓ Official★ 2,300

by Supabase · part of supabase/agent-skills

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

🔥🔥🔥🔥✓ VerifiedFreeQuick setup
#automation#lead-gen#social-media#scraping#database#git#maps#security
🧩 One of 5 skills in the supabase/agent-skills package — works on its own, and pairs well with its siblings.

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Inspect the full instructions your agent will receiveExpand

This is the exact playbook injected into your agent when the skill activates — shown here so you can audit it before installing. You don't need to read it to use the skill.

by Supabase

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations. npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practices Download ZIPGitHub2.3k

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-

References

Related Skills

wp-block-themes automattic

Use when developing WordPress block themes: theme.json (global settings/styles), templates and template parts, patterns, style variations, and Site Editor… official

caveman-help juliusbrussee

Quick-reference card for all caveman modes, skills, and commands. One-shot display, not a persistent mode. Trigger: /caveman-help, "caveman help", "what caveman commands", "how do I use caveman". development document productivity

flutter-localizing-apps flutter

Multi-language support for Flutter apps using ARB files and code generation. Configure pubspec.yaml with flutter_localizations and intl , then define an l10n.yaml file to enable the gen-l10n code generator Store localized strings in Application Resource Bundle ( .arb ) JSON files; the template file defines all keys, and locale-specific files provide translations Integrate localizations into MaterialApp or CupertinoApp by adding AppLocalizations.delegate and platform-specific delegates to... official

copywriting coreyhaines31

When the user wants to write, rewrite, or improve marketing copy for any page — including homepage, landing pages, pricing pages, feature pages, about pages, or product pages. Also use when the user says "write copy for," "improve this copy," "rewrite this page," "marketing copy," "headline help," "CTA copy," "value proposition," "tagline," "subheadline," "hero section copy," "above the fold," "this copy is weak," "make this more compelling," or "help me describe my product." Use this... marketing creative communication

wp-plugin-development firecrawl

Use when developing WordPress plugins: architecture and hooks, activation/deactivation/uninstall, admin UI and Settings API, data storage, cron/tasks, security… official

apify-ultimate-scraper apify

Automated web scraper selecting optimal Actors for 55+ platforms including Instagram, TikTok, YouTube, Facebook, Google Maps, and more. Covers 55+ pre-configured Actors across 8 major platforms with use-case-specific selection guidance (lead generation, influencer discovery, brand monitoring, competitor analysis, trend research) Supports three output formats: quick chat display, CSV export, or JSON export with customizable result limits Includes multi-Actor workflow patterns for complex... official

context7-mcp upstash

This skill should be used when the user asks about libraries, frameworks, API references, or needs code examples. Activates for setup questions, code… official

app-store-screenshots qu-skills

App Store and Google Play screenshot creation with exact platform specs. Covers iOS/Android dimensions, gallery ordering, device mockups, and preview videos. Use for: app store optimization, ASO, app screenshots, app preview, play store listing. Triggers: app store screenshots, aso, app store optimization, play store screenshots, app preview, app listing, ios screenshots, android screenshots, app store images, app mockup, device mockup, app gallery, store listing design creative marketing