Compatible with every major AI agent and IDE
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 VS Code Copilot?
GitHub Copilot Agent mode brings São Paulo (Cidade) data directly into your VS Code workflow. With a project-scoped config, the entire team shares access to 11 tools. Copilot queries live data, generates typed code, and writes tests from actual API responses, all without leaving the editor.
- —
VS Code is used by over 70% of developers. adding MCP tools to Copilot means your team can leverage external data without leaving their primary editor
- —
Project-scoped MCP configs (
.vscode/mcp.json) let you commit server configurations to your repository, ensuring the entire team shares the same tool access - —
Copilot's Agent mode integrates MCP tools seamlessly with file editing, terminal commands, and workspace search in a single agentic loop
- —
GitHub's enterprise compliance and audit features extend to MCP tool usage, providing visibility into how AI interacts with external services
São Paulo (Cidade) in VS Code Copilot
São Paulo (Cidade) and 4,000+ other MCP servers. One platform. One governance layer.
Teams that connect São Paulo (Cidade) to VS Code Copilot 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 VS Code Copilot
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 VS Code Copilot 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 VS Code Copilot
Every tool call from VS Code Copilot 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.
Which VS Code version supports MCP?
MCP support requires VS Code 1.99 or later with the GitHub Copilot extension. Ensure both are updated to the latest version. Older versions of Copilot may not expose the Agent mode toggle.
How do I switch to Agent mode?
Open the Copilot Chat panel and look for two mode options: "Ask" and "Agent". Click "Agent" to enable autonomous tool calling. In Ask mode, Copilot provides conversational answers but cannot invoke MCP tools.
Can I restrict which MCP tools Copilot can access?
Yes. VS Code shows a tool consent dialog before any MCP tool is invoked for the first time. You can also configure tool access policies at the organization level through GitHub Copilot settings.
Does MCP work in VS Code Remote or Codespaces?
Yes. MCP servers configured via .vscode/mcp.json work in Remote SSH, WSL, and GitHub Codespaces environments. The MCP connection is established from the remote host, so ensure the server URL is accessible from that environment.
MCP tools not available
Ensure you are in Agent mode in Copilot Chat. MCP tools only appear in Agent mode.
Explore More MCP Servers
View all →
LocationIQ (Geocoding & Maps)
10 toolsBuild with location data via LocationIQ — geocode addresses, calculate routes, and perform reverse lookups.

BreezoMeter Air Quality & Pollen
2 toolsUniversal air quality intelligence — get real-time AQI, pollutants, and pollen data via AI.

Open Finance Brasil
7 toolsConnect Open Finance Brasil to any AI agent via MCP.

Affinda
5 toolsIntelligent document processing — parse resumes, invoices, and IDs via AI.
