Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Postgres Performance Workbench

    1

    Review PostgreSQL query plans, indexes, and operational evidence before recommending a focused performance change.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Postgres Performance Workbench

    Postgres Performance Workbench

    Example session with this skill installed

    A supplied plan shows a sequential scan on a 40-row table, returning 35 rows. Does that alone justify adding an index?

    • Read your context and instructions
    • Compiled the postgres performance workbench

    Prepared editorial example; not a captured live test.

    No. The table is small and most rows are returned, so a sequential scan may be
    appropriate. Inspect actual timing, buffers, filters, query frequency, and the
    workload before recommending an index. An index could add write and storage cost
    without helping this access pattern. No database was queried or altered.

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

    About this skill

    Review PostgreSQL query plans, indexes, and operational evidence before recommending a focused performance change. This independent English adaptation provides a focused agent workflow, explicit evidence limits, and a prepared example. Draft review from supplied plans needs no database account. Live queries and EXPLAIN ANALYZE need separate access and execution scope.

    Requires user-provided EXPLAIN plans or live DB access. Does not perform server-level OS tuning or hosting provider migrations. Index builds require explicit scope authorization.

    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 22 days ago

    Permissions

    Read Files

    File Scopes

    User-selected
    SQL
    schema
    and
    exported
    plans/**

    Supplied-text or offline review modes need no live account. File changes, commands, and external connections are limited to the separately requested mode and user-selected scope.

    Listed22 days ago

    What's inside

    Frequently Asked Questions

    No, the workbench is designed for safety; it analyzes EXPLAIN plan data to provide optimization reports and SQL recommendations, which you can then review and execute at your discretion.

    You should provide the SQL query text, the relevant table schema (DDL), and ideally the output of `EXPLAIN (ANALYZE, BUFFERS)` for the most accurate diagnostic results.

    While general prompts often suggest redundant indexes, this skill evaluates column cardinality, join strategies, and buffer usage to recommend the most efficient indexing strategy for your specific data layout.

    The skill is optimized for all modern versions of PostgreSQL (9.6 through 16+) and works with any AI agent platform that supports text-based diagnostic tools.

    The skill focuses on query-level and schema-level performance; it does not provide hardware provisioning, kernel-level OS tuning, or cloud infrastructure migration advice.

    New in Data & Databases