Skip to main content
Glama
Sign In
Senado BR — Brazilian Federal Senate Open Data

Senado BR — Brazilian Federal Senate Open Data

by SidneyBissoli
OverviewSchemaSourceRelated ServersDiscussionsAdmin
TypeScript
Remote

Horas extras de servidores

senado_horas_extras
Read-onlyIdempotent

Retrieve and analyze overtime payments to Brazilian Federal Senate employees by year and month since 2013, filter by name, and compute totals, rankings, or distribution statistics.

Instructions

Horas extras pagas a servidores do Senado em ano/mes de referência (a partir de 2013). Para perguntas de maior/menor/média/mediana/distribuição/ranking ('quem recebeu mais horas extras', 'valor mediano de hora extra', 'distribuição dos pagamentos') use estatisticas=true: computa min/máx/média/mediana/desvio/percentis sobre TODAS as linhas filtradas (valorTotal) e devolve top/bottom (padrão 10) com identificadores. Sem agruparPor → distribuicao das linhas individuais + top/bottom; com agruparPor (nome/competencia) → grupos[] ranqueados por soma decrescente (grupos[0] = quem mais recebeu; por nome soma as linhas do mesmo servidor no mês), cada um com sua mini-distribuição. Sem estatisticas: retorna { ano, mes, count, total, valorTotal, horasExtras[] }, onde valorTotal soma o gasto do mês e cada item traz nome, valorTotal, horasExtras, competencia e pagamento. Filtro opcional por nome (busca parcial) e limite (padrão 100, máx 500; ignorado quando estatisticas=true). Para a remuneração completa do servidor use senado_remuneracoes_servidores.

Input Schema

NameRequiredDescriptionDefault
anoYesAno de referência
mesYesMês de referência
nomeNoNome do servidor (busca parcial)
topNNoTamanho das listas top/bottom quando estatisticas=true sem agruparPor (padrão: 10, máx: 100)
limiteNoMáximo de resultados (padrão: 100; ignorado quando estatisticas=true)
agruparPorNoQuando estatisticas=true, ranqueia os grupos por soma decrescente (grupos[0] = quem mais recebeu): `nome` soma as linhas do mesmo servidor no mês, `competencia` agrupa por mês de prestação. Cada grupo traz sua mini-distribuição
estatisticasNoComputa estatísticas (min/máx/média/mediana/percentis) + ranking top/bottom sobre todas as linhas filtradas. Use para 'quem recebeu mais/menos', 'média', 'mediana', 'ranking'

Output Schema

