Skip to main content
Glama
tillbooks

tillbooks

Official

costing_pl_list

Read-only

Generate a margin-sorted revenue/cost/margin summary per project to identify which projects contribute most, with handling for closed projects and foreign currency.

Instructions

Projekterfolg-Portfolio (P&L list): one revenue/cost/margin summary row per project, margin-sorted (die Marge, descending), the read that answers "welche Projekte oder Mandate tragen?". Closed projects are excluded unless status='closed' asks for them; any single B00 status filters exactly. A project with foreign-currency rows degrades to fxBaseMissing:true instead of blanking the portfolio. savedViewId applies a G00 saved view over the project entity kind: its stored filters merge underneath any filter named explicitly here. Same computation and same honesty flags as costing_project_pl (basisDegraded when a cost-basis entry lacks a cost rate).

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
asOfNo
basisNo
statusNo
savedViewIdNo
workspaceIdYes
includeOpenTimeNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4/5.0
Behavior5/5

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

Beyond the readOnlyHint annotation, the description discloses significant non-obvious behaviors: margin-descending sort, closed-project exclusion unless status='closed', exact B00 filtering, degradation to fxBaseMissing for foreign-currency rows, saved view filter merging, and the basisDegraded honesty flag shared with costing_project_pl. These details substantially exceed the annotation baseline and materially aid an agent in interpreting results.

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

Conciseness3/5

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

The description is dense and information-rich, covering many edge cases, but it mixes German and English and uses cryptic codes (B00, G00) without explanation. The structure is logical—output shape, filtering, degradation, saved views, shared computation—but the phrasing is not lean and some sentences are overloaded. It earns its place but sacrifices readability.

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?

Given the tool's complexity (6 parameters, no output schema, no parameter descriptions), the description covers the output shape and several behavioral edge cases, but leaves core parameters undefined and does not describe the exact return fields. An agent can call it correctly for the covered filters but may misuse asOf, basis, or includeOpenTime. Incomplete but not severely so.

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

Parameters2/5

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

Schema description coverage is 0%, so the description carries the burden for all 6 parameters. It explains only status (via closed/B00 semantics) and savedViewId (merge behavior). The parameters asOf, basis, includeOpenTime, and workspaceId are never mentioned, leaving an agent guessing about their meaning and accepted values. This is a major gap for a tool with no schema descriptions.

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 verb and resource: it reads a portfolio of project P&L summaries, one row per project, sorted by margin descending. It directly answers the business question 'welche Projekte oder Mandate tragen?', and references sibling costing_project_pl to place itself as the portfolio-level version of the same computation, distinguishing it without ambiguity.

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 clear context: this is the read for portfolio-level project profitability, with explicit filter semantics for closed projects, B00 status, and saved view merging. It does not explicitly name alternatives or say when not to use it, but the referenced costing_project_pl and the portfolio framing imply the boundary. No contrary usage guidance is present.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools