{"id":"44853932-3796-4542-9f8a-2a2a7124c7b9","shortId":"FpMcMR","kind":"skill","title":"postgres-best-practices","tagline":"Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.","description":"# Supabase Postgres Best Practices\n\nComprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.\n\n## When to Use\nReference these guidelines when:\n- Writing SQL queries or designing schemas\n- Implementing indexes or query optimization\n- Reviewing database performance issues\n- Configuring connection pooling or scaling\n- Optimizing for Postgres-specific features\n- Working with Row-Level Security (RLS)\n\n## Rule Categories by Priority\n\n| Priority | Category | Impact | Prefix |\n|----------|----------|--------|--------|\n| 1 | Query Performance | CRITICAL | `query-` |\n| 2 | Connection Management | CRITICAL | `conn-` |\n| 3 | Security & RLS | CRITICAL | `security-` |\n| 4 | Schema Design | HIGH | `schema-` |\n| 5 | Concurrency & Locking | MEDIUM-HIGH | `lock-` |\n| 6 | Data Access Patterns | MEDIUM | `data-` |\n| 7 | Monitoring & Diagnostics | LOW-MEDIUM | `monitor-` |\n| 8 | Advanced Features | LOW | `advanced-` |\n\n## How to Use\n\nRead individual rule files for detailed explanations and SQL examples:\n\n```\nrules/query-missing-indexes.md\nrules/schema-partial-indexes.md\nrules/_sections.md\n```\n\nEach rule file contains:\n- Brief explanation of why it matters\n- Incorrect SQL example with explanation\n- Correct SQL example with explanation\n- Optional EXPLAIN output or metrics\n- Additional context and references\n- Supabase-specific notes (when applicable)\n\n## Full Compiled Document\n\nFor the complete guide with all rules expanded: `AGENTS.md`\n\n## When to Use\nThis skill is applicable to execute the workflow or actions described in the overview.\n\n## Limitations\n- Use this skill only when the task clearly matches the scope described above.\n- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.\n- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.","tags":["postgres","best","practices","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding"],"capabilities":["skill","source-sickn33","skill-postgres-best-practices","topic-agent-skills","topic-agentic-skills","topic-ai-agent-skills","topic-ai-agents","topic-ai-coding","topic-ai-workflows","topic-antigravity","topic-antigravity-skills","topic-claude-code","topic-claude-code-skills","topic-codex-cli","topic-codex-skills"],"categories":["antigravity-awesome-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/postgres-best-practices","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add sickn33/antigravity-awesome-skills","source_repo":"https://github.com/sickn33/antigravity-awesome-skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 34616 github stars · SKILL.md body (1,999 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-23T00:51:24.391Z","embedding":null,"createdAt":"2026-04-18T21:42:33.344Z","updatedAt":"2026-04-23T00:51:24.391Z","lastSeenAt":"2026-04-23T00:51:24.391Z","tsv":"'1':105 '2':110 '3':115 '4':120 '5':125 '6':132 '7':138 '8':44,145 'access':134 'across':43 'action':225 'addit':191 'advanc':146,149 'agents.md':212 'applic':200,219 'ask':263 'autom':51 'best':3,9,30 'boundari':271 'brief':170 'categori':45,98,102 'clarif':265 'clear':238 'compil':202 'complet':206 'comprehens':32 'concurr':126 'configur':27,79 'conn':114 'connect':80,111 'contain':41,169 'context':192 'correct':181 'criteria':274 'critic':108,113,118 'data':133,137 'databas':26,76 'describ':226,242 'design':24,56,68,122 'detail':158 'diagnost':140 'document':203 'environ':254 'environment-specif':253 'exampl':162,178,183 'execut':221 'expand':211 'expert':259 'explain':187 'explan':159,171,180,185 'featur':89,147 'file':156,168 'full':201 'guid':35,50,207 'guidelin':62 'high':123,130 'impact':48,103 'implement':70 'incorrect':176 'index':71 'individu':154 'input':268 'issu':78 'level':94 'limit':230 'lock':127,131 'low':142,148 'low-medium':141 'maintain':38 'manag':112 'match':239 'matter':175 'medium':129,136,143 'medium-high':128 'metric':190 'miss':276 'monitor':139,144 'note':198 'optim':7,20,34,53,74,84 'option':186 'output':188,248 'overview':229 'pattern':135 'perform':6,33,77,107 'permiss':269 'pool':81 'postgr':2,5,21,29,37,87 'postgres-best-practic':1 'postgres-specif':86 'practic':4,10,31 'prefix':104 'priorit':46 'prioriti':100,101 'queri':22,52,66,73,106,109 'read':153 'refer':60,194 'requir':267 'review':18,75,260 'rls':96,117 'row':93 'row-level':92 'rule':42,97,155,167,210 'rules/_sections.md':165 'rules/query-missing-indexes.md':163 'rules/schema-partial-indexes.md':164 'safeti':270 'scale':83 'schema':23,55,69,121,124 'scope':241 'secur':95,116,119 'skill':15,217,233 'skill-postgres-best-practices' 'source-sickn33' 'specif':88,197,255 'sql':65,161,177,182 'stop':261 'substitut':251 'success':273 'supabas':12,28,40,196 'supabase-specif':195 'task':237 'test':257 'topic-agent-skills' 'topic-agentic-skills' 'topic-ai-agent-skills' 'topic-ai-agents' 'topic-ai-coding' 'topic-ai-workflows' 'topic-antigravity' 'topic-antigravity-skills' 'topic-claude-code' 'topic-claude-code-skills' 'topic-codex-cli' 'topic-codex-skills' 'treat':246 'use':13,59,152,215,231 'valid':256 'work':90 'workflow':223 'write':17,64","prices":[{"id":"2d5c7c1a-2491-4f22-af79-1a4b94f67cff","listingId":"44853932-3796-4542-9f8a-2a2a7124c7b9","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"sickn33","category":"antigravity-awesome-skills","install_from":"skills.sh"},"createdAt":"2026-04-18T21:42:33.344Z"}],"sources":[{"listingId":"44853932-3796-4542-9f8a-2a2a7124c7b9","source":"github","sourceId":"sickn33/antigravity-awesome-skills/postgres-best-practices","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/postgres-best-practices","isPrimary":false,"firstSeenAt":"2026-04-18T21:42:33.344Z","lastSeenAt":"2026-04-23T00:51:24.391Z"}],"details":{"listingId":"44853932-3796-4542-9f8a-2a2a7124c7b9","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"postgres-best-practices","github":{"repo":"sickn33/antigravity-awesome-skills","stars":34616,"topics":["agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows","antigravity","antigravity-skills","claude-code","claude-code-skills","codex-cli","codex-skills","cursor","cursor-skills","developer-tools","gemini-cli","gemini-skills","kiro","mcp","skill-library"],"license":"mit","html_url":"https://github.com/sickn33/antigravity-awesome-skills","pushed_at":"2026-04-22T06:40:00Z","description":"Installable GitHub library of 1,400+ agentic skills for Claude Code, Cursor, Codex CLI, Gemini CLI, Antigravity, and more. Includes installer CLI, bundles, workflows, and official/community skill collections.","skill_md_sha":"e3552a2cf5e856510e57e83e65c8dfa10381df9a","skill_md_path":"skills/postgres-best-practices/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/postgres-best-practices"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"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."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/postgres-best-practices"},"updatedAt":"2026-04-23T00:51:24.391Z"}}