skills.rest
blazefluz
blazefluzCOMMUNITY
Explore all skills by this author →
GitHub

Database Administrator (PostgreSQL)

Optimize slow PostgreSQL queries using pg_stat_statements for the Rentable application.

Updated Feb 25, 2026
Search Tags:#database#postgresql#optimization#sql#performance tuning#administration
One-click install
npx skills add https://github.com/blazefluz/rentable --skill database-administrator-postgresql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Administrator (PostgreSQL)
Source: https://github.com/blazefluz/rentable/tree/main/.claude/skills/database-administrator
Command: npx skills add https://github.com/blazefluz/rentable --skill database-administrator-postgresql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the need for expert management of PostgreSQL databases, ensuring optimal performance, robust security, and high reliability for the Rentable application.

Core Features & Use Cases

  • Performance Tuning: Identifies and optimizes slow-running SQL queries.
  • Schema Design: Assists in designing efficient and scalable database schemas.
  • Backup and Recovery: Guides on setting up and managing database backup strategies.
  • Health Monitoring: Provides insights into database health and resource utilization.
  • Use Case: When application performance degrades due to database bottlenecks, this Skill can analyze query execution times and suggest indexing or query rewrites.

Quick Start

Analyze the slowest queries in the PostgreSQL database.

Frequently Asked Questions about Database Administrator (PostgreSQL)

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

FAQPage Schema
How do I optimize slow PostgreSQL queries?▼

To optimize slow PostgreSQL queries, analyze query execution times using SQL queries against pg_stat_statements to identify bottlenecks and suggest indexing or query rewrites for performance tuning.

What is the best way to monitor PostgreSQL database health and resource utilization?▼

Monitoring PostgreSQL database health involves analyzing resource utilization and performance metrics to ensure reliability, utilizing SQL queries against pg_stat_statements to provide insights into system status.

How do I design efficient and scalable PostgreSQL database schemas?▼

Designing efficient PostgreSQL database schemas requires expert administration to structure data for scalability, ensuring the schema design supports optimal performance and reliability for your application.

How do I set up and manage PostgreSQL backup and recovery strategies?▼

Setting up PostgreSQL backup and recovery strategies involves guiding the configuration of database backups to ensure high reliability and robust security for your application data.

Can I use pg_stat_statements for PostgreSQL performance tuning?▼

Yes, you can use pg_stat_statements for PostgreSQL performance tuning by running SQL queries against it to analyze execution times, identify slow-running queries, and resolve database bottlenecks.

Related Skills

Explore More Software Engineering Skills→
IldarMinaevIldarMinaev
1

postgresql-performance-check

Analyze PostgreSQL cluster load, queries, and vacuum health for bottlenecks.

Community
Advanced
VXerysVXerys

database-optimizer

Analyze slow PostgreSQL and MySQL queries and generate index strategies.

Community
Advanced
zero3041zero3041
1

clickhouse-io

Optimize ClickHouse schema design, query performance, and data ingestion.

Community
Advanced
bcastelinobcastelino
2

database-optimizer

Analyze SQL query execution plans and design indexing strategies.

Community
Advanced