tokens&
For enterprises
Submit
Sign in
tokens&

Build better AI stacks, claim useful opportunities, and give AI infrastructure companies a source-labeled adoption readout they can trust.

For buildersFor enterprises

Product

  • For builders
  • Category rankings
  • Startup credits and perks
  • Agent Skills
  • Platform
  • Submit project, tool, product, or perk

Enterprise

  • Start free company workspace

Community

  • Community
  • Newsletter
  • Events
Xin

© 2026 tokensand, LLC. All rights reserved.

  • Terms
  • Privacy
  • Security
  • Data Processing
  • Status
Agent Skills/Postgres best practices
SupabaseBackendSKILL.mdVerified source

Agent Skill

Postgres best practices

Tune queries, RLS, connection pooling, and schema choices before a build slows down.

Install this skillView repository

Vendor-authored source · MIT license.

Raw SKILL.mdSupabase tool profileInstall the Tokens& Agent Pack

Tokens& curated build recipe

A private project tracker

Build a small project tracker with Supabase Auth and Postgres. Give each signed-in builder access only to their own projects, and use the Postgres skill to review the schema, queries, and row-level security.

  1. 1. Check the free tier

    Supabase free backend tier

    The Free plan is available for experiments and hobby projects. Database, storage, and egress quotas apply; inactive projects can pause after one week.

    Read Supabase terms

  2. 2. Use the vendor skill

    Postgres best practices

    Review the source and install instructions below, then use the skill in your own project.

    See install instructions

  3. 3. Build and show the result

    Save the Build Packet, then attach a demo or repository with tests proving two users cannot read or modify each other's projects.

    Start this Build Packet

Public resources selected by Tokens&. Terms reviewed 2026-09-05; the provider decides eligibility and current limits. This recipe is a suggested project, not a vendor partnership or a completed build.

Skill specification

Declared by Supabase in the package front matter. Trigger conditions are what the coding agent matches on before it loads the skill.

View package fields
Postgres best practices SKILL.md front matter fields
Skill namesupabase-postgres-best-practices
Trigger conditionsPostgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.
Declared licenseMIT
Version1.1.1
Authorsupabase
OrganizationSupabase

Install supabase-postgres-best-practices

In a terminal with Node.js, npm and Git, run the command for your agent. The Skills CLI installs the complete package directory, including referenced files within it. Review its install prompt, then start a new agent session. A skill package does not set up an MCP server connection.

Codex

.agents/skills/supabase-postgres-best-practices/SKILL.md

Codex reads `.agents/skills/` as its primary location, which is also the cross-platform default other clients honour.

Project install

npx skills add 'https://github.com/supabase/agent-skills/tree/main/skills/supabase-postgres-best-practices' --skill 'supabase-postgres-best-practices' --agent 'codex'
Install for all projects instead

Personal install

npx skills add 'https://github.com/supabase/agent-skills/tree/main/skills/supabase-postgres-best-practices' --skill 'supabase-postgres-best-practices' --agent 'codex' --global

SKILL.md

View raw source

Published by Supabase under MIT. Rendered from the package in github.com/supabase/agent-skills/tree/main/skills/supabase-postgres-best-practices.

Read full skill instructions

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-

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

More Supabase Agent Skills

All Agent Skills

Supabase platform guide

Work across Supabase Auth, Edge Functions, Realtime, Storage, Vectors, CLI, MCP, and RLS.

Backend

7
Monitoring & Diagnostics
LOW-MEDIUM
monitor-
8Advanced FeaturesLOWadvanced-