Skip to content
Agentmart
Submit a tool

supabase-postgres-best-practices

Design or review Postgres schemas, SQL, RLS, indexes, and diagnose query, connection, or locking problems.

Skill by supabase

IndexedMIT★ 4
Write a review

Install

Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.

npx agentmarket install skill/mskre-supabase-postgres-best-practices

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

Design or review Postgres schemas, SQL, RLS, indexes, and diagnose query, connection, or locking problems.

Use cases: design, backend

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.

Tools
No tools found
Secrets
None asked for
Install scripts
None found

Network hosts it talks to 1

  • codeload.github.com · found in install command

Files it touches

  • ~/.claude/skills/supabase-postgres-best-practices

What's inside

Skill name
supabase-postgres-best-practices
Description
Design or review Postgres schemas, SQL, RLS, indexes, and diagnose query, connection, or locking problems.
License
MIT
Metadata
date: January 2026 · author: supabase · version: 1.1.1 · abstract: Postgres SQL and performance references, maintained by Supabase. · organization: Supabase
Instructions
32 lines in SKILL.md · view on GitHub

Files (33)

  • SKILL.md
  • _sections.md · references/
  • advanced-full-text-search.md · references/
  • advanced-jsonb-indexing.md · references/
  • conn-idle-timeout.md · references/
  • conn-limits.md · references/
  • conn-pooling.md · references/
  • conn-prepared-statements.md · references/
  • data-batch-inserts.md · references/
  • data-n-plus-one.md · references/
  • data-pagination.md · references/
  • data-upsert.md · references/
  • lock-advisory.md · references/
  • lock-deadlock-prevention.md · references/
  • lock-short-transactions.md · references/
  • lock-skip-locked.md · references/
  • monitor-explain-analyze.md · references/
  • monitor-pg-stat-statements.md · references/
  • monitor-vacuum-analyze.md · references/
  • query-composite-indexes.md · references/
  • query-covering-indexes.md · references/
  • query-index-types.md · references/
  • query-missing-indexes.md · references/
  • query-partial-indexes.md · references/
  • schema-constraints.md · references/
  • schema-data-types.md · references/
  • schema-foreign-key-indexes.md · references/
  • schema-lowercase-identifiers.md · references/
  • schema-partitioning.md · references/
  • schema-primary-keys.md · references/
  • security-privileges.md · references/
  • security-rls-basics.md · references/
  • security-rls-performance.md · references/

SKILL.md (first lines)

# Supabase Postgres Best Practices

Read only the rules matching the SQL or operational issue. These apply to Postgres anywhere; Supabase service/auth integration belongs to [supabase](../supabase/SKILL.md).

## 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

Browse the matching prefix in [references](references/). Entry points: [missing indexes](references/query-missing-indexes.md), [partial indexes](references/query-partial-indexes.md), [data types](references/schema-data-types.md), [constraints](references/schema-constraints.md), [RLS](references/security-rls-basics.md), [privileges](references/security-privileges.md), [pooling](references/conn-pooling.md), [EXPLAIN](references/monitor-explain-analyze.md).

Use least-privilege application roles. `EXPLAIN ANALYZE` executes the query; use rollback-safe checks for writes and never reset a shared database as a test shortcut.

## References

- https://www.postgresql.org/docs/current/
- https://supabase.com/docs
- https://wiki.postgresql.org/wiki/Performance_Optimization
- https://supabase.com/docs/guides/database/overview
- https://supabase.com/docs/guides/auth/row-level-security

From mskre/opencode-plugin, MIT.

More from mskre/opencode-plugin

Signals

Stars
4
Forks
0
Open issues
0
Last commit (this folder)
Sep 5, 2026 (1 month ago)

From GitHub (fetched Oct 24, 2026).

Details

Version
1.1.1
License
MIT
Repository
github.com/mskre/opencode-plugin
First seen
Oct 24, 2026
Last checked
Oct 24, 2026
Source
GitHubgithub-graphql

More from supabase

Cite this page

supabase-postgres-best-practices skill. Agent Mart. https://agentmart.dev/skills/mskre-supabase-postgres-best-practices (last updated 2026-10-24)