Skip to content
TrustedSkillsbeta
Back to all skills

Postgresql Performance Expert

Listed
founderjourney·vlatest·database

Helps with PostgreSQL, performance optimization as part of working with databases and data persistence workflows.

Repository

Install on your platform

This skill no longer installs under the name postgresql-performance-expert. founderjourney/claude-skills is deleted or private, so it cannot be installed from.

We check each listing against its upstream repository with the rules the skills CLI uses, last on 2026-10-22. We don't show a command we know will fail.

Repository install instructions

What we know about this skill

Publisher

founderjourney

Taken from the source listing. We haven't verified who controls this account.

Install target

Live repository

Not pinned. Installing fetches whatever the repository holds at the time you run the command.

Nobody has reviewed this code. TrustedSkills indexes and links skills; it does not audit, run or scan them. A skill runs with whatever access you give your agent — read the source before you install it.

Automated safety checks

scanned

We could not read this skill's source, so none of the checks below were run.

Not scanned. repository not found or private Source recorded as founderjourney/claude-skills.
This is a static scan, not a review. It reads the skill's files; it does not run them, and it cannot tell you whether the skill is any good or whether the code does what its description says. A skill runs with whatever access you give your agent.
What each check looks for →

About this skill

What it does

This skill analyzes PostgreSQL database performance and provides actionable recommendations for optimization. It can identify slow queries, suggest index improvements, and analyze server resource utilization to pinpoint bottlenecks impacting database speed. The expert focuses on delivering practical advice to improve query execution times and overall database efficiency.

When to use it

  • You're experiencing slow application response times that you suspect are related to your PostgreSQL database.
  • Database administrators need assistance in identifying the root cause of performance degradation after a recent deployment or data load.
  • Developers want to proactively optimize query performance before scaling an application with heavy database usage.
  • You’ve noticed increased resource consumption (CPU, memory) on your PostgreSQL server and suspect inefficient queries are contributing.

Key capabilities

  • Query analysis and optimization suggestions
  • Index recommendation generation
  • Server resource utilization assessment
  • Identification of slow queries

Example prompts

  • "Analyze this PostgreSQL query: SELECT * FROM orders WHERE customer_id = 123; and suggest improvements."
  • "What indexes would be beneficial for the 'products' table, given these common queries?"
  • “My database server is running at high CPU. Can you identify potential bottlenecks?”

Tips & gotchas

The skill’s recommendations are based on the provided query or context; it requires accurate information about your PostgreSQL environment to provide relevant insights. Providing sample data and schema details can improve accuracy.