Skip to main content
affpapa.org
RU EN
skill

postgres-best-practices · davila7 — Claude Code skill: SQL and setup

This skill guides Claude Code through Postgres queries, schemas, and configuration. Use it when tuning indexes, reviewing RLS, or investigating database performance.

Install into Claude Code · claude-code-templates All methods and platforms ↓ 
npx claude-code-templates@latest --skill development/postgres-best-practices
Open on GitHub

What postgres-best-practices does

postgres-best-practices gives Claude Code a structured set of Supabase guidance for Postgres work. It covers query tuning, connection handling, access control with RLS, schema choices, locking, data access, diagnostics, and advanced features. The categories are ranked so critical query and connection concerns come before lower-priority topics.

The package is organized as individual rule files. They explain the issue, contrast flawed and corrected SQL, and may include EXPLAIN output or Supabase-specific notes. The compiled reference is AGENTS.md; focused material includes rules/query-missing-indexes.md and rules/schema-partial-indexes.md. For a Postgres review, this makes the skill useful beyond query text: it also checks the surrounding schema and database setup.

What it helps with

  • spot missing indexes in a Postgres query
  • review a schema against access-control rules
  • investigate locks between concurrent operations
  • adjust connection pooling and scaling choices
  • check database settings with diagnostic rules

Example prompts for the agent

  • Review this Postgres query and suggest indexes using postgres-best-practices.
  • Inspect the schema with RLS and connection management in mind.
  • Compare this change with rules/query-missing-indexes.md and AGENTS.md.

How to install postgres-best-practices

1claude-code-templates

npx claude-code-templates@latest --skill development/postgres-best-practices

2Skills CLI (Vercel)

npx skills add davila7/claude-code-templates --skill postgres-best-practices -a claude-code

3Manually: put the files in place

~/.claude/skills/postgres-best-practices/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/postgres-best-practices/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about postgres-best-practices

How do I install postgres-best-practices in Claude Code?

Run npx claude-code-templates@latest --skill development/postgres-best-practices.

What does postgres-best-practices do?

It supplies Claude Code with Supabase guidance for Postgres queries, schemas, and configuration. The skill includes focused rules with SQL examples and review notes.

Does the skill cover Row-Level Security?

Yes. RLS appears in the security category, which has critical priority in the rule set.

Similar skills

All skills for Data and databases →

postgres-best-practices by other authors comes first.

postgres-best-practices neondatabase A skill that feeds your agent guidelines on Postgres schema design, indexing, query optimization, migrations and common pitfalls. Useful whenever it writes SQL or sets up a database. CX Codex +1 1,900installs xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. 187,223installs google-agents-cli-observability official Google This skill guides you through tracing and monitoring AI agents, including ADK agents. Use it when you need to inspect agent execution or monitor a deployed agent. CX Codex +1 511,300installs caveman-evidence-review JuliusBrussee A read-only skill reviews Caveman Cloud evidence on LLM spend, traces, and routing. Use it to see where a project’s model budget goes. CX Codex +1 104,500installs migration JuliusBrussee Enforces reversible, compatibility-safe transitions for schema, data, and API updates. Useful whenever data loss or rollout downtime is unacceptable. CX Codex +1 103,900installs performance-optimization addyosmani An agent skill that measures before it changes code: Core Web Vitals budgets, N+1 queries, missing indexes and slow endpoints. CX Codex +1 65,200installs supabase official supabase Guides the agent through database configuration and strict RLS policies in Supabase. CX Codex GP ChatGPT 8installs

From the same set361

The whole set →
web-design-guidelines This skill checks UI files against current Web Interface Guidelines and reports findings by file and line. Use it for accessibility or design reviews. 2,076installs writing-clearly-and-concisely A Claude skill that pushes the agent toward Strunk's rules for clear prose and away from the stock phrasing language models fall into. 206installs kaizen A skill that pushes the agent toward small, verified improvements and errors caught by the type system instead of at runtime. 117installs backend-architect A subagent for backend design work: service boundaries, API paradigm choice, database schemas and observability. Useful when the decision comes before the first line of code. 23,691installs generate-tests Creates a complete test suite for a specified component or file. The command inspects your testing setup and generates assertions following the AAA pattern. 12,378installs database-architect A subagent for schema design, database selection and migration planning. Reach for it when the question is how data should be stored, not how to write a query. 12,224installs seo-optimizer Guides search optimization by generating structured data, meta tags, and content outlines directly in Claude Code. 11,415installs architect-review This subagent checks code changes against a project’s architecture and established patterns. Use it to review structural pull requests or assess a new service design. 8,999installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor