Skip to main content
Glama

transform_column_case

Change text case in a CSV column to uppercase, lowercase, title case, or capitalize sentences for data standardization and analysis.

Instructions

Transform the case of text in a column.

Returns: ColumnOperationResult with transformation details

Examples: # Convert to uppercase transform_column_case(ctx, "code", "upper")

# Convert names to title case
transform_column_case(ctx, "name", "title")

# Convert to lowercase for comparison
transform_column_case(ctx, "email", "lower")

# Capitalize sentences
transform_column_case(ctx, "description", "capitalize")

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
columnYesColumn name to transform text case in
transformYesCase transformation: upper, lower, title, or capitalize

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
successNoWhether operation completed successfully
operationYesType of operation performed
transformNoTransform description
part_indexNoPart index for split operations
nulls_filledNoNumber of null values filled
rows_removedNoNumber of rows removed (for remove_duplicates)
rows_affectedYesNumber of rows affected by operation
values_filledNoNumber of values filled (for fill_missing_values)
updated_sampleNoSample values after operation
original_sampleNoSample values before operation
columns_affectedYesNames of columns affected
Behavior3/5

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

With no annotations provided, the description carries the full burden. It discloses that the tool performs a transformation and returns a 'ColumnOperationResult', but does not detail behavioral traits such as error handling (e.g., what happens with non-text columns), permissions, or side effects. The examples add some context but leave gaps in operational 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 appropriately sized and front-loaded, starting with the core purpose followed by return details and examples. Each example sentence earns its place by demonstrating different use cases, though the structure could be slightly more streamlined by integrating examples more cohesively.

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?

Given the tool's moderate complexity (2 parameters, 100% schema coverage, and an output schema indicated as present), the description is mostly complete. It covers purpose, return type, and usage examples, but lacks details on error conditions or edge cases, which would be beneficial for full contextual understanding.

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 description coverage is 100%, so the schema already documents both parameters fully. The description adds minimal value beyond the schema by illustrating parameter usage in examples (e.g., showing 'upper' for uppercase transformation), but does not provide additional semantic context. With 0 parameters needing extra description, a baseline of 4 is appropriate.

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 clearly states the tool's purpose with a specific verb ('transform') and resource ('text in a column'), distinguishing it from siblings like 'strip_column' (which removes whitespace) or 'update_column' (which modifies values more broadly). It directly addresses what the tool does without being tautological.

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 implies usage through examples (e.g., 'Convert to uppercase' or 'Convert to lowercase for comparison'), but does not explicitly state when to use this tool versus alternatives like 'strip_column' for whitespace removal or 'replace_in_column' for text substitution. Guidance is contextual but lacks explicit exclusions or named alternatives.

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/jonpspri/databeak'

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