skills.rest
ScotterMonk
ScotterMonkCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-postgres

Analyze PostgreSQL and Supabase query execution plans and index strategies.

37|1|Updated Oct 20, 2025
Search Tags:#performance#postgresql#supabase#replication#dba#query tuning#database optimization
One-click install
npx skills add https://github.com/ScotterMonk/AgentAutoFlow --skill db-postgres-scottermonk
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-postgres
Source: https://github.com/ScotterMonk/AgentAutoFlow/tree/main/.roo/skills/db-postgres
Command: npx skills add https://github.com/ScotterMonk/AgentAutoFlow --skill db-postgres-scottermonk

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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%''.

Frequently Asked Questions about db-postgres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL queries using EXPLAIN ANALYZE?▼

Optimize slow PostgreSQL queries by analyzing execution plans with EXPLAIN ANALYZE to identify missing indexes and suggest query rewrites for significantly improved performance.

What is the best way to set up PostgreSQL replication for high availability?▼

PostgreSQL replication for high availability is configured through streaming or logical replication to ensure robust performance and data redundancy across systems.

How does JSONB indexing work in Supabase databases?▼

JSONB indexing in Supabase databases works by implementing specialized index strategies to efficiently query and retrieve nested JSON data structures.

Can I use PostGIS and pgvector extensions with my PostgreSQL database?▼

PostGIS and pgvector extensions are supported for advanced feature implementation, enabling spatial data processing and vector similarity searches within PostgreSQL databases.

When do I need to tune VACUUM and ANALYZE in PostgreSQL?▼

Tune VACUUM and ANALYZE in PostgreSQL when maintaining high-availability systems to manage bloat, update planner statistics, and ensure robust query performance.

Related Skills

Explore More Software Engineering Skills→
GDSDNGDSDN
3

db-explain

Analyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.

Community
Advanced
VXerysVXerys

database-optimizer

Analyze slow PostgreSQL and MySQL queries and generate index strategies.

Community
Advanced
cosmixcosmix
53

caching

Implement caching strategies with TTL management and Redis or Memcached.

Community
Advanced
arbazkhan971arbazkhan971
26

postgres

Optimize PostgreSQL production performance with tuning, indexing, and replication guidance.

Community
Advanced