Skip to main content
Glama

etl_generate_transforms

Define source and target fields to generate data transformation functions with validation, mapping, and enrichment. Specify custom transformations to convert and prepare data.

Instructions

Generate data transformation functions with validation, mapping, and enrichment

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
api_keyNoAPI key for authentication
source_fieldsYesSource field names and types (e.g. 'first_name:string', 'created_at:timestamp')
target_fieldsYesTarget field names and types
transformationsNoSpecific transformations (e.g. 'concat first_name+last_name', 'parse date')
Behavior2/5

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

No annotations are provided, so the description must carry the behavioral disclosure burden. It states the tool generates transformation functions, implying a code-generation output, but it doesn't disclose side effects, whether it writes files, requires an API key, or how the transformations are returned. Without annotations, this is a significant gap.

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 a single concise sentence that front-loads the main purpose and names key features. It earns its place with no filler, though it could have used the spare space to add usage or output context.

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

Completeness3/5

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

The tool has 4 parameters, 2 required, no output schema, and no annotations. The description covers the broad purpose and the schema covers the parameters, but the agent lacks information about the return value, side effects, and how the 'api_key' parameter relates to the generation process. For a generation tool with no output schema, this is a noticeable completeness gap.

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%, and the schema includes helpful descriptions for source_fields, target_fields, and transformations with examples. The description adds the concepts of validation, mapping, and enrichment, which loosely map to the parameters, but it mostly repeats what the schema already says. Baseline 3 is appropriate because the schema carries the semantic load.

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, 'Generate data transformation functions with validation, mapping, and enrichment,' identifies a clear verb and resource, and says the tool produces transformation functions with specific features. It doesn't explicitly differentiate itself from siblings like mapper_generate_transforms or etl_design_pipeline, but it is specific enough on its own.

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 when to use it—when generating transformations with validation, mapping, and enrichment—but provides no explicit guidance on when not to use it or which sibling tools are alternatives. Given the large sibling list with similar ETL/mapping tools, explicit exclusions would help.

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/barnburner121/claude-plugin-marketplace'

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