• DATA
  • FILES
  • LOGIC
  • HUMAN

How to extract dataset metadata with your AI

Connect your agent to the Ayuntamiento de Madrid CKAN portal to pull specific dataset details instantly.

Ask AI about this page

Short answer

How can I get dataset metadata using my AI?

Your agent queries the Madrid municipal portal to pull specific dataset packages and their individual resources. You get direct access to maintainer names, update schedules, and file metadata. This breakdown shows how your agent handles those requests.

The outcomes

What you get from your agent

The AI turns your natural language questions into structured data from the Madrid portal.

DATA

Metadata extraction

The agent pulls package details like update frequency and maintainer contact info. You get clean, usable facts instead of browsing web pages.

FILES

Resource identification

Your AI identifies specific files within a dataset. It finds download links and file formats without you needing to click through the portal.

LOGIC

Automated filtering

The agent scans through dataset lists to find exactly what you asked for. It handles the heavy lifting of searching the CKAN registry.

HUMAN

Manual verification

You decide if the extracted metadata is sufficient for your needs. The AI provides the data, but you make the final call on its accuracy.

The workflow

What your AI does when the request arrives.

The agent translates your request into specific API calls to the Madrid CKAN instance.

  1. Locate the dataset

    The agent searches for the specific dataset package you mentioned to find its unique ID and general metadata.

    get_package

  2. Inspect file details

    Once the package is found, the agent looks inside to see the individual files and their properties.

    get_resource

  3. Extract maintainer info

    The agent pulls the specific contact and ownership details from the package metadata.

    get_package

  4. Summarize findings

    The agent compiles the update frequency and resource links into a plain text response for you.

    get_resource

Try it

Copy these to start.

Use these prompts once you have connected the Ayuntamiento de Madrid (CKAN) MCP.

Starting points

Replace the bracketed text with the actual names of the datasets or resources you are looking for.

Ayuntamiento de Madrid Connector

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

Connector linkhttps://edge.vinkius.com/vk_preview_Q2ilbvlu9XTF8EEUmS6g9MnP3zj786jqBlCeEBMV/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 — Ayuntamiento de Madrid capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "ayuntamiento-de-madrid-ckan-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_Q2ilbvlu9XTF8EEUmS6g9MnP3zj786jqBlCeEBMV/mcp"
    }
  }
}
Copy into chat04

  • Find the maintainer and last update date for the 'Transporte Público' dataset.

  • What are the available resources for the 'Calidad del Aire' package?

  • List all the files in the 'Ciclovías' dataset and tell me their formats.

  • Who is responsible for managing the 'Gestión de Residuos' data?

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

Start here

Connect Ayuntamiento de Madrid (CKAN) once, then ask.

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

Connect Ayuntamiento de Madrid (CKAN) to your AI

FAQ

How this task behaves

  • 01

    Can my AI download the actual files from the portal?

    No. The AI can find the resource metadata and download links, but it cannot download the files directly to your local machine.

  • 02

    Can the AI update the dataset information in Madrid's system?

    No. The tools only allow for reading data. Your AI cannot change, delete, or upload any information to the Ayuntamiento de Madrid portal.

  • 03

    Does the AI see all datasets in the portal?

    Yes, the AI can access any dataset that is publicly available through the CKAN API.

  • 04

    Can I ask for specific file sizes?

    Yes, the agent can retrieve file-level metadata including size and format via the resource tool.

  • 05

    Will the AI notify me when a dataset is updated?

    No. The AI only responds to your direct prompts; it does not monitor the portal for changes in the background.

  • More questions about Ayuntamiento de Madrid (CKAN)? The Connector page answers them. See everything the Ayuntamiento de Madrid (CKAN) Connector can do

Connect Ayuntamiento de Madrid to Claude, Cursor, ChatGPT & more