Ayuntamiento de Madrid (CKAN) MCP Connector for Claude

Connect to the official Open Data portal of the Madrid City Council and explore thousands of public datasets through natural conversation. This server interfaces with the city's CKAN repository to provide real-time access to municipal information.

What you can do

• Dataset Discovery — List all available packages or search for specific topics like transport, environment, or budget using list_packages and search_packages.
• Metadata Inspection — Retrieve deep metadata for any dataset, including its maintainer, update frequency, and license using get_package.
• Resource Access — Identify specific files (CSV, JSON, XLS) within a dataset and fetch their individual metadata using get_resource or search_resources.
• Organizational Mapping — List all municipal departments and organizations that publish data to understand the source of the information using list_organizations.
• Categorization — Browse data by groups or tags to find related information across different city sectors using list_groups and list_tags.

How it works

1. Subscribe to this server
2. Enter your API Key from the Madrid Data portal (if required for specific endpoints)
3. Start querying city data from Claude, Cursor, or any MCP-compatible client

Who is this for?

• Data Analysts — quickly find and inspect municipal datasets for urban research or trend analysis.
• Developers — retrieve resource IDs and metadata to integrate city data into applications without leaving the IDE.
• Citizens & Researchers — explore public information about Madrid's services, environment, and economy through simple questions.