Postgresql Optimization
Expert in PostgreSQL performance tuning, query optimization, and database administration. Specializes in EXPLAIN analysis, indexing strategies, connection pooling, partitioning, and production-grade PostgreSQL operations.
Install
/plugin marketplace add curiositech/some_claude_skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add curiositech/some_claude_skills --skill postgresql-optimizationgit clone --depth 1 https://github.com/curiositech/some_claude_skills.git /tmp/some_claude_skills
mkdir -p ~/.claude/skills
cp -r /tmp/some_claude_skills/.claude/skills/postgresql-optimization ~/.claude/skills/postgresql-optimizationPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# PostgreSQL Optimization ## Overview Expert in PostgreSQL performance tuning, query optimization, and database administration. Specializes in EXPLAIN analysis, indexing strategies, connection pooling, partitioning, and production-grade PostgreSQL operations. ## When to Use - Diagnosing slow queries with EXPLAIN ANALYZE - Creating optimal indexes for query patterns - Designing database schemas for performance - Configuring PostgreSQL for production workloads - Implementing connection pooling (PgBouncer, Supavisor) - Setting up partitioning for large tables - Analyzing and reducing lock contention - Migrating or upgrading PostgreSQL versions ## Capabilities ### Query Optimization - EXPLAIN / EXPLAIN ANALYZE interpretation - Query plan analysis and optimization - Identifying sequential scans vs index scans - Join optimization and query rewriting - CTE vs subquery performance trade-offs - Window function optimization ### Indexing Strategies - B-tree, GIN, GiST, BRIN index selection - Partial indexes for filtered queries - Expression indexes for computed values - Covering indexes (INCLUDE clause) - Index-only scans optimization - Concurrent index creation ### Schema Design - Normalization vs denormalization trade-offs - JSONB column design and indexing - Array columns and operations - Enum types vs lookup tables - Foreign key cascade strategies - Table inheritance and partitioning ### Configuration Tuning
Details
- Skill name
postgresql-optimization- Repository
- curiositech/some_claude_skills
- Path
.claude/skills/postgresql-optimization/SKILL.md- License
- MIT
- Repo updated
- 5 November 2026
FAQ
What does the Postgresql Optimization skill do?
Expert in PostgreSQL performance tuning, query optimization, and database administration. Specializes in EXPLAIN analysis, indexing strategies, connection pooling, partitioning, and production-grade PostgreSQL operations.
How do I install the Postgresql Optimization skill?
Claude Code plugin: /plugin marketplace add curiositech/some_claude_skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Postgresql Optimization popular?
It lives in curiositech/some_claude_skills, which has 272 GitHub stars and 46 forks.
Related skills
Email Composer
272curiositech/some_claude_skills
Draft professional emails for various contexts including business, technical, and customer communication. Use when the user needs help writing emails or composing professional messages.
2000s Visualization Expert
272curiositech/some_claude_skills
Expert in 2000s-era music visualization (Milkdrop, AVS, Geiss) and modern WebGL implementations. Specializes in Butterchurn integration, Web Audio API AnalyserNode FFT data, GLSL shaders for audio-reactive visuals, and psychedelic generative art. Activate on "Milkdrop", "music visualization", "WebGL visualizer", "Butterchurn", "audio reactive", "FFT visualization", "spectrum analyzer". NOT for simple bar charts/waveforms (use basic canvas), video editing, or non-audio visuals.
2026 Legal Research Agent
272curiositech/some_claude_skills
Expert legal research agent for finding and scraping expungement data state by state. Knows authoritative sources, URL patterns, Firecrawl configuration, and 2026 legal landscape. Activate on "find expungement data", "scrape state laws", "legal research", "court URLs", "statute sources", "Clean Slate laws", "automatic expungement research". NOT for interpreting laws (use national-expungement-expert), building UI, or legal advice.
Supabase Admin
272curiositech/some_claude_skills
Supabase administration, RLS policies, migrations, and schema design. Use for database architecture, Row Level Security, performance tuning, auth integration. Activate on "Supabase", "RLS", "migration", "policy", "schema", "auth.uid()". NOT for Supabase Auth UI configuration (use dashboard), edge functions (use cloudflare-worker-dev), or general SQL without Supabase context.
Postgres Helper
192smallnest/goskills
[TODO: Complete and informative explanation of what the skill does and when to use it. Include WHEN to use this skill - specific scenarios, file types, or tasks that trigger it.]
Data SQL Optimization
248asgard-ai-platform/skills
Optimize SQL query performance using EXPLAIN analysis, indexing strategies, and common anti-pattern fixes. Use this skill when the user needs to speed up slow queries, design indexes, fix N+1 problems, or optimize database performance — even if they say 'this query is slow', 'optimize our database', 'which indexes do we need', or 'our dashboard takes 30 seconds to load'.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.