How do I query specific rows in a dataset?

You can use the datastore_search_sql capability to run SQL queries directly on CSV-backed resources.

Can I use this with Claude or Cursor?

Yes, this MCP works with any MCP-compatible client including Claude, Cursor, and Windsurf.

What kind of data is available?

The portal contains datasets on health, education, transport, finance, and other municipal sectors.

Do I need an API key?

An API key is optional, but providing one allows for higher rate limits when querying the portal.

How do I find which department owns a dataset?

Your agent can use the list_organizations or get_organization capabilities to map datasets to specific secretariats.

How can I search for datasets related to a specific topic like 'Health'?

You can use the search_packages capability 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 capability to run standard SQL queries against the resource ID.

How do I find which city departments have published data?

Use the list_organizations capability to see all registered entities. Then, use get_organization with a specific ID to see all datasets owned by that department.

An astronaut overseeing a futuristic data hub

Download PDF Markdown Version

Connect Sao Paulo Cidade to ChatGPT, Claude and Gemini

Set it up once and it works in ChatGPT, Claude, Cursor, and any other client you love. It all runs safely in the background, so you can relax and focus on what really matters. Query official São Paulo city datasets through your AI agent.

Ask AI about this Connector

Developed, maintained, and hosted by Vinkius.

MCP VERIFIED · PRODUCTION READY · VINKIUS GUARANTEED

Waiting for input…

Works with modern AI clients that support MCP, including ChatGPT, Claude, Cursor, and more.

Your AI does the work. We keep it safe and sound.

No other AI tool gives you this. Your workflow runs in the client you already love, your account stays protected, and you decide what the agent can and cannot do. It is the whole reason to make the switch.

Each Connector lives inside our infrastructure, the same place where your workflow runs. The three things below are already part of it, working quietly in the background so you never have to think about them. Nothing to add, nothing to set up, nothing to worry about.

V8 Isolate01

Each Connector runs inside its own sealed environment.

Each Connector runs inside its own sealed V8 runtime — no access to your files, your system, or other servers. A Connector never sees past its own request.

Kill Switch02

One switch stops every agent. Instantly.

One action deactivates every Connector, revokes every token, and ends every session at once. AI Governance keeps the record.

FinOps per User03

Spending limits that pause instead of surprise.

Every user keeps their own connections and credentials, isolated from everyone else. Anything that would cross your spending limit is held for your approval, not billed.

Three controls, built into the layer your AI connects through.

Curated set · 11 capabilities

We ship only the actions that matter.

Capability set01 / 03

01-04

4 capabilities in this set.

Part of 11 available through São Paulo (Cidade).

01
Datastore search
Search for specific data entries within a single resource.
02
Get organization
Retrieve detailed information about a specific city organization.
03
Get package
Fetch metadata and details for a specific dataset.
04
Search packages
Search the portal for datasets using keywords.

Capability set02 / 03

05-08

4 capabilities in this set.

Part of 11 available through São Paulo (Cidade).

05
Datastore search SQL
Run SQL queries directly against CSV-backed data resources.
06
Get group
Get details for a specific thematic group.
07
List groups
List all thematic groups like Education or Environment.
08
List organizations
List all city secretariats and organizations that own datasets.

Capability set03 / 03

09-11

3 capabilities in this set.

Part of 11 available through São Paulo (Cidade).

09
List packages
Retrieve a list of all available datasets in the portal.
10
Get resource
Get specific details about a resource within a dataset.
11
List tags
List all available tags used to categorize datasets.

Real work

What teams actually run

Public Spending Audits

A journalist asks the agent to find payroll or budget datasets to check municipal spending.

Urban Planning Research

An analyst queries transport and infrastructure datasets to study city growth.

App Development

A developer uses the agent to find specific API-ready resources for a local service app.

Educational Statistics

A researcher pulls data from the Education secretariat to compare school performance.

Automate a task

Put São Paulo (Cidade) to work on one thing.

Step-by-step automations your AI runs through this Connector: the workflow, the prompts to start with, and the exact capabilities behind each move.

One connector, every AI

São Paulo (Cidade) works with the most popular AI clients.

These are the most popular clients, each with a step-by-step guide: one link, set up once, with governance and visibility built in. And because everything runs on the MCP standard, the same connection also works in any other compatible client — nothing to rebuild.

Building your own app? The connector is yours to use.

