# Rondônia Dados Abertos MCP > Rondônia Dados Abertos lets you query official public records from the State of Rondônia directly through your AI agent. Check detailed state spending, track vendor payments, and pull payroll data for civil servants. You can also inspect active contracts and list all available datasets in the local catalog. ## Overview - **Category:** data-analytics - **Price:** Free - **Tags:** open-data, transparency, public-spending, ckan, data-query ## Description When you hook your AI agent up to **Rondônia Dados Abertos**, you get direct access to official public records from the State of Rondônia government. This isn't some general data dump; it’s a deep query engine letting you pull specific, auditable state information using natural language prompts. **list_datasets** lets you see every single dataset and theme available in the entire open data catalog. If you need to know what kind of public records exist, this is your starting point. You can then use `get_dataset` to dig into one specific record and retrieve its full details. To narrow down where that data came from, `list_organizations` lists every government or private group that contributed data; meanwhile, `list_groups` pulls out the thematic categories, helping you map exactly which topics are covered. Handling state finances? You've got three tools for the money trail. First, you use `list_despesas` to check detailed state expenses. This doesn't just give a total—it breaks down funds into committed amounts, liquidated sums, and actual payments made. Next, if you want to track how much cash the state brought in, `list_receitas` gives you data on collected state revenues over time. For direct spending records, `list_pagamentos_fornecedores` checks specific payment records issued by the Executive Branch straight to suppliers, letting you filter by date and value. To keep tabs on employees, you run `list_remuneracao_servidores`. This tool accesses state employee payroll data. You can filter those results using name, job title, or a precise time period—it's a detailed look at who gets paid what. When it comes to contracts and vendors, the system is built for auditing. `list_contratos` shows every active contract currently managed by the state executive branch. For cooperation agreements with outside groups, you use `list_convenios`. If you're checking vendor compliance, you can run `list_fornecedores_impedidos` to get a list of suppliers who are barred from bidding on new contracts; if you need to see why they’re blocked or when it happened, `list_historico_fornecedores_impedidos` gives you the full history record. The data also tracks payment flow: while `list_pagamentos_fornecedores` shows general payments, checking vendor status requires knowing who's in the system from `list_organizations` and what services they provided. You don't have to piece this together. Your AI client handles it all. You just point it at your agent, and you can query state spending mechanisms—the committed, liquidated, or paid funds—to get a complete picture of how public money moves through the system. This server lets you pull detailed payment records for specific vendors, letting you track every dime by date and amount. When reviewing payroll, you aren't limited to broad searches; you can filter results down using name, job title, or a specific month and year. It’s an absolute deep dive into government accountability. You map all the active contracts and cooperation agreements in one place, so there are no blind spots when tracking state business. It gives you full visibility across the entire catalog—from basic datasets to complex financial histories. ## Tools ### get_dataset Retrieves detailed information about one specific dataset in the public catalog. ### list_contratos Shows all active contracts currently managed by the state executive branch. ### list_convenios Consults records for cooperation agreements (convênios) signed with external parties. ### list_datasets Lists all available datasets and themes within the Rondônia open data catalog. ### list_despesas Checks detailed state expenses, including committed funds, liquidated amounts, and payments made. ### list_fornecedores_impedidos Lists suppliers who are currently barred from bidding on new contracts. ### list_groups Retrieves a list of thematic groups or categories available in the data catalog. ### list_historico_fornecedores_impedidos Consults the full history record for suppliers barred from bidding. ### list_organizations Lists all government or private organizations that have contributed data to the catalog. ### list_pagamentos_fornecedores Checks payment records made by the Executive Branch directly to suppliers. ### list_receitas Retrieves data on state revenues collected over time. ### list_remuneracao_servidores Accesses and lists payroll and remuneration data for all state employees. ## Prompt Examples **Prompt:** ``` List all datasets available in the Rondônia open data catalog. ``` **Response:** ``` I've retrieved the catalog. There are several datasets available, including 'Frequência de Servidores', 'Gastos com Diárias', and 'Obras Públicas'. Would you like details on a specific one? ``` **Prompt:** ``` Show me the payroll for state employees in January 2024. ``` **Response:** ``` Fetching payroll data for 2024-01... I found the records. You can see details for various departments. Do you want to search for a specific name or job title within this month? ``` **Prompt:** ``` Search for payments made to 'CONSTRUTORA' between 2023-01-01 and 2023-03-01. ``` **Response:** ``` I found several payment records for suppliers matching 'CONSTRUTORA' in that period. The largest payment was for R$ 150,000.00 from the 'Secretaria de Obras'. Would you like the full list of transactions? ``` ## Capabilities ### Track State Finances Query committed, liquidated, and paid state expenses, giving you a full picture of how public money moves. ### Audit Vendor Transactions Pull detailed records of payments made to specific suppliers, letting you track spending by date and amount. ### Review Payroll Records Search state employee remuneration data using filters for name, job title, or a specific time period. ### Map Government Agreements List and check the status of active government contracts and cooperation agreements (convênios). ### Explore Data Sources Browse the full catalog to list available datasets, organizations, and data groups. ## Use Cases ### Investigating Vendor Overpayments You suspect a vendor received too much money. Instead of manually cross-referencing invoices across three different departmental spreadsheets, your agent runs `list_pagamentos_fornecedores` and filters by the suspicious dates and amounts. You immediately see all related payments from the Executive Branch for review. ### Mapping State Funding Flow You need to understand if a project is properly funded. Your agent runs `list_receitas` (to check revenue) and then cross-references that data with `list_despesas` (to see committed funds). This allows you to quickly build a financial narrative without leaving the chat interface. ### Tracking Employee Compensation Changes You are doing research on public sector pay trends. You use `list_remuneracao_servidores`, specifying different years and job titles. The agent returns structured data showing salary changes, letting you build a comparative report instantly. ### Verifying Supplier Compliance Before approving a major contract, you check the vendor's history. You run `list_fornecedores_impedidos` and then use `list_historico_fornecedores_impedidos`. This confirms not only if they are currently barred but also provides context on when and why previous suspensions occurred. ## Benefits - Audit Spending Flow: Instead of jumping between 'Committed,' 'Liquidated,' and 'Paid' reports, use `list_despesas` to see the full financial lifecycle of state funds in a single query. - Pinpoint Payments: Need to know exactly who got paid? Use `list_pagamentos_fornecedores` to pull transaction records for any supplier matching your criteria. This beats sifting through general ledger reports. - Payroll Deep Dive: Forget manual spreadsheet checks. Running `list_remuneracao_servidores` lets you search payroll data by name or job title across different years instantly. - Contract Tracking: Need to know if a partnership is active? Use `list_contratos` and `list_convenios` together to map both formal agreements and cooperation treaties. - Data Discovery: Don't guess what data exists. Start with `list_datasets` to get a full directory of every topic covered in the Rondônia catalog, saving you time on research. ## How It Works The bottom line is you use conversation. You don't write SQL queries; you just ask for the public data you need. 1. Subscribe to this server. You'll need your API Key if you plan on hitting high query volumes. 2. Your AI agent sends a natural language request (e.g., 'Show me payments for CONSTRUTORA in Q1 2023'). 3. The MCP framework routes the request to the correct tool (like `list_pagamentos_fornecedores`), and your agent gets clean, structured data back. ## Frequently Asked Questions **How do I check all payments made to vendors using list_pagamentos_fornecedores?** You simply ask your agent for the payment records. The tool runs `list_pagamentos_fornecedores` and returns structured data showing which suppliers received funds, when, and how much. **Can I find out about state employee salaries using list_remuneracao_servidores?** Yes. The `list_remuneracao_servidores` tool allows you to search payroll data by job title, name, or a specific date range for comprehensive salary details. **What's the difference between list_contratos and list_convenios?** Use `list_contratos` for formal contracts managed by the state. Use `list_convenios` to see cooperation agreements, which cover different types of external partnerships. **Does get_dataset give me more detail than list_datasets?** Yes. `list_datasets` gives you a general overview of all available datasets. You use `get_dataset` when you know the dataset ID and want the full, technical metadata for that single resource. **What should I do if I get a rate limit error when using list_despesas?** You need to pause your queries and consider adding an API Key. Hitting the rate limit means you've made too many requests in a short time. If you plan on heavy analysis, request a higher rate limit through Vinkius. **When running list_organizations, can I filter by sector or department?** Yes, you must pass the `sector` parameter to narrow your search. The API expects the sector name as a strict string input. If you omit this, it will return every organization in the catalog. **If I run list_fornecedores_impedidos and get an error, what does that mean?** The error usually relates to malformed parameters or invalid date ranges. Check the documentation for expected data types (e.g., dates must be YYYY-MM-DD). The tool won't run if the input structure is wrong. **How can I handle large datasets when using list_groups to prevent timeouts?** Always use pagination parameters, like `page_size` and `offset`. Instead of asking for everything at once, break your request into smaller chunks. This keeps the query running smoothly without timing out. **How can I find out how much a specific state employee earned in a certain month?** You can use the `list_remuneracao_servidores` tool. Provide the year (`Ano`), month (`Mes`), and the employee's name (`Nome`) to retrieve detailed payroll information. **Is it possible to list all payments made to a specific company by the state?** Yes! Use the `list_pagamentos_fornecedores` tool. You can filter by the supplier's name (`Credor`) or document (`DocCredor`) and specify a date range using `DataInicial` and `DataFinal`. **How do I explore what types of datasets are available in the Rondônia catalog?** Start by using `list_datasets` to see all available names, or `list_groups` to see thematic categories. Once you find an interesting dataset, use `get_dataset` with its ID to see full metadata and resources.