---
name: Postgres Best Practices
description: Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
---

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

# Postgres Best Practicesby 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 ZIPGitHub

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

PriorityCategoryImpactPrefix1Query PerformanceCRITICAL`query-`2Connection ManagementCRITICAL`conn-`3Security & RLSCRITICAL`security-`4Schema DesignHIGH`schema-`5Concurrency & LockingMEDIUM-HIGH`lock-`6Data Access PatternsMEDIUM`data-`7Monitoring & DiagnosticsLOW-MEDIUM`monitor-`8Advanced FeaturesLOW`advanced-`

## How to Use

Read individual rule files for detailed explanations and SQL examples:

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

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

## Related Skills
async-pr-reviewby google-geminiTrigger this skill when the user wants to start an asynchronous PR review, run background checks on a PR, or check the status of a previously started async PR…shopify-liquidby shopifyLiquid is an open-source templating language created by Shopify. It is the backbone of Shopify themes and is used to load dynamic content on storefronts.…aspnet-minimal-api-openapiby githubASP.NET Minimal API endpoints with automatic OpenAPI/Swagger documentation and strong typing. Organize endpoints using MapGroup() , endpoint filters, and feature-based folder structures for scalability Define explicit request/response DTOs with validation attributes; use record types and TypedResults for type safety Leverage .NET 9 built-in OpenAPI support with operation summaries, descriptions, operationIds, and property-level documentation via [Description()] Apply document and schema...pr-referenceby microsoftGenerates PR reference XML containing commit history and unified diffs between branches with extension and path filtering. Includes utilities to list changed…building-ai-agent-on-cloudflareby Cloudflare|
Builds AI agents on Cloudflare using the Agents SDK with state management,
real-time WebSockets, scheduled tasks, tool integration, and chat capabilities.
Generates production-ready agent code deployed to Workers.

Use when: user wants to "build an agent", "AI agent", "chat agent", "stateful
agent", mentions "Agents SDK", needs "real-time AI", "WebSocket AI", or asks
about agent "state management", "scheduled tasks", or "tool calling".azure-search-documents-dotnetby microsoftBuild search applications with full-text, vector, semantic, and hybrid search capabilities.fluid-prby microsoftUse when creating a pull request in the Fluid Framework repo. Composes a PR title and body following Fluid Framework conventions, proposes them to the user,…shopify-adminby shopifyWrite or explain **Admin GraphQL** queries and mutations for apps and integrations that extend the Shopify admin. Use when the user wants to **understand,…

---

**Source**: https://github.com/supabase/agent-skills/tree/main/skills/supabase-postgres-best-practices
**Author**: Supabase
**Discovered via**: mcpservers.org