MCP For Claude Marketplace
São Paulo (Cidade)

São Paulo (Cidade) MCP Connector for Claude

A+

Access the official São Paulo Open Data portal — search datasets, query resources via SQL, and explore city organizations and themes.

11 tools Official Updated Jun 28, 2026 Official Vinkius Partner
More Details Connect to Claude

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

  1. Subscribe to this server
  2. (Optional) Provide your São Paulo Open Data API Key for higher rate limits
  3. 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
open-dataurban-datapublic-administrationckansql-query

11 tools expose this connector's capabilities to your AI agent.

datastore_search_sql

SQL Query on a resource

datastore_search

Search data within a resource

list_groups

g., Educação, Meio Ambiente). List groups (themes)

get_group

Get group details

list_organizations

g., Secretarias) that own datasets. List organizations

get_organization

Get organization details

list_packages

List all datasets (packages) in the portal

search_packages

Search datasets

get_package

Get dataset details

get_resource

Get resource details

list_tags

List tags

See how to talk to your AI agent using São Paulo (Cidade).

Search for datasets about public transport in São Paulo.

I found several datasets related to public transport. The most relevant are 'Bilhete Único statistics' and 'Bus lines and stops'. Would you like to see the resources for one of these?

List all organizations that provide open data in the portal.

I've retrieved the list of organizations. There are over 50 entities, including 'Secretaria Municipal da Saúde', 'Secretaria Municipal de Educação', and 'SPTrans'. Which one should we explore?

Get the details for the dataset 'folha-de-pagamento'.

The dataset 'folha-de-pagamento' contains payroll information for city employees. It has 12 resources available, mostly in CSV and PDF formats. Would you like the ID of the latest CSV resource to query it?

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.

Related Connectors

AP

Aptabase (Mobile Analytics) MCP

1 tools Official

Send telemetry and custom events to Aptabase directly from your AI agent to track app usage and performance.

A+ View details →
PP

PBGC Pension Data MCP

4 tools Official

Access official US Pension Benefit Guaranty Corporation data — query single and multiemployer plans, ERISA 4044 rates, and financial assistance records.

F View details →
CL

ClientSuccess MCP

8 tools Official

Manage customer success and retention via ClientSuccess — track client health, monitor subscriptions, and manage success cycles directly from any AI agent.

F View details →
FE

Felt (Collaborative Maps) MCP

11 tools Official

Create and manage collaborative maps — upload geographic data, style layers, and manipulate map elements directly from any AI agent.

A+ View details →