skills.rest
afonsoft
afonsoftCOMMUNITY
Explore all skills by this author →
Website𝕏@afonsoftGitHub

postgresql-optimization

Optimize PostgreSQL queries using JSONB, arrays, and custom types.

1|Updated Mar 20, 2026
Search Tags:#performance#database#postgresql#optimization#query-tuning#extensions#jsonb
One-click install
npx skills add https://github.com/afonsoft/VideoChat --skill postgresql-optimization-afonsoft
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql-optimization
Source: https://github.com/afonsoft/VideoChat/tree/main/.agents/skills/postgresql-optimization
Command: npx skills add https://github.com/afonsoft/VideoChat --skill postgresql-optimization-afonsoft

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL-optimized development assistance to unlock high-performance data operations by leveraging PostgreSQL-specific features and best practices.

Core Features & Use Cases

  • Advanced data types and features: JSONB, arrays, range types, and custom types to model complex domains efficiently.
  • Performance-focused guidance: query tuning, indexing strategies, and extension usage for large-scale workloads.
  • Use Case: A backend service that processes event streams and analytics queries benefits from optimized JSONB queries and partial indexes.

Quick Start

Analyze a slow query on a PostgreSQL schema and propose targeted optimizations.

Frequently Asked Questions about postgresql-optimization

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

FAQPage Schema
How do I optimize slow PostgreSQL queries using JSONB and arrays?▼

Optimizing slow PostgreSQL queries involves analyzing the schema and applying targeted indexing strategies for JSONB and arrays. This ensures efficient data retrieval and improved performance for large-scale workloads.

What is the best way to tune PostgreSQL window functions and full-text search in production?▼

The best way to tune PostgreSQL window functions and full-text search is to apply query optimization techniques across complex schemas. This ensures high-performance data operations while maintaining correctness and security in production-grade systems.

Does this PostgreSQL optimization approach work with enterprise .NET backends?▼

Yes, this PostgreSQL optimization approach ensures compatibility with enterprise .NET backends. It provides performance-focused guidance and extension usage that integrates securely with your existing production-grade backend services.

How do I use partial indexes for event stream analytics in PostgreSQL?▼

Using partial indexes for event stream analytics in PostgreSQL involves applying indexing strategies to optimize complex queries. This reduces query execution time and improves performance for backend services processing high-volume analytics workloads.

When should I use PostgreSQL extensions for query tuning?▼

You should use PostgreSQL extensions for query tuning when handling large-scale workloads that require advanced features. Extensions provide performance-focused guidance to optimize operations across complex schemas and ensure production-grade system stability.

Related Skills

Explore More Software Engineering Skills→
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
francanetefrancanete
1

postgres-query-optimization

Analyzes slow PostgreSQL queries using EXPLAIN ANALYZE to recommend index and query optimizations.

Community
Advanced
HouseGarofaloHouseGarofalo
3

postgresql

Guide PostgreSQL database design, optimization, and pgvector AI embeddings.

Official
Advanced
AratKruglikAratKruglik
150

postgresql-optimization

Optimize PostgreSQL queries, indexes, and configuration parameters.

Community
Advanced