Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    PostgreSQL Performance Doctor

    1

    Diagnose PostgreSQL query and workload bottlenecks using plans, indexes, statistics, locks, and safe tuning.

    $9.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    PostgreSQL Performance Doctor

    PostgreSQL Performance Doctor

    Example session with this skill installed

    A PostgreSQL query joining orders and customers slowed from 200 ms to 4 seconds after table growth. Outline a safe investigation.

    • Read your context and instructions
    • Compiled the postgresql performance doctor

    PostgreSQL Performance Doctor: practical plan

    Investigation plan

    Capture evidence

    Record query text, bind values or representative parameters, PostgreSQL version, table sizes, row estimates, recent deploys and workload timing. Use EXPLAIN (ANALYZE, BUFFERS) on a safe environment or carefully on production for bounded queries.

    Compare plan behavior

    Check sequential scans, join order, estimated versus actual rows, sort spills, buffer reads, loop counts and parallel workers. Confirm statistics are current and parameter selectivity varies.

    Index review

    Inspect existing indexes and write workload. Consider a composite index only when predicates and ordering support it; estimate storage and write cost. Avoid adding speculative indexes to solve a planner or data-model issue.

    Concurrency checks

    Review lock waits, connection pool saturation, long transactions, vacuum progress and I/O. Query latency may be caused by contention rather than the join itself.

    Change protocol

    Test a candidate index or query rewrite with representative data, compare plans and p95 latency, then deploy with rollback. Monitor reads, writes, bloat and replication lag. Do not tune global settings without workload evidence.

    Measurement and review

    Record the baseline, source, date range, denominator and owner. Use one primary measure plus quality guardrails; compare like-for-like cohorts and disclose missing data. Treat estimates as scenarios, not observed outcomes.

    Risks and controls

    Check relevance, consent, disclosure, workload and downside before scaling. Keep an evidence trail, obtain human review for material commitments, and pause if trust, quality or compliance signals deteriorate.

    Next steps

    1. Confirm the goal, audience and available capacity.
    2. Gather the minimum evidence for a first test.
    3. Assign an owner, budget and review date.
    4. Run a small pilot, record outcomes and decide whether to iterate, expand or stop.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Create a practical, evidence-led PostgreSQL Performance Doctor workflow. Diagnose PostgreSQL query and workload bottlenecks using plans, indexes, statistics, locks, and safe tuning. Distinguish observations from assumptions, request missing inputs, give actionable recommendations with owners and measurable outcomes, and flag uncertainty. Avoid fabricated metrics, unsupported guarantees, deceptive tactics and unnecessary personal data.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 1 month ago

    Permissions

    Read Files
    Listed1 month ago

    What's inside

    Frequently Asked Questions

    Diagnose PostgreSQL query and workload bottlenecks using plans, indexes, statistics, locks, and safe tuning.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use PostgreSQL Performance Doctor on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.