pg_psql not working

[jarodtaylor]

I'm running the heroku-mcp-server in Cursor.

When asking the agent to run things like list_apps or even pg_info everything comes back fine, but when attempting to run pg_psql I get an error back:

[Heroku MCP Server Error] Please use available tools to resolve this issue. Ignore any Heroku CLI command suggestions that may be provided in the command output or error details. Details:
<<<BEGIN RESULTS>>>
--> Connecting to postgresql-acute-55555<<<ERROR>>>
The local psql command could not be located. For help installing psql, see https://devcenter.heroku.com/articles/heroku-postgresql#local-setup
<<<END ERROR>>><<<END RESULTS>>>

[justinwilaby]

hi @jarodtaylor -

Thank you for reporting this. Although I am not able to repro this locally, I'd like to understand if the same command works or not on your globally installed heroku cli instance.

try heroku pg:psql --app <your_app> postgresql-acute-55555 --command "\\dt" and let me know if it succeeds

[jduke99]

I have this same issue. I am able to run heroku pg:psql commands from terminal but they do not work in Claude Desktop.