Skip to main content
Glama

Edit Database Schema

notion_schema
Destructive

Change Notion database properties: add, rename, delete, or adjust options, number formats, and descriptions, with dry-run previews and undo snapshots.

Instructions

Change a database's properties. action=add adds a property (same definition as notion_create_database). action=rename renames one. action=delete removes one: it defaults to a dry run showing how many rows have values, and snapshots up to 2000 rows' values so notion_undo can re-create the property and restore them. action=add_options adds select/multi-select/status options (status options take a group). action=set_number_format and action=set_description change those settings. Notion's API can't rename or recolor options (it ignores or rejects it); rename them in Notion, or add a new option, move rows with notion_bulk_update, and delete the old one in Notion.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
toNoaction=rename: new name.
actionYes
dry_runNoDefault true for delete, false otherwise.
optionsNoaction=add_options
databaseYes
propertyNoExisting property (every action except add).
definitionNoaction=add: the new property.
descriptionNo
number_formatNo
data_source_nameNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.10.0

TDQS

A4.8/5.0
Behavior5/5

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

Annotations already flag destructiveHint=true and non-idempotent, and the description goes well beyond them: delete defaults to a dry run showing affected row counts and snapshots up to 2000 rows' values for notion_undo recovery. It also discloses a hard API limitation (options cannot be renamed or recolored; the API ignores or rejects it), which is genuinely new behavioral context.

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?

Front-loaded with the core action and one sentence per action variant, so every clause carries information. It is a dense single paragraph, though, and some clauses (the full option-recolor workaround) run long relative to their marginal selection value.

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 6-action, 10-parameter mutation tool with no output schema, the description covers dry-run defaults, undo/snapshot behavior, per-action parameter intent, and an API constraint. An agent has enough to choose the right action and predict side effects without further research.

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 50% across 10 parameters, and the description adds real meaning by mapping each action to the parameters it consumes (to=rename, property=existing property, definition=add, options=add_options). It does not mention data_source_name or clarify number_format/description handling for the settings actions, leaving minor gaps.

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

Purpose5/5

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

States a specific verb+resource ('Change a database's properties') and then enumerates every action the tool supports (add, rename, delete, add_options, set_number_format, set_description). It clearly distinguishes itself from siblings like notion_create_database and notion_update_properties via explicit cross-references.

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

Usage Guidelines5/5

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

Gives per-action guidance and names concrete alternatives: notion_create_database for the add definition syntax, notion_bulk_update to move rows when changing options, and notion_undo to re-create/restore a deleted property. It even explains when NOT to expect a capability (rename/recolor of options) and prescribes the workaround.

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