Skills
.Work. You
Rest

db-postgres

Community

Optimize PostgreSQL & Supabase

Software Engineering#performance#postgresql#supabase#replication#dba#query tuning#database optimization
AuthorScotterMonk
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses complex PostgreSQL and Supabase database challenges, from optimizing slow queries and configuring replication to implementing advanced features and ensuring robust performance.

Core Features & Use Cases

  • Query Optimization: Analyze and tune slow queries using EXPLAIN ANALYZE.
  • Replication & HA: Set up streaming or logical replication for high availability.
  • Advanced Features: Implement JSONB indexing, use extensions like PostGIS and pgvector, and tune VACUUM/ANALYZE.
  • Use Case: A critical e-commerce application is experiencing slow checkout times due to inefficient database queries. This Skill can analyze the EXPLAIN ANALYZE output, identify missing indexes, and suggest query rewrites to significantly improve performance.

Quick Start

Use the db-postgres skill to analyze the performance of the query 'SELECT * FROM users WHERE email LIKE '%@example.com%''.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: db-postgres
Download link: https://github.com/ScotterMonk/AgentAutoFlow/archive/main.zip#db-postgres

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.