How to Use the Mato Grosso do Sul Open Data MCP in OpenAI Agents SDK

Q: How do I configure the Mato Grosso do Sul Open Data MCP Server with the OpenAI Agents SDK?

Install the package with pip install openai-agents and initialize MCPServerStreamableHttp using the Vinkius URL. Pass this server object into the mcpservers list in your Agent constructor to enable automatic tool discovery.

Q: Can my OpenAI Agents SDK setup run SQL queries directly on Mato Grosso do Sul Open Data?

Yes, the agent can use the datastoresearchsql tool to execute custom SQL queries directly against the state's CKAN datastore. This avoids downloading large raw files and lets the agent filter records on the server side.

Q: How does the OpenAI Agents SDK handle tool discovery for Mato Grosso do Sul Open Data?

The SDK auto-discovers all seven tools, including listpackages and getresource, when you pass the server to the Agent. Enable cacheToolsList=True to minimize API overhead and keep tool lookups fast.

Q: What happens if an agent tries to query a nonexistent table in the state database?

The datastoresearchsql tool returns a clear error message from the CKAN API, which your agent can catch and use to correct its SQL query. You can also have the agent check getpackage first to verify the table schema.

Deploy production-ready OpenAI Agents SDK setups that query Mato Grosso do Sul public records using this MCP Server.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Mato Grosso do Sul Open Data MCP to OpenAI Agents SDK

Create your Vinkius account to connect Mato Grosso do Sul Open Data to OpenAI Agents SDK and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Mato Grosso do Sul Open Data with OpenAI Agents SDK

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Querying Public SQL Databases via OpenAI Agents SDK

The `datastore_search_sql` tool lets your agent write and run SQL queries against Brazilian state databases directly from your Python runtime. This means your agent isn't just guessing or scraping raw files; it executes precise SQL queries to extract exact columns from the public datastore. You initiate the connection using `MCPServerStreamableHttp` within your agent pipeline. The agent uses `list_packages` to discover what datasets are online, then targets specific tables without pulling megabytes of junk data over the wire.

Direct Dataset Discovery and Metadata Extraction

The `list_packages` and `get_package` tools give your agent the ability to map out the entire Mato Grosso do Sul data catalog in real time. Instead of hardcoding URLs, your agent queries the CKAN API dynamically to find newly updated public records. By passing this MCP Server into the `mcp_servers` list of your Agent constructor, these tools are auto-discovered immediately. The agent inspects groups via `list_groups` to categorize the state's public spending or environmental records before running deeper analysis.

Granular Resource Inspection and Search

The `get_resource` and `datastore_search` tools allow your agent to zoom in on specific files and search their contents row by row. This ensures your agent grabs only the relevant slices of data instead of downloading massive, raw CSV files. Using the OpenAI Agents SDK, you can set `cacheToolsList=True` to keep tool definitions cached for fast execution. This MCP Server setup keeps your agent fast when jumping from `list_organizations` to deep resource searches inside the state's databases.

Setup guide

Set up Mato Grosso do Sul Open Data MCP in OpenAI Agents SDK

Prerequisites

Python 3.10+ installed
openai-agents package (pip install openai-agents)
Active Vinkius subscription with a valid endpoint token

1

Install the SDK

Run pip install openai-agents to install the OpenAI Agents SDK. The MCP integration is built-in — no extra dependencies needed.
2

Connect via SSE transport

Use MCPServerSse with your Vinkius endpoint URL. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. The SDK auto-discovers all Mato Grosso do Sul Open Data tools at runtime.
3

Create your Agent

Pass the MCP to Agent(mcp_servers=[server]). The agent receives Mato Grosso do Sul Open Data tools as native definitions — JSON schemas resolve automatically.
4

Run the agent

Call Runner.run(agent, prompt) to execute. The agent invokes the appropriate Mato Grosso do Sul Open Data tools and returns structured results. Copy the full example on the right to get started.

agent.py

import asyncio
from agents import Agent, Runner
from agents.mcp import MCPServerSse

async def main():
    async with MCPServerSse(
        url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    ) as server:
        agent = Agent(
            name="Mato Grosso do Sul Open Data Agent",
            instructions="You have access to Mato Grosso do Sul Open Data tools.",
            mcp_servers=[server],
        )
        result = await Runner.run(agent, "List recent transactions")
        print(result.final_output)

asyncio.run(main())

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Mato Grosso do Sul Dados Abertos. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Mato Grosso do Sul Open Data now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Mato Grosso do Sul Open Data MCP in OpenAI Agents SDK

Install the package with `pip install openai-agents` and initialize `MCPServerStreamableHttp` using the Vinkius URL. Pass this server object into the `mcp_servers` list in your Agent constructor to enable automatic tool discovery.

Yes, the agent can use the `datastore_search_sql` tool to execute custom SQL queries directly against the state's CKAN datastore. This avoids downloading large raw files and lets the agent filter records on the server side.

The SDK auto-discovers all seven tools, including `list_packages` and `get_resource`, when you pass the server to the Agent. Enable `cacheToolsList=True` to minimize API overhead and keep tool lookups fast.

The `datastore_search_sql` tool returns a clear error message from the CKAN API, which your agent can catch and use to correct its SQL query. You can also have the agent check `get_package` first to verify the table schema.

Vinkius routes all CKAN API requests through an isolated, zero-trust sandbox. The server only handles public state records, ensuring your private database queries and agent prompts never touch public logs or third-party servers.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript