pg_info

Analyze Heroku PostgreSQL database configurations, monitor performance metrics, and assess health and resource usage. Obtain detailed insights into database operations for informed decision-making.

Instructions

Display detailed information about Heroku PostgreSQL databases. Use this tool when you need to: 1) View comprehensive database configuration and status, 2) Monitor database performance metrics, 3) Check connection and resource utilization, 4) Assess database health and capacity. The tool provides detailed insights into database operations and configuration.

Input Schema

Name	Required	Description	Default
`app`	Yes	The name of the Heroku app whose database to inspect.
`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, all databases are shown.

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "app": {
      "description": "The name of the Heroku app whose database to inspect.",
      "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, all databases are shown.",
      "type": "string"
    }
  },
  "required": [
    "app"
  ],
  "type": "object"
}

Heroku MCP server

pg_info

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Heroku MCP server

Related Tools