• DATA
  • MATH
  • INSIGHT
  • HUMAN

How to query government spending records with your AI

Connect to the Mato Grosso do Sul Open Data source to run precise SQL queries against state transaction records.

Ask AI about this page

Short answer

How can I query Mato Grosso do Sul spending records with AI?

Your AI uses SQL to pull specific rows and sums from the state's open datasets. You can filter by date, department, or transaction value to find exactly what you need. You'll get specific datasets and calculated totals.

Data outcomes

What you get from these queries

The AI turns your natural language questions into structured data outputs.

DATA

Filtered transaction lists

The AI runs SQL to isolate specific spending events. You get a clean list of records that match your exact criteria.

MATH

Aggregated totals

Instead of just lists, you can ask for sums or averages. The AI calculates totals for specific departments or timeframes.

INSIGHT

Trend identification

By querying across different time periods, your AI identifies shifts in how state funds are allocated.

HUMAN

Manual verification

You must review the SQL logic and the resulting numbers. The AI provides the data, but you confirm the accuracy for official reports.

The workflow

What your AI does when you ask a question.

The AI translates your intent into database commands to fetch state data.

  1. Translate intent

    Your AI interprets your question and determines which columns and tables in the Mato Grosso do Sul dataset are needed.

    datastore_search_sql

  2. Execute SQL

    The agent writes and runs a SQL query to filter the state's transaction records based on your parameters.

    datastore_search_sql

  3. Aggregate results

    The AI performs math on the returned rows, such as summing up high-value contracts or counting entries.

    datastore_search_sql

  4. Format output

    The agent presents the final numbers or lists in a readable format within your chat interface.

    datastore_search_sql

Try it

Copy these to start.

Use these prompts to begin interacting with the state data.

Starting points

Swap out the department names or dollar amounts to match the specific records you are hunting for.

Mato Grosso do Sul Dados Abertos Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_1AhdW0jTsKGmPAmWugSHrUX3hdktYZTTcpzTLkQP/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Mato Grosso do Sul Dados Abertos capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "mato-grosso-do-sul-open-data-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_1AhdW0jTsKGmPAmWugSHrUX3hdktYZTTcpzTLkQP/mcp"
    }
  }
}
Copy into chat04

  • Show me all transactions from the Health Department that were over 50,000 Reais.

  • What is the total amount spent on education in the last fiscal year?

  • List the top 10 highest value contracts recorded in the current dataset.

  • Find all spending records related to infrastructure from the last six months.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Mato Grosso do Sul Open Data once, then ask.

Click the link to authorize the connection. Your credentials stay encrypted, and you can immediately start querying the data in your preferred AI client.

Connect Mato Grosso do Sul Open Data to your AI

FAQ

How this task behaves

  • 01

    Can the AI change the actual government records?

    No. The AI only has read access via SQL to query the data. It cannot modify, delete, or add any records to the state database.

  • 02

    Does the AI write the SQL for me?

    Yes. The AI uses the datastore_search_sql tool to convert your plain English questions into valid SQL queries automatically.

  • 03

    Can I export these results to a spreadsheet?

    The AI provides the data in your chat window. You would need to copy that data into your own spreadsheet software manually.

  • 04

    Can the AI perform complex math on the spending totals?

    Yes. Because it uses SQL, it can perform aggregations like SUM, AVG, and COUNT on any numeric column in the dataset.

  • 05

    Is the data real-time?

    The AI queries the datasets provided by the Mato Grosso do Sul Open Data source. Its accuracy depends entirely on the freshness of that specific public data source.

  • More questions about Mato Grosso do Sul Open Data? The Connector page answers them. See everything the Mato Grosso do Sul Open Data Connector can do

Connect Mato Grosso do Sul Dados Abertos to Claude, Cursor, ChatGPT & more