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

Ready to run

npx skills add https://github.com/ScotterMonk/AgentAutoFlow --skill db-postgres-scottermonk

💬 Prompt for ChatGPT / Claude Chat▼

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.