postgresql-optimization

davila7/claude-code-templates · cli-tool/components/skills/database/postgresql-optimization/SKILL.md

PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

No license★ 33156⑂ 3873commit 5cc17cf

Install skillView source on GitHub

What this skill does

PostgreSQL Optimization Workflow

Overview

Specialized workflow for PostgreSQL database optimization including query tuning, indexing strategies, performance analysis, vacuum management, and production database administration.

When to Use This Workflow

Use this workflow when:

Optimizing slow PostgreSQL queries
Designing indexing strategies
Analyzing database performance
Tuning PostgreSQL configuration
Managing production databases

Workflow Phases

Phase 1: Performance Assessment

Skills to Invoke

database-optimizer - Database optimization
postgres-best-practices - PostgreSQL best practices

Actions

Check database version
Review configuration
Analyze slow queries
Check resource usage
Identify bottlenecks

Copy-Paste Prompts

Use @database-optimizer to assess PostgreSQL performance

Phase 2: Query Analysis

Skills to Invoke

sql-optimization-patterns - SQL optimization
postgres-best-practices - PostgreSQL patterns

Actions

Run EXPLAIN ANALYZE
Identify scan types
Check join strategies
Analyze execution time
Find optimization opportunities

Copy-Paste Prompts

Use @sql-optimization-patterns to analyze and optimize queries

Phase 3: Indexing Strategy

Skills to Invoke

database-design - Index design
postgresql - PostgreSQL indexing

Actions

Identify missing indexes
Create B-tree indexes
Add composite indexes
Consider partial indexes
Review index usage

Copy-Paste Prompts

Use @database-design to design PostgreSQL indexing strategy

Phase 4: Query Optimization

Skills to Invoke

sql-optimization-patterns - Query tuning
sql-pro - SQL expertise

Actions

Rewrite inefficient queries
Optimize joins
Add CTEs where helpful
Implement pagination
Test improvements

Copy-Paste Prompts

Use @sql-optimization-patterns to optimize SQL queries

Phase 5: Configuration Tuning

Skills to Invoke

postgres-best-practices - Configuration
database-admin - Database administration

Actions

Tune shared_buffers
Configure work_mem
Set effective_cache_size
Adjust checkpoint settings
Configure autovacuum

Copy-Paste Prompts

Use @postgres-best-practices to tune PostgreSQL configuration

Phase 6: Maintenance

Skills to Invoke

database-admin - Database maintenance
postgresql - PostgreSQL maintenance

Actions

Schedule VACUUM
Run ANALYZE
Check table bloat
Monitor autovacuum
Review statistics

Copy-Paste Prompts

Use @database-admin to schedule PostgreSQL maintenance

Phase 7: Monitoring

Skills to Invoke

grafana-dashboards - Monitoring dashboards
prometheus-configuration - Metrics collection

Actions

Set up monitoring
Create dashboards
Configure alerts
Track key metrics
Review trends

Copy-Paste Prompts

Use @grafana-dashboards to create PostgreSQL monitoring

Optimization Checklist

[ ] Slow queries identified
[ ] Indexes optimized
[ ] Configuration tuned
[ ] Maintenance scheduled
[ ] Monitoring active
[ ] Performance improved

Quality Gates

[ ] Query performance improved
[ ] Indexes effective
[ ] Configuration optimized
[ ] Maintenance automated
[ ] Monitoring in place

Related Workflow Bundles

database - Database operations
cloud-devops - Infrastructure
performance-optimization - Performance

Installation

Copy a source-pinned command for your client. You run it yourself.

Destination: .claude/skills/postgresql-optimization · pinned to the source commit

# Run from your project root
git clone https://github.com/davila7/claude-code-templates.git .skillboard-tmp
git -C .skillboard-tmp checkout 5cc17cf267132cc690dee82239b80a99ec82e4f8
mkdir -p ".claude/skills"
cp -r ".skillboard-tmp/cli-tool/components/skills/database/postgresql-optimization" ".claude/skills/"
rm -rf .skillboard-tmp

