• ROWS
  • COLUMNS
  • DATA
  • HUMAN

How to filter Catalan datasets with your AI

Connect to Dades Obertes Catalunya once. From there, your agent handles the data extraction using precise SoQL filters.

Ask AI about this page

Short answer

How can I filter Catalan datasets with my AI?

Your agent uses SoQL to target specific columns and rows within the Catalan open data portal. This lets you pull exactly what you need without manual CSV downloads. You get clean, filtered data ready for your next task.

The results you get

What your data looks like

The AI turns your natural language into precise data extractions.

ROWS

Filtered row sets

The AI identifies the right dataset and pulls only the rows that meet your criteria. You skip the noise of irrelevant entries.

COLUMNS

Selected field lists

Instead of a massive file, your agent selects only the specific columns you asked for. This keeps your chat context lean.

DATA

Ready to use info

The extracted data lands directly in your chat. You can immediately ask your agent to summarize trends or calculate totals.

HUMAN

Manual review

You check if the filtered results match what you wanted. The AI provides the data, but you verify the logic is right.

The workflow

What your AI does when the request arrives.

The AI translates your intent into a structured query to fetch data from the Catalan open data portal.

  1. Find the dataset

    Your agent looks through the available Catalan datasets to find the one that matches your topic.

    query_dataset

  2. Build the SoQL filter

    The AI writes a SoQL query to filter the rows and select the specific columns you need.

    query_dataset

  3. Execute the query

    The query runs against the Dades Obertes Catalunya API to pull the requested data points.

    query_dataset

  4. Deliver the data

    The AI presents the resulting rows in a readable format within your chat interface.

    query_dataset

Try it

Copy these to start.

Use these prompts to begin interacting with the Catalan datasets.

Starting points

Swap out the dataset names and column headers with the specific ones you are looking for.

Dades Obertes Catalunya Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_PIJE31NJ9LRwIstSjU8dzQZGTHyZrJ2KCl4ZR7G9/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 — Dades Obertes Catalunya capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "dades-obertes-catalunya-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_PIJE31NJ9LRwIstSjU8dzQZGTHyZrJ2KCl4ZR7G9/mcp"
    }
  }
}
Copy into chat04

  • Find the dataset for Barcelona city transport and show me the columns for route name and frequency.

  • Query the Catalan air quality dataset for all entries in the last month where PM10 levels were high.

  • Get the list of all public libraries in Catalonia from the relevant dataset, including their addresses.

  • Filter the tourism dataset to show only the number of visitors per month for the year 2023.

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

Start here

Connect Dades Obertes Catalunya once, then ask.

One click connects the MCP to your client. Your credentials stay encrypted, and you can start querying immediately.

Connect Dades Obertes Catalunya to your AI

FAQ

How this task behaves.

  • 01

    Can the AI download the entire dataset as a CSV?

    No. The AI uses SoQL to extract specific subsets of data directly into the chat. It does not perform bulk file downloads.

  • 02

    Does the AI change the original data in the Catalan portal?

    No. The AI only reads from the datasets. It has no permission to modify, delete, or upload any data to the Dades Obertes Catalunya portal.

  • 03

    Can I filter by multiple columns at once?

    Yes. You can ask for multiple filters in a single request, and the AI will build the SoQL query to handle them.

  • 04

    Do I need to know SoQL syntax to use this?

    No. You speak in plain English, and your agent translates that into the SoQL syntax required for the query.

  • 05

    Can the AI create new datasets?

    No. This connector is strictly for querying existing public datasets. It cannot create or save new datasets to the portal.

  • More questions about Dades Obertes Catalunya? The Connector page answers them. See everything the Dades Obertes Catalunya Connector can do

Connect Dades Obertes Catalunya to Claude, Cursor, ChatGPT & more