Can I perform SQL queries on Barcelona's public datasets?

Yes, you can use the `bcn_datastore_search_sql` tool to execute SELECT statements directly against any resource that is stored in the portal's datastore.

How do I find datasets related to a specific topic like 'transport'?

Use the `bcn_package_search` tool with the query parameter `q` set to your topic. You can also limit the number of results for faster browsing.

Is it possible to see the actual rows of a CSV file without downloading it?

Absolutely. The `bcn_datastore_search` tool allows you to query and preview the contents of a resource directly, including filtering and sorting options.

Ayuntamiento de Barcelona (CKAN) MCP Connector for Claude

A+

Access the Open Data BCN portal to query urban datasets, environmental records, and public statistics directly through AI.

7 tools Official Updated Oct 1, 2026 Official Vinkius Partner

More Details Connect to Claude

Connect to the Ayuntamiento de Barcelona (Open Data BCN) portal and transform public data into actionable insights through natural conversation. This MCP server leverages the CKAN API to provide real-time access to Barcelona's official data repository.

What you can do

Dataset Discovery — List all available datasets or search for specific topics like transportation, environment, or demographics using bcn_package_search.
Metadata Inspection — Retrieve detailed metadata for specific datasets and resources to understand data structures and update frequencies.
Deep Data Querying — Use bcn_datastore_search to filter records within CSV resources or execute complex bcn_datastore_search_sql queries for precise data extraction.
Resource Management — List all resources associated with a dataset, including download links and format specifications.

How it works

Subscribe to this server
Enter your Open Data BCN API Token (optional for public data, required for higher rate limits)
Start querying Barcelona's public data from Claude, Cursor, or any MCP-compatible client

Who is this for?

Data Analysts & Researchers — Quickly fetch and filter urban data without manual CSV downloads.
Urban Planners — Access real-time statistics on city infrastructure and services.
Developers — Integrate official city data into applications using SQL-like queries directly from the AI.

open-dataurban-planningpublic-statisticsckan-apicity-datadata-discovery

Connect to Claude

Subscribe on Vinkius, then add this connector to Claude.ai or Claude Code.

① Claude.ai (web app)

Go to Settings → Connectors → Add custom connector
Paste the MCP endpoint URL below

https://edge.vinkius.com/vk_preview_iv5GYpi3FqmjfmjJOIvg9apgeu4Cf7aNs3ZIC6cs/mcp

② Claude Code (terminal)

claude mcp add --transport http ayuntamiento-de-barcelona-ckan https://edge.vinkius.com/vk_preview_iv5GYpi3FqmjfmjJOIvg9apgeu4Cf7aNs3ZIC6cs/mcp

③ Claude Desktop

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "ayuntamiento-de-barcelona-ckan": {
      "url": "https://edge.vinkius.com/vk_preview_iv5GYpi3FqmjfmjJOIvg9apgeu4Cf7aNs3ZIC6cs/mcp"
    }
  }
}

Get full access on Vinkius

The preview token above works for testing. Powered by Vinkius.

Details

Tools: 7
Grade: A+
Score: 100/100
Updated: Oct 1, 2026

Related Connectors

4D MCP

6 tools Official

Standard REST API for 4D Database — explore catalogs, query DataClasses, and manage entities via AI.

A+ View details →

ECB Discovery — Universal Statistical Data Access MCP

2 tools Official

Explore the complete ECB statistical catalog: browse all available dataflows (datasets) and query any ECB SDMX dataset with custom series keys — from exchange rates and monetary aggregates to banking supervision and payment statistics.

A+ View details →

DISCO MCP

6 tools Official

Query your DISCO eDiscovery datasets, data-usage changes, and review metrics directly from any AI agent via the official DISCO API.

A+ View details →

OceanBase MCP

10 tools Official

Enterprise distributed relational database — manage clusters, tenants, and databases via AI.

A+ View details →