Review the source before running. This copies files into your project; it is not a one-click install and does not verify runtime safety.

New here? Step-by-step setup – from installing the agent to using the skill

Operating systemAgentI already use Claude Code

1
Install Git
Install Git with your package manager (Debian/Ubuntu shown; use dnf/pacman on others). Official download.
```
sudo apt update && sudo apt install -y git
```
2
Install Claude Code
Requires Node.js 18+. Install the CLI globally: Official docs. (command-line tool)
```
npm install -g @anthropic-ai/claude-code
```

Get the skill, pinned to its exact version

Open a terminal and run these steps (they clone the source, check out the exact commit, and copy the skill into place):

# Run from your project root
git clone https://github.com/davila7/claude-code-templates.git .skillboard-tmp
git -C .skillboard-tmp checkout 5cc17cf267132cc690dee82239b80a99ec82e4f8
mkdir -p ".claude/skills"
cp -r ".skillboard-tmp/cli-tool/components/skills/database/postgresql-optimization" ".claude/skills/"
rm -rf .skillboard-tmp

Destination: .claude/skills/postgresql-optimization

4
Use it in Claude Code
Open Claude Code in your project. It reads skills from the folder above, so postgresql-optimization is now available. Always review the source before using it – static checks cannot prove runtime safety.

Security & Audits

Scanner static-checks@0.1.0 · commit 5cc17cf26713. Static checks cannot prove runtime safety – review the source and the exact diff before installing. How checks work.

No static rules matched. This is not a safety guarantee.

postgresql-optimization

davila7/claude-code-templates · cli-tool/components/skills/database/postgresql-optimization/SKILL.md

PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

No license★ 33156⑂ 3873commit 5cc17cf

Install skillView source on GitHub

What this skill does

PostgreSQL Optimization Workflow

Overview

Specialized workflow for PostgreSQL database optimization including query tuning, indexing strategies, performance analysis, vacuum management, and production database administration.

When to Use This Workflow

Use this workflow when:

Optimizing slow PostgreSQL queries
Designing indexing strategies
Analyzing database performance
Tuning PostgreSQL configuration
Managing production databases

Workflow Phases

Phase 1: Performance Assessment

Skills to Invoke

database-optimizer - Database optimization
postgres-best-practices - PostgreSQL best practices

Actions

Check database version
Review configuration
Analyze slow queries
Check resource usage
Identify bottlenecks

Copy-Paste Prompts

Use @database-optimizer to assess PostgreSQL performance

Phase 2: Query Analysis

Skills to Invoke

sql-optimization-patterns - SQL optimization
postgres-best-practices - PostgreSQL patterns

Actions

Run EXPLAIN ANALYZE
Identify scan types
Check join strategies
Analyze execution time
Find optimization opportunities

Copy-Paste Prompts

Use @sql-optimization-patterns to analyze and optimize queries

Phase 3: Indexing Strategy

Skills to Invoke

database-design - Index design
postgresql - PostgreSQL indexing

Actions

Identify missing indexes
Create B-tree indexes
Add composite indexes
Consider partial indexes
Review index usage

Copy-Paste Prompts

Use @database-design to design PostgreSQL indexing strategy

Phase 4: Query Optimization

Skills to Invoke

sql-optimization-patterns - Query tuning
sql-pro - SQL expertise

Actions

Rewrite inefficient queries
Optimize joins
Add CTEs where helpful
Implement pagination
Test improvements

Copy-Paste Prompts

Use @sql-optimization-patterns to optimize SQL queries

Phase 5: Configuration Tuning

Skills to Invoke

postgres-best-practices - Configuration
database-admin - Database administration

Actions

Tune shared_buffers
Configure work_mem
Set effective_cache_size
Adjust checkpoint settings
Configure autovacuum

Copy-Paste Prompts

Use @postgres-best-practices to tune PostgreSQL configuration

Phase 6: Maintenance

Skills to Invoke

database-admin - Database maintenance
postgresql - PostgreSQL maintenance

Actions

Schedule VACUUM
Run ANALYZE
Check table bloat
Monitor autovacuum
Review statistics

