skills.rest
Serg28
Serg28COMMUNITY
Explore all skills by this author →
WebsiteGitHub

postgres-pro

Analyze PostgreSQL query performance and configure extensions and replication.

Updated Apr 25, 2026
Search Tags:#performance#postgresql#optimization#extension#backup#replication
One-click install
npx skills add https://github.com/Serg28/demosite --skill postgres-pro-serg28
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/Serg28/demosite/tree/main/.agents/skills/postgres-pro
Command: npx skills add https://github.com/Serg28/demosite --skill postgres-pro-serg28

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pg_stat_statements, uuid-ossp, pg_trgm, postgis, pgvector, pgcrypto, postgres_fdw, pg_repack, timescaledb, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps database administrators and engineers analyze query performance, optimize configurations, and set up extensions for PostgreSQL, ensuring efficient and reliable database operations.

Core Features & Use Cases

  • Performance Tuning: Use EXPLAIN ANALYZE and index recommendations to improve query speeds.
  • Extension Management: Install, configure, and monitor extensions like PostGIS, pgvector, and pg_trgm for various functionalities.
  • Replication & Backup: Set up streaming and logical replication, perform online maintenance, and ensure data durability with WAL archiving and PITR support.
  • Use Case: For instance, a DBA wants to reduce slow query times on a large dataset by analyzing query plans, creating appropriate indexes, and enabling partitioning with TimescaleDB.

Quick Start

Run EXPLAIN ANALYZE on slow queries to identify bottlenecks and create indexes to speed them up.

Frequently Asked Questions about postgres-pro

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

FAQPage Schema
How do I optimize slow PostgreSQL queries using EXPLAIN ANALYZE?▼

PostgreSQL performance tuning involves running EXPLAIN ANALYZE on slow queries to identify bottlenecks, then creating appropriate indexes and enabling partitioning with extensions like TimescaleDB to accelerate query execution on large datasets.

How do I set up streaming and logical replication for PostgreSQL high-availability?▼

Set up PostgreSQL streaming and logical replication by configuring replication slots, performing online maintenance, and ensuring data durability with WAL archiving and Point-in-Time Recovery (PITR) support for high-availability database systems.

Does PostgreSQL work with pgvector and PostGIS for advanced extension management?▼

Yes, PostgreSQL supports advanced extension management for pgvector, PostGIS, and pg_trgm, allowing you to install, configure, and monitor these extensions to add specialized functionalities like vector search and geospatial data processing.

What is the best way to configure PostgreSQL extensions for scalable database systems?▼

The best way to configure PostgreSQL extensions for scalable systems is using comprehensive extension management workflows to install and monitor dependencies like uuid-ossp, pgcrypto, and postgres_fdw, ensuring efficient and reliable database operations in production environments.

Why does PostgreSQL query performance degrade on large datasets without proper indexing?▼

PostgreSQL query performance degrades on large datasets without proper indexing because the database must perform full table scans; analyzing query plans and creating appropriate indexes eliminates these bottlenecks and significantly speeds up data retrieval.

Related Skills

Explore More Software Engineering Skills→
interflownexinterflownex
2

alloydb-postgres-monitor

Monitor AlloyDB for PostgreSQL query performance, system metrics, and lock states.

Community
Advanced
evolv3-aievolv3-ai
1

admin-infra-hetzner

Automate Hetzner Cloud deployment with ARM64 and x86 servers.

Official
Advanced
discountedcookiediscountedcookie

postgres-vectors

Store 384-dimensional embeddings in Postgres and query cosine similarity with pgvector.

Community
Advanced
dieu-donneedieu-donnee

postgres-pro

Identify and optimize slow PostgreSQL queries using EXPLAIN ANALYZE and VACUUM tuning.

Community
Advanced