Skip to main content
Glama

Dados Abertos Senado BR MCP

Execução orçamentária do Senado

senado_execucao_orcamentaria
Read-onlyIdempotent

Execução orçamentária do Senado: despesas (dotação, empenhado, liquidado, pago; desde 2013) ou receitas próprias (previstas e arrecadadas; desde 2012). Para maior/menor/média/mediana/distribuição/ranking ('quanto o Senado pagou/arrecadou com X', 'maior grupo de despesa') use estatisticas=true: SEM agruparPor = distribuição das linhas (min/máx/média/mediana/percentis) + top/bottom; COM agruparPor = grupos ranqueados por soma decrescente (grupos[0]=maior). A coluna de valor analisada é escolhida automaticamente conforme o tipo; o resultado já traz o rótulo legível dela em campoAnalisado. Retorna { tipo, modo, ano, totalLinhas, ... }: nos modos agregados, agregado[] com { chave, ...valores } ordenado por valor; em detalhe, despesas[]/receitas[] limitado por limite (padrão 100, com aviso ao truncar). Use tipo=despesas com modo por-ano/por-acao/por-grupo/por-fonte e tipo=receitas com por-origem; filtre por ano para reduzir o volume antes de pedir detalhe. O que cada número é: nas despesas, dotação/empenhado/liquidado/pago são ACUMULADOS no exercício até a data de posição do arquivo (o data_vintage da proveniência diz qual) — o exercício corrente é parcial e cresce; nas receitas, arrecadada é o valor do mês e prevista vem lançada inteira no mês 1. São os valores que o Senado publica na data de posição; lançamentos podem ser corrigidos depois. Única ferramenta de orçamento interno do Senado; não confundir com senado_orcamento_parlamentar (emendas/ofícios parlamentares ao orçamento da União).

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
anoNoFiltrar por exercício financeiro
modoNoAgregação (por-acao/por-grupo/por-fonte: despesas; por-origem: receitas) ou detalhe. Ignorado quando estatisticas=truepor-ano
tipoNodespesas = dotação e execução; receitas = receitas própriasdespesas
topNNoTamanho do top/bottom nas estatísticas (padrão: 10)
campoNoOpcional: força a coluna de valor analisada; por padrão ela é escolhida conforme o tipo. Se a opção não se aplicar ao tipo, o padrão é usado automaticamente.
limiteNoMáximo de linhas (padrão: 100)
agruparPorNoOpcional: agrupa e ranqueia os resultados por esta dimensão (as opções válidas dependem do tipo).
estatisticasNoDistribuição/ranking sobre as linhas: min/máx/média/mediana/percentis + top/bottom, ou grupos ranqueados por soma via agruparPor

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
provenanceYes
attributionYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed1 schema field changed
    • 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"
      +  }
      +]
  2. Changed1 schema field changed
    • changedOutput schema / properties / provenance / anyOf
      Previous value: -[
      -  {
      -    "additionalProperties": false,
      -    "properties": {
      -      "citation": {
      -        "type": "string"
      -      },
      -      "data_vintage": {
      -        "type": [
      -          "string",
      -          "null"
      -        ]
      -      },
      -      "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"
      -          ]
      -        },
      -        "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"
      +        ]
      +      },
      +      "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"
      +  }
      +]
  3. Changed3 schema fields changed
    • 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"
      +          ]
      +        },
      +        "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"
      +            ]
      +          },
      +          "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. Changed1 schema field changed
    • addedInput schema / additionalProperties
      Added value: +false
  5. Changed2 schema fields changed
    • changedInput schema / $schema
      Previous value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"
    • changedOutput schema / $schema
      Previous value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"
  6. Changed2 schema fields changed
    • changedInput schema / properties / agruparPor / description
      Previous value: -"Ranquear grupos por soma do campo (despesas: ano/acao/grupo/fonte/modalidade/resultadoLei/plano; receitas: origem/ano/categoria/especie/natureza)"New value: +"Opcional: agrupa e ranqueia os resultados por esta dimensão (as opções válidas dependem do tipo)."
    • changedInput schema / properties / campo / description
      Previous value: -"Coluna de valor para estatísticas (despesas padrão `pago`; receitas padrão `arrecadada`)"New value: +"Opcional: força a coluna de valor analisada; por padrão ela é escolhida conforme o tipo. Se a opção não se aplicar ao tipo, o padrão é usado automaticamente."
  7. Changed5 schema fields changed
    • addedInput schema / properties / agruparPor
      Added value: +{
      +  "description": "Ranquear grupos por soma do campo (despesas: ano/acao/grupo/fonte/modalidade/resultadoLei/plano; receitas: origem/ano/categoria/especie/natureza)",
      +  "enum": [
      +    "ano",
      +    "acao",
      +    "grupo",
      +    "fonte",
      +    "modalidade",
      +    "resultadoLei",
      +    "plano",
      +    "origem",
      +    "categoria",
      +    "especie",
      +    "natureza"
      +  ],
      +  "type": "string"
      +}
    • addedInput schema / properties / campo
      Added value: +{
      +  "description": "Coluna de valor para estatísticas (despesas padrão `pago`; receitas padrão `arrecadada`)",
      +  "enum": [
      +    "pago",
      +    "liquidado",
      +    "empenhado",
      +    "dotacaoInicial",
      +    "dotacaoAtualizada",
      +    "arrecadada",
      +    "prevista"
      +  ],
      +  "type": "string"
      +}
    • addedInput schema / properties / estatisticas
      Added value: +{
      +  "default": false,
      +  "description": "Distribuição/ranking sobre as linhas: min/máx/média/mediana/percentis + top/bottom, ou grupos ranqueados por soma via agruparPor",
      +  "type": "boolean"
      +}
    • changedInput schema / properties / modo / description
      Previous value: -"Agregação (por-acao/por-grupo/por-fonte: despesas; por-origem: receitas) ou detalhe"New value: +"Agregação (por-acao/por-grupo/por-fonte: despesas; por-origem: receitas) ou detalhe. Ignorado quando estatisticas=true"
    • addedInput schema / properties / topN
      Added value: +{
      +  "default": 10,
      +  "description": "Tamanho do top/bottom nas estatísticas (padrão: 10)",
      +  "maximum": 100,
      +  "minimum": 1,
      +  "type": "integer"
      +}
  8. Changed2 schema fields changed
    • removedInput schema / additionalProperties
      Removed value: -false
    • changedOutput schema / additionalProperties
      Previous value: -trueNew value: +{}
  9. Changed1 schema field changed
    • changedOutput schema / (root)
      Previous value: -nullNew value: +{
      +  "$schema": "http://json-schema.org/draft-07/schema#",
      +  "additionalProperties": true,
      +  "properties": {},
      +  "type": "object"
      +}
  10. First observed