NameRequiredDescriptionDefault
provenanceYesBloco de proveniência do portfólio (projeção concise): source, source_url, data_vintage, retrieved_at (horário de Brasília), citation, license, revision e retrieval; field_sources só quando a resposta funde recortes, derived e derivation_note só nos modos de estatísticas. retrieval é o diagnóstico da ida à origem nesta chamada — requisições, tentativas com retentativas, anomalias superadas (timeout, network, rate_limited, http_5xx, http_4xx, malformed_body) e unstable (true quando algo precisou ser repetido) —, ou null quando não foi medido. Lista de blocos quando a chamada consulta várias fontes (índice do search).
attributionYesURLs de origem dos dados (as source_url distintas dos blocos de proveniência, incluindo as de field_sources), para linkar a citação

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed2 schema fields changedv3.23.0
    • addedOutput schema / properties / attribution / description
      Added value: +"URLs de origem dos dados (as source_url distintas dos blocos de proveniência, incluindo as de field_sources), para linkar a citação"
    • addedOutput schema / properties / provenance / description
      Added value: +"Bloco de proveniência do portfólio (projeção concise): source, source_url, data_vintage, retrieved_at (horário de Brasília), citation, license, revision e retrieval; field_sources só quando a resposta funde recortes, derived e derivation_note só nos modos de estatísticas. retrieval é o diagnóstico da ida à origem nesta chamada — requisições, tentativas com retentativas, anomalias superadas (timeout, network, rate_limited, http_5xx, http_4xx, malformed_body) e unstable (true quando algo precisou ser repetido) —, ou null quando não foi medido. Lista de blocos quando a chamada consulta várias fontes (índice do search)."
  2. Changed1 schema field changedv3.18.4
    • changedOutput schema / properties / provenance / anyOf
      Previous value: -[
-  {
-    "additionalProperties": false,
-    "properties": {
-      "citation": {
-        "type": "string"
-      },
-      "data_vintage": {
-        "type": [
-          "string",
-          "null"
-        ]
-      },
-      "field_sources": {
-        "items": {
-          "additionalProperties": false,
-          "properties": {
-            "data_vintage": {
-              "type": [
-                "string",
-                "null"
-              ]
-            },
-            "dataset_id": {
-              "type": [
-                "string",
-                "null"
-              ]
-            },
-            "fields": {
-              "items": {
-                "type": "string"
-              },
-              "minItems": 1,
-              "type": "array"
-            },
-            "retrieved_at": {
-              "type": [
-                "string",
-                "null"
-              ]
-            },
-            "served_from_cache": {
-              "type": [
-                "boolean",
-                "null"
-              ]
-            },
-            "source_url": {
-              "type": "string"
-            }
-          },
-          "required": [
-            "fields",
-            "source_url",
-            "dataset_id",
-            "data_vintage",
-            "retrieved_at"
-          ],
-          "type": "object"
-        },
-        "minItems": 1,
-        "type": "array"
-      },
-      "license": {
-        "type": [
-          "string",
-          "null"
-        ]
-      },
-      "retrieval": {
-        "anyOf": [
-          {
-            "additionalProperties": false,
-            "properties": {
-              "anomalies": {
-                "items": {
-                  "additionalProperties": false,
-                  "properties": {
-                    "count": {
-                      "maximum": 9007199254740991,
-                      "minimum": 1,
-                      "type": "integer"
-                    },
-                    "kind": {
-                      "enum": [
-                        "timeout",
-                        "network",
-                        "http_4xx",
-                        "http_5xx",
-                        "rate_limited",
-                        "malformed_body"
-                      ],
-                      "type": "string"
-                    }
-                  },
-                  "required": [
-                    "kind",
-                    "count"
-                  ],
-                  "type": "object"
-                },
-                "type": "array"
-              },
-              "attempts": {
-                "maximum": 9007199254740991,
-                "minimum": 1,
-                "type": "integer"
-              },
-              "requests": {
-                "maximum": 9007199254740991,
-                "minimum": 1,
-                "type": "integer"
-              },
-              "unstable": {
-                "type": "boolean"
-              }
-            },
-            "required": [
-              "requests",
-              "attempts",
-              "anomalies",
-              "unstable"
-            ],
-            "type": "object"
-          },
-          {
-            "type": "null"
-          }
-        ]
-      },
-      "retrieved_at": {
-        "type": "string"
-      },
-      "source": {
-        "type": "string"
-      },
-      "source_url": {
-        "type": "string"
-      }
-    },
-    "required": [
-      "source",
-      "source_url",
-      "data_vintage",
-      "retrieved_at",
-      "retrieval",
-      "citation",
-      "license"
-    ],
-    "type": "object"
-  },
-  {
-    "items": {
-      "additionalProperties": false,
-      "properties": {
-        "citation": {
-          "type": "string"
-        },
-        "data_vintage": {
-          "type": [
-            "string",
-            "null"
-          ]
-        },
-        "field_sources": {
-          "items": {
-            "additionalProperties": false,
-            "properties": {
-              "data_vintage": {
-                "type": [
-                  "string",
-                  "null"
-                ]
-              },
-              "dataset_id": {
-                "type": [
-                  "string",
-                  "null"
-                ]
-              },
-              "fields": {
-                "items": {
-                  "type": "string"
-                },
-                "minItems": 1,
-                "type": "array"
-              },
-              "retrieved_at": {
-                "type": [
-                  "string",
-                  "null"
-                ]
-              },
-              "served_from_cache": {
-                "type": [
-                  "boolean",
-                  "null"
-                ]
-              },
-              "source_url": {
-                "type": "string"
-              }
-            },
-            "required": [
-              "fields",
-              "source_url",
-              "dataset_id",
-              "data_vintage",
-              "retrieved_at"
-            ],
-            "type": "object"
-          },
-          "minItems": 1,
-          "type": "array"
-        },
-        "license": {
-          "type": [
-            "string",
-            "null"
-          ]
-        },
-        "retrieval": {
-          "anyOf": [
-            {
-              "additionalProperties": false,
-              "properties": {
-                "anomalies": {
-                  "items": {
-                    "additionalProperties": false,
-                    "properties": {
-                      "count": {
-                        "maximum": 9007199254740991,
-                        "minimum": 1,
-                        "type": "integer"
-                      },
-                      "kind": {
-                        "enum": [
-                          "timeout",
-                          "network",
-                          "http_4xx",
-                          "http_5xx",
-                          "rate_limited",
-                          "malformed_body"
-                        ],
-                        "type": "string"
-                      }
-                    },
-                    "required": [
-                      "kind",
-                      "count"
-                    ],
-                    "type": "object"
-                  },
-                  "type": "array"
-                },
-                "attempts": {
-                  "maximum": 9007199254740991,
-                  "minimum": 1,
-                  "type": "integer"
-                },
-                "requests": {
-                  "maximum": 9007199254740991,
-                  "minimum": 1,
-                  "type": "integer"
-                },
-                "unstable": {
-                  "type": "boolean"
-                }
-              },
-              "required": [
-                "requests",
-                "attempts",
-                "anomalies",
-                "unstable"
-              ],
-              "type": "object"
-            },
-            {
-              "type": "null"
-            }
-          ]
-        },
-        "retrieved_at": {
-          "type": "string"
-        },
-        "source": {
-          "type": "string"
-        },
-        "source_url": {
-          "type": "string"
-        }
-      },
-      "required": [
-        "source",
-        "source_url",
-        "data_vintage",
-        "retrieved_at",
-        "retrieval",
-        "citation",
-        "license"
-      ],
-      "type": "object"
-    },
-    "minItems": 1,
-    "type": "array"
-  }
-]New value: +[
+  {
+    "additionalProperties": false,
+    "properties": {
+      "citation": {
+        "type": "string"
+      },
+      "data_vintage": {
+        "type": [
+          "string",
+          "null"
+        ]
+      },
+      "derivation_note": {
+        "type": "string"
+      },
+      "derived": {
+        "type": "boolean"
+      },
+      "field_sources": {
+        "items": {
+          "additionalProperties": false,
+          "properties": {
+            "data_vintage": {
+              "type": [
+                "string",
+                "null"
+              ]
+            },
+            "dataset_id": {
+              "type": [
+                "string",
+                "null"
+              ]
+            },
+            "fields": {
+              "items": {
+                "type": "string"
+              },
+              "minItems": 1,
+              "type": "array"
+            },
+            "retrieved_at": {
+              "type": [
+                "string",
+                "null"
+              ]
+            },
+            "served_from_cache": {
+              "type": [
+                "boolean",
+                "null"
+              ]
+            },
+            "source_url": {
+              "type": "string"
+            }
+          },
+          "required": [
+            "fields",
+            "source_url",
+            "dataset_id",
+            "data_vintage",
+            "retrieved_at"
+          ],
+          "type": "object"
+        },
+        "minItems": 1,
+        "type": "array"
+      },
+      "license": {
+        "type": [
+          "string",
+          "null"
+        ]
+      },
+      "notices": {
+        "items": {
+          "type": "string"
+        },
+        "minItems": 1,
+        "type": "array"
+      },
+      "retrieval": {
+        "anyOf": [
+          {
+            "additionalProperties": false,
+            "properties": {
+              "anomalies": {
+                "items": {
+                  "additionalProperties": false,
+                  "properties": {
+                    "count": {
+                      "maximum": 9007199254740991,
+                      "minimum": 1,
+                      "type": "integer"
+                    },
+                    "kind": {
+                      "enum": [
+                        "timeout",
+                        "network",
+                        "http_4xx",
+                        "http_5xx",
+                        "rate_limited",
+                        "malformed_body"
+                      ],
+                      "type": "string"
+                    }
+                  },
+                  "required": [
+                    "kind",
+                    "count"
+                  ],
+                  "type": "object"
+                },
+                "type": "array"
+              },
+              "attempts": {
+                "maximum": 9007199254740991,
+                "minimum": 1,
+                "type": "integer"
+              },
+              "requests": {
+                "maximum": 9007199254740991,
+                "minimum": 1,
+                "type": "integer"
+              },
+              "unstable": {
+                "type": "boolean"
+              }
+            },
+            "required": [
+              "requests",
+              "attempts",
+              "anomalies",
+              "unstable"
+            ],
+            "type": "object"
+          },
+          {
+            "type": "null"
+          }
+        ]
+      },
+      "retrieved_at": {
+        "type": "string"
+      },
+      "revision": {
+        "additionalProperties": false,
+        "properties": {
+          "note": {
+            "type": [
+              "string",
+              "null"
+            ]
+          },
+          "status": {
+            "enum": [
+              "current",
+              "provisional",
+              "final"
+            ],
+            "type": "string"
+          }
+        },
+        "required": [
+          "status",
+          "note"
+        ],
+        "type": "object"
+      },
+      "source": {
+        "type": "string"
+      },
+      "source_url": {
+        "type": "string"
+      }
+    },
+    "required": [
+      "source",
+      "source_url",
+      "data_vintage",
+      "retrieved_at",
+      "retrieval",
+      "citation",
+      "license"
+    ],
+    "type": "object"
+  },
+  {
+    "items": {
+      "additionalProperties": false,
+      "properties": {
+        "citation": {
+          "type": "string"
+        },
+        "data_vintage": {
+          "type": [
+            "string",
+            "null"
+          ]
+        },
+        "derivation_note": {
+          "type": "string"
+        },
+        "derived": {
+          "type": "boolean"
+        },
+        "field_sources": {
+          "items": {
+            "additionalProperties": false,
+            "properties": {
+              "data_vintage": {
+                "type": [
+                  "string",
+                  "null"
+                ]
+              },
+              "dataset_id": {
+                "type": [
+                  "string",
+                  "null"
+                ]
+              },
+              "fields": {
+                "items": {
+                  "type": "string"
+                },
+                "minItems": 1,
+                "type": "array"
+              },
+              "retrieved_at": {
+                "type": [
+                  "string",
+                  "null"
+                ]
+              },
+              "served_from_cache": {
+                "type": [
+                  "boolean",
+                  "null"
+                ]
+              },
+              "source_url": {
+                "type": "string"
+              }
+            },
+            "required": [
+              "fields",
+              "source_url",
+              "dataset_id",
+              "data_vintage",
+              "retrieved_at"
+            ],
+            "type": "object"
+          },
+          "minItems": 1,
+          "type": "array"
+        },
+        "license": {
+          "type": [
+            "string",
+            "null"
+          ]
+        },
+        "notices": {
+          "items": {
+            "type": "string"
+          },
+          "minItems": 1,
+          "type": "array"
+        },
+        "retrieval": {
+          "anyOf": [
+            {
+              "additionalProperties": false,
+              "properties": {
+                "anomalies": {
+                  "items": {
+                    "additionalProperties": false,
+                    "properties": {
+                      "count": {
+                        "maximum": 9007199254740991,
+                        "minimum": 1,
+                        "type": "integer"
+                      },
+                      "kind": {
+                        "enum": [
+                          "timeout",
+                          "network",
+                          "http_4xx",
+                          "http_5xx",
+                          "rate_limited",
+                          "malformed_body"
+                        ],
+                        "type": "string"
+                      }
+                    },
+                    "required": [
+                      "kind",
+                      "count"
+                    ],
+                    "type": "object"
+                  },
+                  "type": "array"
+                },
+                "attempts": {
+                  "maximum": 9007199254740991,
+                  "minimum": 1,
+                  "type": "integer"
+                },
+                "requests": {
+                  "maximum": 9007199254740991,
+                  "minimum": 1,
+                  "type": "integer"
+                },
+                "unstable": {
+                  "type": "boolean"
+                }
+              },
+              "required": [
+                "requests",
+                "attempts",
+                "anomalies",
+                "unstable"
+              ],
+              "type": "object"
+            },
+            {
+              "type": "null"
+            }
+          ]
+        },
+        "retrieved_at": {
+          "type": "string"
+        },
+        "revision": {
+          "additionalProperties": false,
+          "properties": {
+            "note": {
+              "type": [
+                "string",
+                "null"
+              ]
+            },
+            "status": {
+              "enum": [
+                "current",
+                "provisional",
+                "final"
+              ],
+              "type": "string"
+            }
+          },
+          "required": [
+            "status",
+            "note"
+          ],
+          "type": "object"
+        },
+        "source": {
+          "type": "string"
+        },
+        "source_url": {
+          "type": "string"
+        }
+      },
+      "required": [
+        "source",
+        "source_url",
+        "data_vintage",
+        "retrieved_at",
+        "retrieval",
+        "citation",
+        "license"
+      ],
+      "type": "object"
+    },
+    "minItems": 1,
+    "type": "array"
+  }
+]
  3. Changed3 schema fields changedv3.15.2
    • addedOutput schema / properties / attribution
      Added value: +{
+  "items": {
+    "type": "string"
+  },
+  "type": "array"
+}
    • addedOutput schema / properties / provenance
      Added value: +{
+  "anyOf": [
+    {
+      "additionalProperties": false,
+      "properties": {
+        "citation": {
+          "type": "string"
+        },
+        "data_vintage": {
+          "type": [
+            "string",
+            "null"
+          ]
+        },
+        "field_sources": {
+          "items": {
+            "additionalProperties": false,
+            "properties": {
+              "data_vintage": {
+                "type": [
+                  "string",
+                  "null"
+                ]
+              },
+              "dataset_id": {
+                "type": [
+                  "string",
+                  "null"
+                ]
+              },
+              "fields": {
+                "items": {
+                  "type": "string"
+                },
+                "minItems": 1,
+                "type": "array"
+              },
+              "retrieved_at": {
+                "type": [
+                  "string",
+                  "null"
+                ]
+              },
+              "served_from_cache": {
+                "type": [
+                  "boolean",
+                  "null"
+                ]
+              },
+              "source_url": {
+                "type": "string"
+              }
+            },
+            "required": [
+              "fields",
+              "source_url",
+              "dataset_id",
+              "data_vintage",
+              "retrieved_at"
+            ],
+            "type": "object"
+          },
+          "minItems": 1,
+          "type": "array"
+        },
+        "license": {
+          "type": [
+            "string",
+            "null"
+          ]
+        },
+        "retrieval": {
+          "anyOf": [
+            {
+              "additionalProperties": false,
+              "properties": {
+                "anomalies": {
+                  "items": {
+                    "additionalProperties": false,
+                    "properties": {
+                      "count": {
+                        "maximum": 9007199254740991,
+                        "minimum": 1,
+                        "type": "integer"
+                      },
+                      "kind": {
+                        "enum": [
+                          "timeout",
+                          "network",
+                          "http_4xx",
+                          "http_5xx",
+                          "rate_limited",
+                          "malformed_body"
+                        ],
+                        "type": "string"
+                      }
+                    },
+                    "required": [
+                      "kind",
+                      "count"
+                    ],
+                    "type": "object"
+                  },
+                  "type": "array"
+                },
+                "attempts": {
+                  "maximum": 9007199254740991,
+                  "minimum": 1,
+                  "type": "integer"
+                },
+                "requests": {
+                  "maximum": 9007199254740991,
+                  "minimum": 1,
+                  "type": "integer"
+                },
+                "unstable": {
+                  "type": "boolean"
+                }
+              },
+              "required": [
+                "requests",
+                "attempts",
+                "anomalies",
+                "unstable"
+              ],
+              "type": "object"
+            },
+            {
+              "type": "null"
+            }
+          ]
+        },
+        "retrieved_at": {
+          "type": "string"
+        },
+        "source": {
+          "type": "string"
+        },
+        "source_url": {
+          "type": "string"
+        }
+      },
+      "required": [
+        "source",
+        "source_url",
+        "data_vintage",
+        "retrieved_at",
+        "retrieval",
+        "citation",
+        "license"
+      ],
+      "type": "object"
+    },
+    {
+      "items": {
+        "additionalProperties": false,
+        "properties": {
+          "citation": {
+            "type": "string"
+          },
+          "data_vintage": {
+            "type": [
+              "string",
+              "null"
+            ]
+          },
+          "field_sources": {
+            "items": {
+              "additionalProperties": false,
+              "properties": {
+                "data_vintage": {
+                  "type": [
+                    "string",
+                    "null"
+                  ]
+                },
+                "dataset_id": {
+                  "type": [
+                    "string",
+                    "null"
+                  ]
+                },
+                "fields": {
+                  "items": {
+                    "type": "string"
+                  },
+                  "minItems": 1,
+                  "type": "array"
+                },
+                "retrieved_at": {
+                  "type": [
+                    "string",
+                    "null"
+                  ]
+                },
+                "served_from_cache": {
+                  "type": [
+                    "boolean",
+                    "null"
+                  ]
+                },
+                "source_url": {
+                  "type": "string"
+                }
+              },
+              "required": [
+                "fields",
+                "source_url",
+                "dataset_id",
+                "data_vintage",
+                "retrieved_at"
+              ],
+              "type": "object"
+            },
+            "minItems": 1,
+            "type": "array"
+          },
+          "license": {
+            "type": [
+              "string",
+              "null"
+            ]
+          },
+          "retrieval": {
+            "anyOf": [
+              {
+                "additionalProperties": false,
+                "properties": {
+                  "anomalies": {
+                    "items": {
+                      "additionalProperties": false,
+                      "properties": {
+                        "count": {
+                          "maximum": 9007199254740991,
+                          "minimum": 1,
+                          "type": "integer"
+                        },
+                        "kind": {
+                          "enum": [
+                            "timeout",
+                            "network",
+                            "http_4xx",
+                            "http_5xx",
+                            "rate_limited",
+                            "malformed_body"
+                          ],
+                          "type": "string"
+                        }
+                      },
+                      "required": [
+                        "kind",
+                        "count"
+                      ],
+                      "type": "object"
+                    },
+                    "type": "array"
+                  },
+                  "attempts": {
+                    "maximum": 9007199254740991,
+                    "minimum": 1,
+                    "type": "integer"
+                  },
+                  "requests": {
+                    "maximum": 9007199254740991,
+                    "minimum": 1,
+                    "type": "integer"
+                  },
+                  "unstable": {
+                    "type": "boolean"
+                  }
+                },
+                "required": [
+                  "requests",
+                  "attempts",
+                  "anomalies",
+                  "unstable"
+                ],
+                "type": "object"
+              },
+              {
+                "type": "null"
+              }
+            ]
+          },
+          "retrieved_at": {
+            "type": "string"
+          },
+          "source": {
+            "type": "string"
+          },
+          "source_url": {
+            "type": "string"
+          }
+        },
+        "required": [
+          "source",
+          "source_url",
+          "data_vintage",
+          "retrieved_at",
+          "retrieval",
+          "citation",
+          "license"
+        ],
+        "type": "object"
+      },
+      "minItems": 1,
+      "type": "array"
+    }
+  ]
+}
    • addedOutput schema / required
      Added value: +[
+  "provenance",
+  "attribution"
+]
  4. Changed7 schema fields changedv3.9.0
    • changedInput schema / $schema
      Previous value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"
    • addedInput schema / additionalProperties
      Added value: +false
    • addedInput schema / properties / agruparPor
      Added value: +{
+  "description": "Quando estatisticas=true, ranqueia os grupos por soma decrescente (grupos[0] = quem mais recebeu): `nome` soma as linhas do mesmo servidor no mês, `competencia` agrupa por mês de prestação. Cada grupo traz sua mini-distribuição",
+  "enum": [
+    "nome",
+    "competencia"
+  ],
+  "type": "string"
+}
    • addedInput schema / properties / estatisticas
      Added value: +{
+  "default": false,
+  "description": "Computa estatísticas (min/máx/média/mediana/percentis) + ranking top/bottom sobre todas as linhas filtradas. Use para 'quem recebeu mais/menos', 'média', 'mediana', 'ranking'",
+  "type": "boolean"
+}
    • changedInput schema / properties / limite / description
      Previous value: -"Máximo de resultados (padrão: 100)"New value: +"Máximo de resultados (padrão: 100; ignorado quando estatisticas=true)"
    • addedInput schema / properties / topN
      Added value: +{
+  "default": 10,
+  "description": "Tamanho das listas top/bottom quando estatisticas=true sem agruparPor (padrão: 10, máx: 100)",
+  "maximum": 100,
+  "minimum": 1,
+  "type": "integer"
+}
    • changedOutput schema / $schema
      Previous value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"
  5. Changed2 schema fields changedv3.3.3
    • removedInput schema / additionalProperties
      Removed value: -false
    • changedOutput schema / additionalProperties
      Previous value: -trueNew value: +{}
  6. First observedv3.3.1

