pg_maintenance

Monitor, schedule, and track database maintenance tasks. Check status, view activities, and plan operations for Heroku MCP server-managed databases.

Instructions

Monitor database maintenance status and operations. Use this tool when you need to: 1) Check current maintenance windows, 2) View scheduled maintenance activities, 3) Track maintenance operation progress, 4) Plan database maintenance tasks. The tool provides visibility into database maintenance state and scheduling.

Input Schema

Name	Required	Description	Default
`app`	Yes	Show current maintenance information for the app.
`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.

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "app": {
      "description": "Show current maintenance information for the app.",
      "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"
    }
  },
  "required": [
    "app"
  ],
  "type": "object"
}

Heroku MCP server

pg_maintenance

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Heroku MCP server

Related Tools