Skip to main content
Glama
appwrite

Appwrite MCP Server

Official
by appwrite

tables_db_upsert_row

Insert new data or modify existing records in Appwrite database tables using a single API operation to maintain data integrity.

Instructions

Create or update a Row. Before using this route, you should create a new table resource using either a server integration API or directly from your database console.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
database_idYesDatabase ID.
table_idYesTable ID.
row_idYesRow ID.
dataNoRow data as JSON object. Include all required columns of the row to be created or updated.
permissionsNoAn array of permissions strings. By default, the current permissions are inherited. [Learn more about permissions](https://appwrite.io/docs/permissions).
transaction_idNoTransaction ID for staging the operation.
Behavior2/5

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

No annotations are provided, so the description carries the full burden of behavioral disclosure. It mentions the tool's purpose and a prerequisite but lacks critical behavioral details: it doesn't specify if this is a read/write operation, what permissions are needed, whether it's idempotent, error handling, or what the response looks like. For a mutation tool with zero annotation coverage, this is a significant gap in transparency.

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?

The description is concise and front-loaded, with the core purpose stated first: 'Create or update a Row.' The second sentence provides necessary prerequisite information. There's no wasted text, and both sentences earn their place by clarifying usage context. It could be slightly more structured by explicitly separating purpose from guidelines, but it's efficient overall.

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

Completeness2/5

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

Given the tool's complexity (6 parameters, mutation operation, no output schema, and no annotations), the description is incomplete. It covers the basic purpose and a prerequisite but misses critical context: behavioral traits (e.g., idempotency, error handling), output expectations, and differentiation from sibling tools. For a mutation tool in a rich sibling set, this leaves too many gaps for effective agent use.

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

Parameters3/5

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

Schema description coverage is 100%, meaning all parameters are documented in the schema itself. The description adds minimal value beyond the schema—it mentions 'Row data as JSON object' and 'permissions' in passing but doesn't provide additional context like format examples or usage tips. With high schema coverage, the baseline score of 3 is appropriate as the description doesn't significantly enhance parameter understanding.

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 the tool's purpose: 'Create or update a Row.' It specifies the verb ('Create or update') and resource ('Row'), making it easy to understand. However, it doesn't explicitly differentiate from sibling tools like 'tables_db_create_row' or 'tables_db_update_row', which handle only creation or only update respectively, so it falls short of a perfect score.

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

Usage Guidelines3/5

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

The description provides some usage guidance by mentioning prerequisites: 'Before using this route, you should create a new table resource...' This implies when to use it in a workflow. However, it doesn't clarify when to choose this tool over alternatives like 'tables_db_create_row' or 'tables_db_update_row', nor does it specify exclusions or edge cases, leaving usage context partially implied.

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/appwrite/mcp-for-api'

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