Supabase Postgres Best Practices — Agent Skill by OpenAI

From the author

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

— the description by supabase

Install

Get the skill from its source (we cannot redistribute it):
https://github.com/openai/plugins/tree/d420d13051bffe4543ed39e30fa46b87148e47dd/plugins/build-web-apps/skills/supabase-best-practices

Documentation by supabase

The licence of this skill does not allow us to copy its documentation. Read it at the source

Files

AGENTS.md(opens on GitHub)Not mirrored: opens on GitHub2.1 KiB
README.md(opens on GitHub)Not mirrored: opens on GitHub3.1 KiB
SKILL.md(opens on GitHub)Not mirrored: opens on GitHub2.5 KiB
agents/openai.yaml(opens on GitHub)Not mirrored: opens on GitHub145 B
references/_contributing.md(opens on GitHub)Not mirrored: opens on GitHub4.1 KiB
references/_sections.md(opens on GitHub)Not mirrored: opens on GitHub1.6 KiB
references/_template.md(opens on GitHub)Not mirrored: opens on GitHub1.0 KiB
references/advanced-full-text-search.md(opens on GitHub)Not mirrored: opens on GitHub1.4 KiB
references/advanced-jsonb-indexing.md(opens on GitHub)Not mirrored: opens on GitHub1.4 KiB
references/conn-idle-timeout.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/conn-limits.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/conn-pooling.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/conn-prepared-statements.md(opens on GitHub)Not mirrored: opens on GitHub1.5 KiB
references/data-batch-inserts.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/data-n-plus-one.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/data-pagination.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/data-upsert.md(opens on GitHub)Not mirrored: opens on GitHub1.4 KiB
references/lock-advisory.md(opens on GitHub)Not mirrored: opens on GitHub1.5 KiB
references/lock-deadlock-prevention.md(opens on GitHub)Not mirrored: opens on GitHub1.8 KiB
references/lock-short-transactions.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/lock-skip-locked.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/monitor-explain-analyze.md(opens on GitHub)Not mirrored: opens on GitHub1.4 KiB
references/monitor-pg-stat-statements.md(opens on GitHub)Not mirrored: opens on GitHub1.4 KiB
references/monitor-vacuum-analyze.md(opens on GitHub)Not mirrored: opens on GitHub1.5 KiB
references/query-composite-indexes.md(opens on GitHub)Not mirrored: opens on GitHub1.4 KiB
references/query-covering-indexes.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/query-index-types.md(opens on GitHub)Not mirrored: opens on GitHub1.5 KiB
references/query-missing-indexes.md(opens on GitHub)Not mirrored: opens on GitHub1.2 KiB
references/query-partial-indexes.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/schema-constraints.md(opens on GitHub)Not mirrored: opens on GitHub1.8 KiB
references/schema-data-types.md(opens on GitHub)Not mirrored: opens on GitHub1.4 KiB
references/schema-foreign-key-indexes.md(opens on GitHub)Not mirrored: opens on GitHub1.6 KiB
references/schema-lowercase-identifiers.md(opens on GitHub)Not mirrored: opens on GitHub1.7 KiB
references/schema-partitioning.md(opens on GitHub)Not mirrored: opens on GitHub1.5 KiB
references/schema-primary-keys.md(opens on GitHub)Not mirrored: opens on GitHub1.8 KiB
references/security-privileges.md(opens on GitHub)Not mirrored: opens on GitHub1.5 KiB
references/security-rls-basics.md(opens on GitHub)Not mirrored: opens on GitHub1.3 KiB
references/security-rls-performance.md(opens on GitHub)Not mirrored: opens on GitHub1.5 KiB

Requirements and compatibility

Written for: OpenAI Codex

Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Anndata
K-Dense· Community
A Python framework for managing annotated data matrices in single-cell genomics and general research workflows.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k
Liteparse
K-Dense· Community
Local document and PDF parsing with spatial text extraction and bounding box support.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
Apache-2.0Low riskHas scriptsGitHub stars of the source repository56.4k
Usfiscaldata
K-Dense· Community
Access U.S. Treasury federal financial data via the Fiscal Data REST API.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k
Geopandas
K-Dense· Community
Guidance and local audit tools for Python workflows using GeoPandas 1.2.0 for spatial data analysis.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskHas scriptsGitHub stars of the source repository56.4k
Markitdown
K-Dense· Community
A lightweight utility for converting diverse document formats into structured Markdown for analysis, search, and LLM ingestion.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskHas scriptsGitHub stars of the source repository56.4k
Zarr Python
K-Dense· Community
A guide for storing and querying chunked N-D scientific arrays using Zarr-Python 3.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k