{"serverId":"mcp-registry/com.vetosql/veto","tools":[{"name":"analyze_sql","fixed":{"name":"analyze_sql","description":"Analyze Postgres SQL/migrations for destructive operations, locking risk, correctness traps (NULL handling that silently returns wrong results), anti-patterns, and query cost. Returns a deterministic verdict (ok/warn/block) with findings. Pass the optional `schema` argument (your CREATE TABLE/INDEX DDL) to also get EXPLAIN-based cost analysis run on a throwaway scratch Postgres — no separate tool or DB connection needed.","inputSchema":{"type":"object","$schema":"http://json-schema.org/draft-07/schema#","required":["sql"],"properties":{"sql":{"type":"string","description":"The SQL to analyze (one or more statements)."},"schema":{"type":"string","description":"Optional CREATE TABLE/INDEX DDL. Providing it enables EXPLAIN-based cost analysis (seq scans on large tables, etc.) on a throwaway scratch Postgres; omit it for static safety analysis only."},"dialect":{"type":"string","const":"postgres"},"rowCountHints":{"type":"object","description":"Optional map of table name to estimated row count for realistic cost estimates.","additionalProperties":{"type":"number"}}},"additionalProperties":false},"annotations":{"readOnlyHint":true},"title":"Analyze SQL safety & cost"},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":319,"tokensAfter":319},{"name":"get_policies","fixed":{"name":"get_policies","description":"Return the custom org policy set currently stored for your Pro key — the same rules analyze_sql enforces on top of the built-ins. Read-only; returns an empty list if none are set. Use set_policies to change them.","inputSchema":{"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{}},"annotations":{"readOnlyHint":true},"title":"Get custom org policies (Pro)"},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":98,"tokensAfter":98},{"name":"set_policies","fixed":{"name":"set_policies","description":"Replace the stored custom org policy set for your Pro key (this is also how you update or clear them: send the full new set to update, or an empty array to remove all). Each policy blocks or warns on an operation against matching tables (e.g. no DELETE on payments). Policies are declarative data — validated, never executed — and apply transparently to every later analyze_sql call made with this key. Use get_policies to read the current set.","inputSchema":{"type":"object","$schema":"http://json-schema.org/draft-07/schema#","required":["policies"],"properties":{"policies":{"type":"array","items":{"type":"object","required":["table","operations","action"],"properties":{"table":{"type":"string","description":"Exact table name or glob, e.g. \"payments\", \"audit_*\", \"*\"."},"action":{"enum":["block","warn"],"type":"string"},"message":{"type":"string","description":"Optional human message shown in the finding."},"operations":{"type":"array","items":{"enum":["select","insert","update","delete","truncate","drop","alter"],"type":"string"},"description":"Operations this rule applies to."}},"additionalProperties":false},"description":"The full policy set (replaces any previously stored set; max 50)."}},"additionalProperties":false},"annotations":{"readOnlyHint":false,"destructiveHint":false,"idempotentHint":true},"title":"Set custom org policies (Pro)"},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: false, destructiveHint: false, idempotentHint: true (inferred from the name).","verify":true}],"tokensBefore":357,"tokensAfter":357}],"toolsChanged":3,"tokensSaved":0,"todo":[{"tool":"analyze_sql","params":["dialect"]}],"note":"Deterministic fixes. Changes marked verify need a human look before shipping (renames, inferred annotations, inferred types, removed text). Parameter descriptions in `todo` need to be written by someone who knows the API."}