Cursor repairs a Postgres Terraform apply

Weston Platter tested Cursor Agent mode with a Terraform MCP server to provision a local Postgres database, schema and application role. The deployment eventually worked, but the MCP interface initially hid the errors needed to diagnose it.

Platter wrote the Terraform configuration and connected tfmcp to the correct directory and executable path. When the agent ran apply, it did not clearly report whether the operation had succeeded. Running the command directly exposed a permissions error: the administrative user lacked the privileges to create roles and databases. Platter granted those privileges himself through psql.

A second apply still failed through MCP without a useful error. Cursor suggested switching to its terminal Run capability. With the actual output visible, it identified a working provider configuration change, setting superuser to false. The author then applied the changes successfully and returned to tfmcp for later operations.

The author says this setup did not make the task easier than familiar command-line tools. Its useful contribution was interpreting an exposed error and proposing a repair. This was a local infrastructure experiment with deliberately insecure demonstration credentials, not a recommended production configuration. Human database expertise and permission changes remained necessary.

Prompt
Suggested prompt (written by Agents In Use, not the author's)

Source: masterpoint.io · Weston Platter