pg_upgrade

Upgrade PostgreSQL database versions safely for Heroku apps. Plan migration paths, verify compatibility, and execute controlled upgrades with confirmation protection to ensure a secure transition.

Instructions

Upgrade PostgreSQL database version. Use this tool when you need to: 1) Migrate to a newer PostgreSQL version, 2) Plan version upgrade paths, 3) Execute controlled version migrations, 4) Verify upgrade compatibility. The tool manages safe database version upgrades with confirmation protection.

Input Schema

Name	Required	Description
`app`	Yes	The name of the Heroku app whose database to upgrade.
`confirm`	No	Confirmation string required for this potentially destructive operation.
`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.
`version`	No	PostgreSQL version to upgrade to

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 upgrade.",
      "type": "string"
    },
    "confirm": {
      "description": "Confirmation string required for this potentially destructive operation.",
      "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"
    },
    "version": {
      "description": "PostgreSQL version to upgrade to",
      "type": "string"
    }
  },
  "required": [
    "app"
  ],
  "type": "object"
}

Heroku MCP server

pg_upgrade

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Heroku MCP server

Related Tools