Copy-Paste Prompts

Use @database-admin to schedule PostgreSQL maintenance

Phase 7: Monitoring

Skills to Invoke

grafana-dashboards - Monitoring dashboards
prometheus-configuration - Metrics collection

Actions

Set up monitoring
Create dashboards
Configure alerts
Track key metrics
Review trends

Copy-Paste Prompts

Use @grafana-dashboards to create PostgreSQL monitoring

Optimization Checklist

[ ] Slow queries identified
[ ] Indexes optimized
[ ] Configuration tuned
[ ] Maintenance scheduled
[ ] Monitoring active
[ ] Performance improved

Quality Gates

[ ] Query performance improved
[ ] Indexes effective
[ ] Configuration optimized
[ ] Maintenance automated
[ ] Monitoring in place

Related Workflow Bundles

database - Database operations
cloud-devops - Infrastructure
performance-optimization - Performance

Installation

Copy a source-pinned command for your client. You run it yourself.

Destination: .claude/skills/postgresql-optimization · pinned to the source commit

# Run from your project root
git clone https://github.com/davila7/claude-code-templates.git .skillboard-tmp
git -C .skillboard-tmp checkout 5cc17cf267132cc690dee82239b80a99ec82e4f8
mkdir -p ".claude/skills"
cp -r ".skillboard-tmp/cli-tool/components/skills/database/postgresql-optimization" ".claude/skills/"
rm -rf .skillboard-tmp

Review the source before running. This copies files into your project; it is not a one-click install and does not verify runtime safety.

New here? Step-by-step setup – from installing the agent to using the skill

Operating systemAgentI already use Claude Code

1
Install Git
Install Git with your package manager (Debian/Ubuntu shown; use dnf/pacman on others). Official download.
```
sudo apt update && sudo apt install -y git
```
2
Install Claude Code
Requires Node.js 18+. Install the CLI globally: Official docs. (command-line tool)
```
npm install -g @anthropic-ai/claude-code
```

Get the skill, pinned to its exact version

Open a terminal and run these steps (they clone the source, check out the exact commit, and copy the skill into place):

# Run from your project root
git clone https://github.com/davila7/claude-code-templates.git .skillboard-tmp
git -C .skillboard-tmp checkout 5cc17cf267132cc690dee82239b80a99ec82e4f8
mkdir -p ".claude/skills"
cp -r ".skillboard-tmp/cli-tool/components/skills/database/postgresql-optimization" ".claude/skills/"
rm -rf .skillboard-tmp

Destination: .claude/skills/postgresql-optimization

4
Use it in Claude Code
Open Claude Code in your project. It reads skills from the folder above, so postgresql-optimization is now available. Always review the source before using it – static checks cannot prove runtime safety.

Security & Audits

Scanner static-checks@0.1.0 · commit 5cc17cf26713. Static checks cannot prove runtime safety – review the source and the exact diff before installing. How checks work.

No static rules matched. This is not a safety guarantee.

postgresql-optimization

What this skill does

PostgreSQL Optimization Workflow

Overview

When to Use This Workflow

Workflow Phases

Phase 1: Performance Assessment

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 2: Query Analysis

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 3: Indexing Strategy

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 4: Query Optimization

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 5: Configuration Tuning

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 6: Maintenance

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 7: Monitoring

Skills to Invoke

Actions

Copy-Paste Prompts

Optimization Checklist

Quality Gates

Related Workflow Bundles

Installation

Install Git

Install Claude Code

Get the skill, pinned to its exact version

Use it in Claude Code

Security & Audits

postgresql-optimization

What this skill does

PostgreSQL Optimization Workflow

Overview

When to Use This Workflow

Workflow Phases

Phase 1: Performance Assessment

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 2: Query Analysis

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 3: Indexing Strategy

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 4: Query Optimization

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 5: Configuration Tuning

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 6: Maintenance

Skills to Invoke

Actions

Copy-Paste Prompts

Phase 7: Monitoring

Skills to Invoke

Actions

Copy-Paste Prompts

Optimization Checklist

Quality Gates

Related Workflow Bundles