supabase-postgres-best-practices

supabase-postgres-best-practices: 这个 Skill 做什么

supabase-postgres-best-practices is a reusable agent skill listed on skills.sh under supabase/agent-skills. skills.sh rank #32, installs 171.8K, GitHub stars 2.2K, first seen Jan 21, 2026.

Postgres performance optimization rules across 8 priority categories, from query tuning to advanced features. Organized into 8 rule categories prioritized by impact: query performance and connection management (critical), security and RLS, schema design, concurrency, data access patterns, monitoring, and advanced features Each rule includes detailed explanations, incorrect vs. correct SQL examples, EXPLAIN output analysis, and performance metrics to guide optimization decisions Covers query indexing, connection pooling, Row-Level Security configuration, schema design patterns, locking behavior, and Postgres-specific tuning Designed for use during SQL writing, schema design, performance reviews, and database scaling decisions

适合什么时候使用

• Use this skill when the task matches the package name, repository context, or skills.sh topic: Databases.
• Prefer it when a repeatable workflow is better than a one-off prompt: setup, review, design, deployment, automation, research, media generation, or operational checks.
• For production work, read the linked repository and install command before allowing the agent to run scripts or modify files.

Agent 应该如何使用

1. Confirm the user intent and whether this skill is the right fit.
2. Install or inspect the skill with the official command from skills.sh.
3. Read the local SKILL.md and only load extra files referenced by that skill.
4. Follow the skill's workflow, then verify the result with tests, screenshots, audits, or source-backed checks as appropriate.
5. Record any constraints, missing credentials, tool permissions, or security warnings before handoff.

质量与安全检查

• Check repository ownership and source reputation: supabase/agent-skills.
• Review security audit signals before installing; skills.sh reports: Gen Agent Trust Hub Pass Socket Pass Snyk Pass.
• Never grant broad shell, browser, cloud, or deployment permissions without user approval.
• Treat generated output as draft until validated by the skill's own acceptance criteria.
• If the skill touches cloud resources, costs, credentials, customer data, or production deploys, require a human review step.

来源与安装

• skills.sh page: https://www.skills.sh/supabase/agent-skills/supabase-postgres-best-practices
• Repository: https://github.com/supabase/agent-skills
• Install command: npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practices

常见问题

Is supabase-postgres-best-practices an agent, a prompt, or a skill?
It is a skill: a reusable package of task-specific instructions and supporting files that an agent can load when the user's request matches the workflow.

Should I install it automatically?
Only after checking the repository, install command, audit status, and whether the user wants this capability in the current agent environment.

What makes it useful for AIDreamHub users?
It helps users discover practical agent capabilities from the open skills ecosystem and compare them by task, source, install count, and operational risk.