Skip to main content
Glama

update_dataset

Update an existing dataset's SQL query, name, or description. Changes take effect on next chart refresh. Use dry_run to validate without making changes.

Instructions

Update an existing dataset's SQL, name, or description.

Use list_datasets to find the dataset_id. After updating the SQL, any charts built on this dataset will reflect the new data on their next refresh.

Args: dataset_id: ID of the dataset to update sql: New SQL query (replaces existing) name: New display name description: New description override_columns: If True, refresh column metadata from the new SQL (recommended when changing SQL) dry_run: If True, validate inputs, capture current state, and check dependencies without making any changes (default: False)

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
dataset_idYes
sqlNo
nameNo
descriptionNo
override_columnsNo
dry_runNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes
Behavior4/5

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

With no annotations, the description carries the full burden. It discloses that updating SQL causes charts to refresh on next refresh and explains the dry_run behavior. Missing authorization needs or potential column metadata loss, but the provided details are valuable.

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 front-loaded with the purpose, then a usage hint, a behavioral note, and a clear parameter list. Every sentence adds value, no redundancy, and it's appropriately sized for the tool's complexity.

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?

The description covers purpose, prerequisite, side effect, and all parameters. The output schema exists, so return value documentation is not required. Minor gaps like permissions or reversibility are missing, but overall it's thorough given the complexity.

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

Parameters5/5

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

The input schema has 0% description coverage, but the description's Args section fully explains each of the 6 parameters, including purpose and recommendations (e.g., override_columns recommended when changing SQL). This adds significant meaning beyond the schema.

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 it updates an existing dataset's SQL, name, or description. This verb+resource combination distinguishes it from create_dataset (creates new) and get_dataset (reads), and it is specific among sibling update tools.

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?

The description advises using list_datasets to find the dataset_id, providing a clear prerequisite. However, it does not explicitly mention when not to use or list alternatives, though the context of updating versus creating or querying is 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/Evan-Kim2028/preset-mcp'

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