PostgreSQL Advanced Expert

Expert in advanced PostgreSQL — performance tuning, query optimization, extensions (PostGIS, pgvector, TimescaleDB), partitioning, replication, and production operations.

Platinum

v1.0.00 activationsData & AnalyticsTechnologyexpert

SupaScore

86.05

Research Quality (15%)

8.6

Prompt Engineering (25%)

8.5

Practical Utility (15%)

8.9

Completeness (10%)

8.4

User Satisfaction (20%)

8.7

Decision Usefulness (15%)

8.5

Best for

▸Optimizing slow PostgreSQL queries with EXPLAIN ANALYZE and index strategy
▸Implementing pgvector for AI embedding search with HNSW indexes
▸Setting up PostGIS spatial queries with R-tree optimization
▸Configuring TimescaleDB partitioning for high-volume time series data
▸Tuning PostgreSQL production parameters for OLTP/OLAP workloads

What you'll get

●EXPLAIN ANALYZE breakdown with specific index recommendations and rewritten queries with performance projections
●Step-by-step pgvector installation with HNSW index configuration and similarity search implementation code
●Production PostgreSQL tuning checklist with specific postgresql.conf parameters and monitoring queries

Not designed for ↓

×Basic SQL syntax teaching or simple SELECT/INSERT queries
×MySQL, SQL Server, or other database systems
×Application-level database connection pooling configuration
×Cloud database service management (RDS/Cloud SQL admin tasks)

Expects

Production PostgreSQL performance issues, query execution plans, schema designs, or extension implementation requirements with specific workload characteristics.

Returns

Detailed optimization recommendations with specific PostgreSQL configuration changes, index strategies, query rewrites, and extension setup commands.

Evidence Policy

Standard: no explicit evidence policy.

postgresqlperformance-tuningpgvectorpostgisquery-optimizationextensionsdatabase

Research Foundation: 7 sources (4 official docs, 2 books, 1 web)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.

Version History

v1.0.02/15/2026

Initial version

Works well with

Database Indexing StrategistGold Database Performance TunerPlatinum SQL Performance Tuning ExpertPlatinum Streaming Analytics SpecialistGold Time Series Forecasting SpecialistGold

Need more depth?

Specialist skills that go deeper in areas this skill touches.

PostgreSQL Extension DeveloperGold Database Sharding StrategistGold

Common Workflows

Database Performance Optimization Pipeline

End-to-end PostgreSQL performance optimization from query tuning to production monitoring setup

postgresql-advanced-expert→Database Performance Tuner→monitoring-observability-designer

Activate this skill in Claude Code

Start Free to Activate This Skill