Bring Open Data
to Mastra AI
Learn how to connect São Paulo (Cidade) to Mastra AI and start using 11 AI agent tools in minutes. Fully managed, enterprise secure, and ready to use without writing a single line of code.
GDPR Free for SubscribersCompatible with every major AI agent and IDE
Gemini
What is the São Paulo (Cidade) MCP Server?
Connect your AI agent directly to the São Paulo City Open Data Portal (CKAN). This server allows you to navigate thousands of public datasets covering health, education, transport, and finance in Brazil's largest city.
What you can do
- Dataset Discovery — Search for specific datasets using keywords or list all available packages in the portal.
- Granular Inspection — Fetch detailed metadata for datasets and individual resources (files) to understand data structures.
- Advanced Data Querying — Perform searches within data stores or execute complex SQL queries directly on CSV-backed resources.
- Organizational Mapping — List and inspect city secretariats (organizations) and thematic groups to find relevant data sources.
- Tag Exploration — Browse datasets by tags to discover related public information across different departments.
How it works
- Subscribe to this server
- (Optional) Provide your São Paulo Open Data API Key for higher rate limits
- Start querying city data from Claude, Cursor, or any MCP-compatible client
Who is this for?
- Data Analysts & Researchers — quickly find and query public statistics without manual downloads
- Developers — integrate real-time city data into applications using SQL-like queries
- Journalists & Citizens — audit public spending and city performance through natural language conversation
Built-in capabilities (11)
Search data within a resource
SQL Query on a resource
Get group details
Get organization details
Get dataset details
Get resource details
g., Educação, Meio Ambiente). List groups (themes)
g., Secretarias) that own datasets. List organizations
List all datasets (packages) in the portal
List tags
Search datasets
Why Mastra AI?
Mastra's agent abstraction provides a clean separation between LLM logic and São Paulo (Cidade) tool infrastructure. Connect 11 tools through Vinkius and use Mastra's built-in workflow engine to chain tool calls with conditional logic, retries, and parallel execution. deployable to any Node.js host in one command.
- —
Mastra's agent abstraction provides a clean separation between LLM logic and tool infrastructure. add São Paulo (Cidade) without touching business code
- —
Built-in workflow engine chains MCP tool calls with conditional logic, retries, and parallel execution for complex automation
- —
TypeScript-native: full type inference for every São Paulo (Cidade) tool response with IDE autocomplete and compile-time checks
- —
One-command deployment to any Node.js host. Vercel, Railway, Fly.io, or your own infrastructure
São Paulo (Cidade) in Mastra AI
São Paulo (Cidade) and 4,000+ other MCP servers. One platform. One governance layer.
Teams that connect São Paulo (Cidade) to Mastra AI through Vinkius don't need to source, host, or maintain individual MCP servers. Every tool call runs inside a hardened runtime with credential isolation, DLP, and a signed audit chain.
Raw MCP | Vinkius | |
|---|---|---|
| Server catalog | Find and host yourself | 4,000+ managed |
| Infrastructure | Self-hosted | Sandboxed V8 isolates |
| Credential handling | Plaintext in config | Vault + runtime injection |
| Data loss prevention | None | Configurable DLP policies |
| Kill switch | None | Global instant shutdown |
| Financial circuit breakers | None | Per-server limits + alerts |
| Audit trail | None | Ed25519 signed logs |
| SIEM log streaming | None | Splunk, Datadog, Webhook |
| Honeytokens | None | Canary alerts on leak |
| Custom domains | Not applicable | DNS challenge verified |
| GDPR compliance | Manual effort | Automated purge + export |
Why teams choose Vinkius for São Paulo (Cidade) in Mastra AI
The São Paulo (Cidade) MCP Server runs on Vinkius-managed infrastructure inside AWS — a purpose-built runtime with per-request V8 isolates, Ed25519 signed audit chains, and sub-40ms cold starts. All 11 tools execute in hardened sandboxes optimized for native MCP execution.
Your AI agents in Mastra AI only access the data you authorize, with DLP that blocks sensitive information from ever reaching the model, kill switch for instant shutdown, and up to 60% token savings. Enterprise-grade infrastructure, zero maintenance.
* Every MCP server runs on Vinkius-managed infrastructure inside AWS - a purpose-built runtime with per-request V8 isolates, Ed25519 signed audit chains, and sub-40ms cold starts optimized for native MCP execution. See our infrastructure
How Vinkius secures
São Paulo (Cidade) for Mastra AI
Every tool call from Mastra AI to the São Paulo (Cidade) MCP Server is protected by DLP redaction, cryptographic audit chains, V8 sandbox isolation, kill switch, and financial circuit breakers.
Frequently asked questions
How can I search for datasets related to a specific topic like 'Health'?
You can use the search_packages tool with the query 'saúde'. The agent will return a list of matching datasets available in the portal.
Can I perform SQL queries on the data directly?
Yes! If a resource is stored in the DataStore, you can use the datastore_search_sql tool to run standard SQL queries against the resource ID.
How do I find which city departments have published data?
Use the list_organizations tool to see all registered entities. Then, use get_organization with a specific ID to see all datasets owned by that department.
How does Mastra AI connect to MCP servers?
Create an MCPClient with the server URL and pass it to your agent. Mastra discovers all tools and makes them available with full TypeScript types.
Can Mastra agents use tools from multiple servers?
Yes. Pass multiple MCP clients to the agent constructor. Mastra merges all tool schemas and the agent can call any tool from any server.
Does Mastra support workflow orchestration?
Yes. Mastra has a built-in workflow engine that lets you chain MCP tool calls with branching logic, error handling, and parallel execution.
createMCPClient not exported
Install: npm install @mastra/mcp
Explore More MCP Servers
View all →
EPO Open Patent Services
4 toolsSearch global patents — audit bibliographic and legal data via AI.
Autobidder
10 toolsOptimize your ad spend with AI-powered bidding strategies that automatically adjust bids across advertising platforms.
Conda (Anaconda.org)
8 toolsEnable your AI agent to search packages, inspect metadata, and explore channels on Anaconda.org via the Conda API.
JigsawStack
7 toolsAccess a suite of AI utility APIs for web scraping, translation, OCR, and sentiment analysis in one developer-friendly platform.