本文へ移動
cccskills
無料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.md1.8 KB
  • AGENTS.md43.9 KB
  • metadata.json818 B
  • README.md3.0 KB
  • rules/_contributing.md4.0 KB
  • rules/_sections.md1.6 KB
  • rules/_template.md1.0 KB
  • rules/advanced-full-text-search.md1.4 KB
  • rules/advanced-jsonb-indexing.md1.4 KB
  • rules/conn-idle-timeout.md1.3 KB
  • rules/conn-limits.md1.3 KB
  • rules/conn-pooling.md1.3 KB
  • rules/conn-prepared-statements.md1.5 KB
  • rules/data-batch-inserts.md1.3 KB
  • rules/data-n-plus-one.md1.3 KB
  • rules/data-pagination.md1.3 KB
  • rules/data-upsert.md1.4 KB
  • rules/lock-advisory.md1.5 KB
  • rules/lock-deadlock-prevention.md1.8 KB
  • rules/lock-short-transactions.md1.3 KB
  • rules/lock-skip-locked.md1.3 KB
  • rules/monitor-explain-analyze.md1.4 KB
  • rules/monitor-pg-stat-statements.md1.4 KB
  • rules/monitor-vacuum-analyze.md1.5 KB
  • rules/query-composite-indexes.md1.4 KB
  • rules/query-covering-indexes.md1.3 KB
  • rules/query-index-types.md1.4 KB
  • rules/query-missing-indexes.md1.2 KB
  • rules/query-partial-indexes.md1.3 KB
  • rules/schema-data-types.md1.4 KB
  • rules/schema-foreign-key-indexes.md1.6 KB
  • rules/schema-lowercase-identifiers.md1.7 KB
  • rules/schema-partitioning.md1.5 KB
  • rules/schema-primary-keys.md1.8 KB
  • rules/security-privileges.md1.5 KB
  • rules/security-rls-basics.md1.3 KB
  • rules/security-rls-performance.md1.5 KB

SKILL.md(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

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

PriorityCategoryImpactPrefix
1Query PerformanceCRITICALquery-
2Connection ManagementCRITICALconn-
3Security & RLSCRITICALsecurity-
4Schema DesignHIGHschema-
5Concurrency & LockingMEDIUM-HIGHlock-
6Data Access PatternsMEDIUMdata-
7Monitoring & DiagnosticsLOW-MEDIUMmonitor-
8Advanced FeaturesLOWadvanced-

How to Use

Read individual rule files for detailed explanations and SQL examples:

rules/query-missing-indexes.md
rules/schema-partial-indexes.md
rules/_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)

Full Compiled Document

For the complete guide with all rules expanded: AGENTS.md

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

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.

日本語の概要は準備中です。原文の説明を表示しています。

davila7/claude-code-templates3.3万2026年10月11日 更新

When the user wants to plan, design, or implement an A/B test or experiment. Also use when the user mentions "A/B test," "split test," "experiment," "test this change," "variant copy," "multivariate test," or "hypothesis." For tracking implementation, see analytics-tracking.

日本語の概要は準備中です。原文の説明を表示しています。

davila7/claude-code-templates3.3万2026年10月11日 更新

Format CVs for academic positions, including publications, grants, teaching, and research experience. Use when the user mentions academic CV, faculty job, tenure-track, postdoc, PhD, research position, or needs to list publications, grants, conferences, or teaching.

日本語の概要は準備中です。原文の説明を表示しています。

davila7/claude-code-templates3.3万2026年10月11日 更新

Audit and improve web accessibility following WCAG 2.1 guidelines. Use when asked to "improve accessibility", "a11y audit", "WCAG compliance", "screen reader support", "keyboard navigation", or "make accessible".

日本語の概要は準備中です。原文の説明を表示しています。

davila7/claude-code-templates3.3万2026年10月11日 更新

Web accessibility specialist for WCAG compliance, ARIA implementation, and inclusive design. Use when auditing websites for accessibility issues, implementing WCAG 2.1 AA/AAA standards, testing with screen readers, or ensuring ADA compliance. Expert in semantic HTML, keyboard navigation, and assistive technology compatibility.

日本語の概要は準備中です。原文の説明を表示しています。

davila7/claude-code-templates3.3万2026年10月11日 更新

This skill should be used when the user asks to "create an agent", "add an agent", "write a subagent", "agent frontmatter", "when to use description", "agent examples", "agent tools", "agent colors", "autonomous agent", or needs guidance on agent structure, system prompts, triggering conditions, or agent development best practices for Claude Code plugins.

日本語の概要は準備中です。原文の説明を表示しています。

davila7/claude-code-templates3.3万2026年10月11日 更新

davila7 のスキルをすべて見る

このスキルの問題を報告する