C2026.6 Tools Reference

AtScale C2026.6 provides the following MCP Server tools.

list_models

Required params: None

Lists available AtScale models with column_groups for path validation. Returns model names, schemas, descriptions, and a column_groups mapping of dimension groups to fact datasets. Also populates the session model cache. Must be authenticated first.

describe_model

Required params: catalog, schema, table
Optional filters: folder, role, column_group, list_folders, force_refresh

Gets detailed column metadata for a model (dimensions and metrics). Returns TSV of column names, types, roles, and ColumnGroup. JSON also includes any calculation_group columns with member metadata (name, description, MDX expression).

search_columns

Required params: catalog, schema, table
Optional: query, queries

Searches columns by keyword in a model (case-insensitive; matches column name + description, and calculation group member name + description (e.g. "YTD" surfaces the parent calculation_group)). Returns matching columns as TSV.

validate_query

Required params: catalog, schema, table, columns

Checks column-path compatibility before executing. Returns valid=true, or valid=false with specific errors (missing columns, required_dimension violations). Also returns measure_groups / dimension_groups for path verification.

run_query

Required params: query

Executes a single SQL SELECT against AtScale. Returns TSV result rows. SELECT only.

run_queries

Required params: queries

Executes multiple SQL SELECT queries in one call (batch mode, max 10). Returns a JSON array of results in input order. Each carries index, query, and data or error. A failed query does not block the others. SELECT only.

get_version

Required params: None

Returns the MCP server version.