Which PostgreSQL extensions are supported by this skill?

This skill supports several essential extensions including pg_stat_statements for monitoring, pg_trgm for fuzzy search, uuid-ossp for UUID generation, hstore for key-value pairs, and PostGIS for geospatial data.

Can this skill help me troubleshoot extension installation errors?

Yes, it includes troubleshooting patterns for common issues such as permission denied errors, missing OS-level packages, and version mismatches during updates.

Does this skill work with any PostgreSQL version?

While optimized for PostgreSQL 16+, the patterns and extensions provided are compatible with most modern production environments where superuser or extension privileges are available.

How do I view the most resource-intensive queries using this skill?

The skill provides SQL templates for pg_stat_statements that allow you to rank queries by total execution time, mean execution time, and call frequency to identify performance bottlenecks.

PostgreSQL Extensions & Optimization

Name: PostgreSQL Extensions & Optimization
Author: pluginagentmarketplace

bypluginagentmarketplace

•

Database Management

Optimizes PostgreSQL databases by installing, configuring, and implementing essential extensions for performance, search, and data modeling.

This skill provides expert guidance for enhancing PostgreSQL functionality through the implementation of production-ready extensions and patterns. It streamlines the deployment of critical tools like pg_stat_statements for query performance monitoring, pg_trgm for fuzzy text searching, and PostGIS for geospatial analysis. Whether you need to generate UUIDs for secure identifiers, manage semi-structured hstore data, or troubleshoot extension-related permissions, this skill offers standardized SQL snippets and implementation strategies to ensure robust and efficient database operations.

Key Features

01Fuzzy text search implementation using pg_trgm

02Standardized UUID generation and management

03Key-value store capabilities using hstore

041 GitHub stars

05Performance monitoring with pg_stat_statements

06Geospatial data support via PostGIS integration

Use Cases

01Configuring advanced data types for location-based services and geospatial apps

02Implementing similarity-based search for product catalogs or user profiles

03Identifying and optimizing slow database queries using execution time metrics

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pluginagentmarketplace/custom-plugin-postgresql postgresql-extensions

For use in Claude.ai and ChatGPT

Download Skill