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

•

データベース管理

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.

主な機能

Fuzzy text search implementation using pg_trgm
Standardized UUID generation and management
Key-value store capabilities using hstore
1 GitHub stars
Performance monitoring with pg_stat_statements
Geospatial data support via PostGIS integration

ユースケース

Configuring advanced data types for location-based services and geospatial apps
Implementing similarity-based search for product catalogs or user profiles
Identifying 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

GitHub

概要