TDQS

A4.6/5.0
Behavior4/5

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

Annotations already declare readOnlyHint/idempotentHint/destructiveHint=false, so the safety bar is lower. The description still adds real behavioral context: the exact return shape in both modes, that limite is ignored when estatisticas=true, and that rankings are sorted descending with grupos[0] = top receiver. It does not mention pagination beyond limite or rate/latency, keeping it just short of 5.

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?

Purpose and the estatisticas decision are front-loaded, and every sentence carries information. It is dense and long, with several parenthetical asides, but there is little pure waste.

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

Completeness5/5

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

Covers the dual-mode behavior, the filters, the defaults/limits, the return contents, and the sibling alternative. Even though an output schema exists, the description supplies the mode-dependent shape an agent needs to interpret results, leaving no significant gap for a 7-param analytical tool.

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 coverage is 100%, so baseline is 3, but the description adds meaning beyond the schema: it explains what agruparPor actually does (nome sums a server's rows in the month; competencia groups by month of service) and how estatisticas interacts with topN/limite. This is genuine semantic elaboration, though not per-parameter exhaustive.

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?

Opens with a specific verb+resource ('Horas extras pagas a servidores do Senado') scoped by ano/mes from 2013, and explicitly routes to the sibling senado_remuneracoes_servidores for full remuneration. An agent can distinguish this from senado_remuneracoes_servidores and senado_servidores without opening a schema.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Gives explicit when-to-use branching: statistics questions (maior/menor/média/mediana/distribuição/ranking) → estatisticas=true, with quoted example queries; without agruparPor → distribuicao + top/bottom, with agruparPor → ranked grupos[]. It also names the sibling for a different need.

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