Skip to main content
Glama

add_column

Add a new typed column to an existing dataset and backfill existing rows with the column's default value (or null). Use this to start tracking new attributes in your data.

Instructions

Add a new typed column to an existing dataset.

Existing rows are backfilled with the column's default value, or null when no default is set. Use this when the user wants to start tracking something new in an existing dataset ("also note each candidate's expected salary").

Args: dataset: Exact dataset name, e.g. "Candidates". column: The new column definition (same shape as in create_dataset).

Returns: {"ok": true, "dataset", "column", "type", "backfilled_rows": } on success, {"ok": false, "error": ""} when the column already exists or the definition is invalid (e.g. enum without options).

Example: add_column(dataset="Candidates", column={"name": "expected_salary", "type": "float", "min_value": 0})

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
columnYes
datasetYes

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Behavior4/5

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

With no annotations provided, the description carries the full burden of behavioral disclosure. It explains the important side effect that existing rows are backfilled with the column's default value or null, and it documents both success and failure return shapes, including specific failure reasons such as duplicate columns and invalid enum definitions. It omits permission or reversibility details but covers the core mutation behavior well.

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

Conciseness5/5

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

The description is well-organized: purpose, behavioral consequence, usage trigger, arguments, return values, and example. Every section earns its place, and the key facts are front-loaded rather than buried. There is no redundant or filler content.

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

Completeness4/5

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

For a two-parameter mutation tool with no annotations and an opaque column object schema, the description covers backfill behavior, success and error returns, failure triggers, and a runnable example. It is not fully self-contained because the complete column definition shape lives in create_dataset, but it gives enough pointers for an agent to proceed.

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?

The input schema has 0% description coverage, so the description must compensate. It meaningfully describes dataset as needing the exact name, and it explains that column uses the same shape as create_dataset, backed by an example. However, the full column definition is delegated to another tool rather than documented here, so agents still need cross-tool context to construct valid column objects.

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?

The description states a specific action, 'Add a new typed column to an existing dataset', making both the resource and operation explicit. The use case 'start tracking something new in an existing dataset' and the concrete natural-language example further clarify its scope and distinguish it from sibling tools like update_column, remove_column, and create_dataset.

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?

It gives a clear trigger condition: 'Use this when the user wants to start tracking something new in an existing dataset', including a sample user request. It does not explicitly name alternatives or say when not to use this tool, but the situational guidance is unambiguous enough for selection.

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/kanishk393/mdm-mcp'

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