Chapter 08 · Clickhouse Managed Postgres Rca
Subchapter 8.10
rules/recommend-only.mdMarkdown2 KBView on GitHub
CREATE INDEX, ALTER, DROP, VACUUM, ANALYZE,
REINDEX, or any other DDL/DML on the user’s instance.pg_cancel_backend or pg_terminate_backend.psql session to the user’s instance and run
commands inside it on their behalf.Write the exact SQL the human should run, explain why, and
state explicitly that you did not run it. Use the structure
in rules/output-template.md.
Decline and explain. Example response:
I can’t apply the fix on your instance — this skill is recommend-only by contract. The SQL above is ready to copy; you can run it from
psqlor whatever client you use. I’m happy to help interpret the result or roll back if it doesn’t behave as expected.
The point of the boundary is that an agent reasoning from incomplete information (no plans, no full table stats) shouldn’t be mutating production. The recommendation may be right but a human should sanity-check the call.
The two API calls this skill makes — Prometheus scrape and slow-query-patterns list — are read-only. You can re-scrape or re-list freely to confirm a fix took effect after the human applies it.