TDQS

A4.8/5.0
Behavior5/5

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

With annotations already covering the read-only/idempotent safety profile, the description adds substantive behavior: expense figures are accumulated within the exercise up to the file's position date, the current exercise is partial and growing, revenue `arrecadada` is monthly while `prevista` is booked whole in month 1, values can be revised later, and `limite` truncation emits an `aviso`. This is exactly the kind of beyond-annotation context the dimension rewards.

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 text is long but densely front-loaded: purpose first, then estatisticas/agruparPor behavior, then return shape, then field semantics, then the sibling disambiguation. For an 8-parameter tool with six modes this size is justified, though a few clauses could be tightened.

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?

Despite an output schema existing, the description still orients the agent on the response shape (`agregado[]` ordering, `detalhe` arrays capped by `limite`) and the vintage/provenance semantics of each metric. Nothing needed to call it correctly — modes, filters, stats flag, value-column selection — is missing.

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 the baseline is 3, but the description adds cross-parameter semantics not obvious from the schema alone: the analyzed value column is auto-chosen per `tipo` and surfaced in `campoAnalisado`, `modo` is ignored when `estatisticas=true`, and `agruparPor` reranks groups by descending sum (grupos[0]=maior). These interactions meaningfully supplement the parameter docs.

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?

States a specific verb+resource (execução orçamentária do Senado, despesas vs receitas próprias) and explicitly differentiates from the one confusable sibling `senado_orcamento_parlamentar` with a clear rationale (emendas/ofícios ao orçamento da União). An agent can select it without opening the 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 routing conditions: use `estatisticas=true` for maior/menor/média/mediana/distribuição/ranking, with and without `agruparPor`; use `tipo=despesas` with specific `modo` values vs `tipo=receitas`; and filter by `ano` before requesting `detalhe` to reduce volume. It also names the tool this one should not be confused with.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.