• SEARCH
  • BROWSE
  • FILTER
  • HUMAN

How to find municipal datasets with your AI

Connect your AI to the Madrid City Council's CKAN instance. Once connected, you can pull specific data packages using plain English instead of manual database queries.

Ask AI about this page

Short answer

How can I find specific Madrid city data using my AI?

You can ask your AI to search for specific datasets, browse data groups, or look up available tags within the Madrid City Council's repository. This lets you pinpoint exact information like transport stats or environmental data without clicking through the web portal. You'll get a list of relevant data packages immediately.

Data outcomes

What you get from your queries

Your AI acts as a bridge to the municipal repository, turning your questions into precise data lookups.

SEARCH

Targeted data packages

The AI scans the CKAN repository for datasets matching your description. You get a list of relevant files and metadata.

BROWSE

Organizational groups

Your agent can list all available groups to see how the city categorizes its information. This helps you understand the repository structure.

FILTER

Tag-based results

The AI uses specific metadata labels to isolate datasets. You get a narrowed list of packages that carry the exact tags you need.

HUMAN

Manual verification

The AI finds the data, but you decide which files are worth downloading. You handle the final analysis and decision making.

The workflow

What your AI does when you ask for data.

The AI translates your natural language requests into specific API calls to the Madrid City Council repository.

  1. Identify the topic

    The AI looks through the available categories and organizational groupings to see where your requested data might live.

    list_groups

  2. Locate specific files

    Once the topic is clear, the AI scans the repository for packages that match your specific search terms.

    search_packages

  3. Refine the results

    If the results are too broad, the AI uses specific metadata labels to filter the list down to exactly what you need.

    list_tagssearch_packages

  4. Present the findings

    The AI summarizes the found datasets, providing names and descriptions so you can pick the right one.

    search_packages

Try it

Copy these to start.

Use these prompts to begin interacting with the Madrid City Council data.

Starting points

Replace the bracketed text with the specific topics or categories you want to find.

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 all datasets related to [transportation and traffic] in Madrid.

  • List the data groups available in the Ayuntamiento de Madrid repository.

  • Search for datasets tagged with [environment] or [climate].

  • Show me all data packages that mention [public health] in their description.

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

Start here

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

Click the button to link the MCP to your client. Your credentials stay encrypted, and you can immediately start querying the city's data.

Connect Ayuntamiento de Madrid (CKAN) to your AI

FAQ

How this task behaves

  • 01

    Can the AI download the files directly to my computer?

    No. The AI can find the datasets and provide the information you need to locate them, but you must perform the actual download yourself.

  • 02

    Can I use the AI to upload my own data to the Madrid City Council?

    No. This connector is read-only. It allows you to search and list existing public data, but it cannot modify or add to the municipal repository.

  • 03

    Does the AI see all the data in the files?

    The AI sees the metadata and package descriptions provided by the search tools. It does not automatically read the entire contents of every large CSV or Excel file unless you specifically interact with those files later.

  • 04

    How does the AI know which tags are available?

    The AI uses the list_tags tool to see the specific labels used by the city to organize their datasets.

  • 05

    Can I ask for data from other cities?

    No. This specific connector is built only for the Ayuntamiento de Madrid (CKAN) instance.

  • 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