• SQL
  • FILES
  • SCHEMA
  • HUMAN

How to query municipal datasets with your AI

Connect your AI to São Paulo's public data. Once linked, your agent can pull specific records or entire datasets using standard SQL.

Ask AI about this page

Short answer

Can I run SQL on São Paulo's public data with my AI?

Yes. Your AI uses SQL to filter and extract information from the city's CSV-backed datasets. You'll get precise answers from municipal records without manual downloads.

Data outcomes

What you get from your queries

The AI handles the heavy lifting of data retrieval so you can focus on the results.

SQL

Direct data extraction

Your agent writes and executes SQL to pull the exact rows you need from the city's datasets.

FILES

Resource access

The AI identifies and pulls individual CSV resources from the municipal repository.

SCHEMA

Structure awareness

Your agent checks column names and data types to ensure every query is valid.

HUMAN

Final interpretation

The AI provides the raw data or summaries, but you decide how to use those insights.

The workflow

What your AI does when you ask a question.

The AI translates your natural language into technical commands to talk to the city's database.

  1. Locate data

    The agent searches the municipal repository to find the specific resource you're asking about.

    get_resource

  2. Check columns

    It looks at the schema to understand how to structure a valid query.

    get_resource

  3. Run SQL

    The AI executes the SQL command against the CSV-backed store to filter the data.

    datastore_search_sql

  4. Deliver results

    It takes the resulting rows and presents them in your chat window.

    datastore_search_sql

Try it

Copy these to start.

Use these prompts to begin interacting with the São Paulo datasets.

Starting points

Swap the bracketed text for the specific dataset or column names you want to investigate.

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.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 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"
    }
  }
}
Copy into chat04

  • Find the dataset for São Paulo public transport and show me the first 10 rows.

  • Run a SQL query to find all municipal records in the health dataset where the status is 'active'.

  • What are the column names available in the city's education resource?

  • Query the municipal datasets to count how many entries exist for the year 2023.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect São Paulo (Cidade) once, then ask.

One click connects this MCP to your client. Your credentials stay encrypted and your data access is handled securely.

Connect São Paulo (Cidade) to your AI

FAQ

How this task behaves

  • 01

    Can the AI change or delete data in the municipal database?

    No. The tools only allow for reading and querying existing data. The AI cannot modify the city's records.

  • 02

    Do I need to know SQL to use this?

    No. You can ask questions in plain English, and your AI will write the SQL for you.

  • 03

    Can the AI download the entire dataset as a file?

    No. The AI can access the resources, but it doesn't provide a direct download link for the raw CSV files.

  • 04

    Does the AI see all the data in São Paulo?

    The AI only sees the data within the specific resources it accesses through the provided tools.

  • 05

    Can the AI create new datasets?

    No. The capabilities are limited to searching and retrieving data from existing municipal resources.

  • More questions about São Paulo (Cidade)? The Connector page answers them. See everything the São Paulo (Cidade) Connector can do

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