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 | Default |
|---|---|---|---|
| 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"
}