# Aracaju Transparency MCP

> Aracaju provides direct access to the city's public financial records—including revenues, spending, contracts, and payroll data. It lets your AI agent query municipal funds and administrative details from the Transparency Portal without manual navigation. Audit government accountability in real-time.

## Overview
- **Category:** data-analytics
- **Price:** Free
- **Tags:** transparency, public-spending, aracaju, brazil, government-data

## Description

This MCP connects you directly to the Aracaju Transparency Portal, giving your AI client a live feed of public data. Forget clicking through dozens of bureaucratic forms or wrestling with complex database queries just to find basic spending numbers. Instead, you ask your agent questions about how municipal funds are allocated, and it gets the answers immediately.

Whether you're tracking tax collection by fiscal year or verifying who got paid last month, this connector handles the heavy lifting. You get a single conversation thread that can pull together complex financial stories from different categories—from initial public bids to final executed contracts. Because Vinkius hosts this MCP, your agent connects once and gets access to Aracaju’s entire data ecosystem, making deep civic research simple and fast.

## Tools

### list_bids
Fetches and lists details regarding all active public tenders and bids.

### list_contracts
Retrieves a list of signed agreements and contracts between the city and third parties.

### list_expenses
Lists detailed expenses incurred by different government bodies within the municipality.

### list_personnel
Retrieves records detailing public servants and current payroll information.

### list_revenues
Lists all sources of municipal revenue, including tax collections and transfers.

## Prompt Examples

**Prompt:** 
```
List the revenues for Aracaju in January 2024.
```

**Response:** 
```
I've accessed the transparency data for January 2024. The municipality recorded various revenue streams including taxes and federal transfers. Would you like a breakdown by category?
```

**Prompt:** 
```
Show me the latest public bids in the city.
```

**Response:** 
```
I've retrieved the list of active public tenders. There are several ongoing bids for infrastructure and services. Do you want to see the details for a specific tender?
```

**Prompt:** 
```
What are the expenses for the health department in 2023?
```

**Response:** 
```
Querying expenses for the health department in 2023... I found the spending records. Would you like to see the total amount or a list of specific payment orders?
```

## Capabilities

### Audit Public Spending
Query detailed records of how specific government bodies allocated public funds by year.

### Track Municipal Income
List and analyze the city's revenues, tracking tax collections and transfers over time.

### Review Government Procurement
Access information on active public tenders and bids to monitor government purchasing processes.

### Check Official Agreements
Inspect details on signed contracts between the municipality and outside third parties.

### Verify Payroll Records
Retrieve data about public servants, including payroll figures, for administrative transparency.

## Use Cases

### Following Misallocated Funds
A citizen noticed high rates of public spending. They ask their agent, 'Show me all expenses from the Education Department for 2023.' The agent uses `list_expenses` to pull records, and then cross-references those dates with relevant contracts using `list_contracts`, pinpointing exactly which third parties received payments.

### Verifying Bid Spending
A researcher wants to know if a major contract was preceded by an open bidding process. They first run `list_bids` for the necessary service, then use the resulting tender IDs in conjunction with `list_contracts` to confirm the final agreement.

### Auditing Payroll Integrity
A legal professional needs to audit compensation. They query `list_personnel` to get employee lists and pay grades, then run a comparative check against municipal revenues using `list_revenues` to ensure the payroll budget was covered.

### Tracking Fiscal Accountability
A journalist needs an annual report summary. They ask their agent for 'all revenue and spending data in Q2.' The MCP automatically coordinates calls across `list_revenues` and `list_expenses`, giving a single, consolidated view.

## Benefits

- Cross-reference spending patterns: You can compare `list_revenues` totals directly against detailed expenses found via `list_expenses`, immediately spotting potential discrepancies in the books.
- Efficiency gains are massive. Instead of visiting multiple government portals for different data types, you send one query to your agent that covers all five categories.
- Stay ahead of procurement: Use `list_bids` to monitor current public tenders. You'll know exactly when and how the city is planning its next major infrastructure spend.
- Deep dive into staffing: The `list_personnel` tool gives you access to payroll data, letting you verify who works for the city and what their compensation structure looks like.
- Contractual clarity: Need to confirm if a service was paid for? Use `list_contracts` to review signed agreements before attempting to analyze spending via `list_expenses`.

## How It Works

The bottom line is that you talk to it like a database administrator talking to an analyst, skipping all the middleware steps.

1. Subscribe to this MCP and enter 'PUBLIC' in the access field.
2. Use your AI client to start querying specific municipal records or asking comparative questions.
3. The agent processes the request against the live portal data and returns structured, analyzed information.

## Frequently Asked Questions

**How do I check the city's income using list_revenues?**
You ask your agent directly, specifying the timeframe. The tool will pull all documented revenue sources (taxes, transfers) and provide a structured summary of the amounts.

**Can I use list_expenses to see what was paid for health services?**
Yes. Simply prompt your agent with 'Show expenses for the health department in 2023.' The MCP uses `list_expenses` to filter records by category and date.

**Which tool do I use to check current public tenders?**
Use `list_bids`. This tool accesses the active tender listings, so you can see exactly what services or goods the municipality is currently looking to purchase.

**Do I need list_contracts if I want to check payroll data?**
No. `list_personnel` handles the payroll data directly. You only need `list_contracts` if you are verifying that a specific department received funding via an external agreement.

**How do I handle authentication when using list_contracts?**
You must enter 'PUBLIC' in the access field. This MCP uses the public transparency portal, so no special credentials are needed beyond that single input.

**If I use list_expenses, what is the best way to ensure the data covers a full fiscal year?**
You need to specify both the start and end dates in your query. The tool handles date ranges; simply provide the necessary fiscal year parameters for accurate results.

**What happens if I try to query too many records using list_bids in one session?**
The system enforces rate limits to maintain stability. If you hit a limit, your agent will receive an error indicating throttling; wait a few minutes and retry the request.

**When I use list_personnel, does it provide salary details or just job titles?**
The tool retrieves detailed employment records. It includes both specific job roles (cargo) and the corresponding salary information for each public servant listed.

**How do I check the municipality's income for a specific month?**
Use the `list_revenues` tool with the `ano` (year) and `mes` (month) parameters. The agent will return the total income and breakdown for that period.

**Can I see who is on the public payroll?**
Yes, use the `list_personnel` tool. You can filter by year and month to retrieve data regarding public servants and their respective payroll information.

**Is it possible to monitor active public tenders?**
Absolutely. Use the `list_bids` tool to get a comprehensive list of all public tenders and bidding processes currently recorded in the portal.