pg_outliers

Identify and optimize resource-intensive database operations on Heroku MCP server. Analyze slow queries, track performance patterns, and improve database workload efficiency.

Instructions

Identify resource-intensive database operations. Use this tool when you need to: 1) Find slow or expensive queries, 2) Analyze query performance patterns, 3) Optimize database workload, 4) Track query statistics over time. The tool helps identify opportunities for performance optimization.

Input Schema

Name	Required	Description
`app`	Yes	The name of the Heroku app whose query statistics to analyze.
`database`	No	Config var containing the connection string, unique name, ID, or alias of the database. To access another app's database, prepend the app name to the config var or alias with `APP_NAME::`. If omitted, DATABASE_URL is used.
`num`	No	The number of queries to display. Defaults to 10.
`reset`	No	When true, resets statistics gathered by pg_stat_statements.
`truncate`	No	When true, truncates queries to 40 characters.

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "app": {
      "description": "The name of the Heroku app whose query statistics to analyze.",
      "type": "string"
    },
    "database": {
      "description": "Config var containing the connection string, unique name, ID, or alias of the database. To access another app's database, prepend the app name to the config var or alias with `APP_NAME::`. If omitted, DATABASE_URL is used.",
      "type": "string"
    },
    "num": {
      "description": "The number of queries to display. Defaults to 10.",
      "type": "number"
    },
    "reset": {
      "description": "When true, resets statistics gathered by pg_stat_statements.",
      "type": "boolean"
    },
    "truncate": {
      "description": "When true, truncates queries to 40 characters.",
      "type": "boolean"
    }
  },
  "required": [
    "app"
  ],
  "type": "object"
}

Heroku MCP server

pg_outliers

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Heroku MCP server

Related Tools