pg_info

MCP tool from Heroku MCP Server by heroku

Display detailed database information.

How to use it

Project documentation lists pg_info for the Heroku MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Heroku MCP Server

$npx @modelcontextprotocol/inspector heroku-mcp-server
FULL HEROKU MCP SERVER LISTING

Other tools in Heroku MCP Server (32)

Add-ons
create_addon

Provision a new add-on for an app.

create_app

Create a new app with customizable settings for region, team, and space.

deploy_one_off_dyno

Execute code or commands in a sandboxed environment on a Heroku one-off dyno. Supports file

deploy_to_heroku

Deploy projects to Heroku with an app.json configuration, supporting team deployments, private

get_addon_info

Get detailed information about a specific add-on.

get_app_info

Get detailed information about an app, including its configuration, dynos, and add-ons.

get_app_logs

View application logs.

list_addons

List all add-ons for all apps or for a specific app.

list_apps

List all Heroku apps. You can filter apps by personal, collaborator, team, or space.

list_private_spaces

List available spaces.

list_teams

List teams you belong to.

maintenance_off

Disable maintenance mode for an app.

maintenance_on

Enable maintenance mode for an app.

pg_backups

Manage database backups and schedules.

pg_credentials

Manage database credentials and access.

pg_kill

Terminate specific database processes.

pg_locks

View database locks and identify blocking transactions.

pg_maintenance

Show database maintenance information.

pg_outliers

Identify resource-intensive queries.

pg_ps

View active queries and execution details.

pg_psql

Execute SQL queries against the Heroku PostgreSQL database.

pg_upgrade

Upgrade PostgreSQL to a newer version.

pipelines_create

Create a new pipeline.

pipelines_info

Get detailed pipeline information.

pipelines_list

List available pipelines.

pipelines_promote

Promote apps to the next stage in a pipeline.

ps_list

List all dynos for an app.

ps_restart

Restart specific dynos, process types, or all dynos.

ps_scale

Scale the number of dynos up or down, or resize dynos.

rename_app

Rename an existing app.

transfer_app

Transfer ownership of an app to another user or team.