You don't need a client to put São Paulo (Cidade) to work: the same hosted connection plugs into your own applications and agent code, with the same governance on every request. Build with it, chat with it — one connection for both.

Observed, not estimated

939ms average. Fast in production.

São Paulo (Cidade) is checked daily against the live service.

Daily averagePeak 1235ms

Oct 3Today

Fastest day: 706ms
Slowest day: 1235ms
14-day trend: Stable+3%

Connect your client

One URL. Every client.

Activate the Connector, copy your link, and paste it into the client you already use. 11 capabilities arrive ready to run.

Preview access · not provider authentication

The vk_preview_* token belongs to Vinkius preview infrastructure. It lets Claude discover and display the capabilities of São Paulo (Cidade), so you can see the experience inside your AI.

It does not authenticate your account with São Paulo (Cidade). Actions requiring credentials or live account data may not run until you activate the Connector and authorize the service.

São Paulo (Cidade) Connector

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

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

Claude Desktop

Follow the steps below to connect in seconds.

1In Claude Desktop, open Settings → Connectors.
2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
3Click Add and start a new chat — São Paulo (Cidade) capabilities are ready to use.

Configuration · claude_desktop_config.jsonCopy

{
  "mcpServers": {
    "sao-paulo-cidade-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_kifM9vLzppqz5ePDffcBemEwvLoyLrCEtW9W90Hh/mcp"
    }
  }
}

Claude
ChatGPT
Cursor
VS Code
Windsurf
Claude Code
JetBrains
Cline

Step-by-step instructions for each client are in the guide. How to connect

Guided setup for Claude? Set up São Paulo (Cidade) in Claude and other AIs

See all the AI clients this connector works with ↑

Who it's for

Built for the work São Paulo (Cidade) owners hand off.

This MCP is built for professionals who need to turn raw municipal data into actionable insights without manual scraping.

01
Data Analysts
They ask the agent to query public statistics and format them for reports.
02
Developers
They use the agent to find real-time city data for application integration.
03
Journalists
They use natural language to audit public spending and city performance.

FAQ

Questions São Paulo (Cidade) owners ask.

01
How do I query specific rows in a dataset?
You can use the datastore_search_sql capability to run SQL queries directly on CSV-backed resources.
02
Can I use this with Claude or Cursor?
Yes, this MCP works with any MCP-compatible client including Claude, Cursor, and Windsurf.
03
What kind of data is available?
The portal contains datasets on health, education, transport, finance, and other municipal sectors.
04
Do I need an API key?
An API key is optional, but providing one allows for higher rate limits when querying the portal.
05
How do I find which department owns a dataset?
Your agent can use the list_organizations or get_organization capabilities to map datasets to specific secretariats.
06
How can I search for datasets related to a specific topic like 'Health'?
You can use the search_packages capability with the query 'saúde'. The agent will return a list of matching datasets available in the portal.
07
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 capability to run standard SQL queries against the resource ID.
08
How do I find which city departments have published data?
Use the list_organizations capability to see all registered entities. Then, use get_organization with a specific ID to see all datasets owned by that department.

Explore

More in Data Analytics

Connect São Paulo (Cidade) to Claude, Cursor, ChatGPT & more

Your AI does the work. We keep it safe and sound.

Each Connector runs inside its own sealed environment.

One switch stops every agent. Instantly.

Spending limits that pause instead of surprise.

We ship only the actions that matter.

01-04

Datastore search

Get organization

Get package

Search packages

05-08

Datastore search SQL

Get group

List groups

List organizations

09-11

List packages

Get resource

List tags

What teams actually run

Public Spending Audits

Urban Planning Research

App Development

Educational Statistics

Building your own app? The connector is yours to use.

São Paulo (Cidade) Connector

Claude Desktop

Data Analysts

Developers

Journalists

How do I query specific rows in a dataset?

Can I use this with Claude or Cursor?

What kind of data is available?

Do I need an API key?

How do I find which department owns a dataset?

How can I search for datasets related to a specific topic like 'Health'?

Can I perform SQL queries on the data directly?

How do I find which city departments have published data?

Maranhão Open Data AI Connector

Ayuntamiento de Barcelona (CKAN) AI Connector

Open Data Euskadi AI Connector

Mato Grosso do Sul Open Data AI Connector

Suggestions

HealthData.gov (HHS Open Data) AI Connector

Data.gov Catalog AI Connector

Aragón Open Data AI Connector

Ayuntamiento de Madrid (CKAN) AI Connector