When to choose it
A source-based PostgreSQL review with actual SQL, schemas and workload context.
Choose it if: you can supply concrete database artifacts to review.
Look elsewhere if: you expect this installation to connect automatically to a database.
What the source describes
- Prioritized guidance on queries, indexes, connection handling and database design.
- Reference examples include RLS and query-plan considerations for Postgres hosted anywhere.
Requirements
- Claude Code with Skill support.
- Node.js 22.20.0+ for the reviewed skills CLI 1.7.0 and npm.
- Relevant SQL, schema files or a sanitized query plan; live database access is separately configured.
The focused Skill can be installed separately. The alternative postgres-best-practices plugin ships this Skill; database connections are independent.
Install the focused Skill
- Choose the intended project. Run the focused install below from this project. The reviewed skills CLI 1.7.0 requires Node.js 22.20.0+ and npm. Read the upstream files and review the CLI’s installation scope and symlink or copy prompt.
- Check discovery. Confirm the Skill is listed for Claude Code in the same project.Shell • setup check
npx skills list --agent claude-code - Optional plugin distribution. The focused plugin is postgres-best-practices. The repository also has a broader supabase plugin; install only the intended one.Shell • alternative plugin install
claude plugin marketplace add supabase/agent-skills claude plugin install postgres-best-practices@supabase-agent-skills --scope local
Run this command from the intended project folder after reviewing the source. The skills CLI targets Claude Code and defaults to project scope. Review its scope and symlink or copy prompt; use --global only if you want a user-wide installation.
npx skills add supabase/agent-skills --skill supabase-postgres-best-practices --agent claude-codeHow to use it
Ask naturally about PostgreSQL queries, migrations, indexes or RLS. Supply sanitized context and state whether you want recommendations or edits.
An original example for a bounded task. This request example is written by ClaudeStack; it is not a transcript of a tested session.
Review this query and schema for missing indexes. Explain proposed changes and what to compare in EXPLAIN before applying a migration. Keep this review read-only.The external skills CLI collects installation telemetry and makes public-repository security-audit requests. Its README documents DISABLE_TELEMETRY=1 or DO_NOT_TRACK=1 to disable both. ClaudeStack did not run this installer.
What to expect
The reviewed source describes these observations. ClaudeStack has not loaded or run this extension.
- Recommendations tied to the supplied SQL and documented database rules.
- Trade-offs and validation steps for your own workload rather than guaranteed speed-ups.
Self-check: Compare recommendations against the current schema and query plan. Test any migration in an appropriate environment before applying it.
Troubleshooting
Advice is too general
Supply table definitions, existing indexes, approximate data scale and a sanitized query plan.
No database tool is available
Review supplied files or plans. The Skill does not install a database connector or create permissions.
Disable or remove it
- For a project installation, run npx skills remove supabase-postgres-best-practices --agent claude-code from the same project. Add --global only when removing a global installation.
- Review any edits and generated artifacts separately; removing the Skill does not revert its work.
- For the plugin route, disable or uninstall postgres-best-practices in /plugin.
Limitations & considerations
- The Skill does not configure database access or provide live telemetry.
- Proposed index, schema and RLS changes need workload-specific validation before application.
Source & review record
Our description is based on public documentation and manifests available on 2026-10-05. Installation formats were checked against Claude Code and the relevant installer documentation. No extension code was executed: this is a source review, not a runtime compatibility test or security audit.
- Original source and documentation
- Reviewed definition source
- License of the reviewed source
- Official plugin installation documentation
Repository last pushed at the time of review: 2026-10-02T12:34:51Z. This date does not prove that the extension works with a particular Claude Code release.
Usage guide sources
Upstream revision checked for this guide: c9be0e931b7930f7d02126d04774d904c381e7d7. Command names and behavior in this guide are documentation and registration-source findings, not runtime verification.