Skip to main content
Glama
patrickdeanfox

Zuar Portal Blocks MCP Server

Run a database modification

run_db_modification
Destructive

Execute a saved database modification (INSERT/UPDATE/DELETE) by name. Requires confirmation and safeguards against unfiltered mass writes.

Instructions

Execute a saved db_modification (INSERT/UPDATE/DELETE) by name. This WRITES to a database — and database writes have NO snapshot/rollback, unlike portal content. Requires data writes enabled (PORTAL_ALLOW_DATA_WRITES=1) and confirm=true. Refuses an unscoped mass write (UPDATE/DELETE/MERGE without a real WHERE — 1=1 doesn't count — TRUNCATE, DROP, ALTER…DROP, GRANT/REVOKE) unless allow_unfiltered=true; the check is a best-effort classifier and fails closed if the SQL can't be inspected. Pass params as a { name: value } map, or params_list for bulk rows.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
nameYesdb_modification name to run.
paramsNoSingle-row parameters as a { name: value } map.
confirmYesMust be true to actually run — guards against accidental DB writes.
autocommitNoCommit each statement (default portal behavior).
params_listNoBulk parameters: a list of { name: value } maps, one per row.
allow_unfilteredNoMust be true to run an UNSCOPED mass write (UPDATE/DELETE without WHERE, TRUNCATE, DROP). Default false.
ignore_sql_errorsNoContinue past SQL errors.
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Beyond annotations (destructiveHint=true), the description adds critical details: no snapshot/rollback, best-effort classifier for unscoped writes that fails closed, and parameter dependencies. No contradictions with annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Description is a single paragraph but front-loaded with purpose. Every sentence adds value, though it could be more structured (e.g., bullet points). Not overly verbose.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a complex tool with 7 params, no output schema, the description covers safety, parameter usage, and special conditions comprehensively. Leaves little ambiguity.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, baseline 3. The description adds meaning: explains how to pass params/params_list, the role of confirm, allow_unfiltered, and ignore_sql_errors. Provides usage context beyond schema descriptions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states it executes a saved db_modification (INSERT/UPDATE/DELETE) by name, which is specific. It doesn't explicitly differentiate from siblings like execute_query, but the context implies this is for writes.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides clear guidelines: requires data writes enabled, confirm=true, and explains safeguards for unscoped mass writes. Warns about no snapshot/rollback. Doesn't explicitly state when not to use, but context is adequate.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/patrickdeanfox/zuar-portal-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server