VS Code CopilotIDE

Ayuntamiento de Barcelona (CKAN) MCP Server

Bring Open Data
to VS Code Copilot

Name: Ayuntamiento de Barcelona (CKAN) MCP Server
Price: 29 USD
Availability: InStock
Rating: 0.2 (1 reviews)
Author: Vinkius

Learn how to connect Ayuntamiento de Barcelona (CKAN) to VS Code Copilot and start using 7 AI agent tools in minutes. Fully managed, enterprise secure, and ready to use without writing a single line of code.

GDPR Free for Subscribers

Bcn Current PackagesBcn Datastore SearchBcn Datastore Search SqlBcn Package ListBcn Package SearchBcn Package ShowBcn Resource Show

Unlock for AI Agents

Ask AI about this MCP Server ChatGPT Claude Perplexity

Compatible with every major AI agent and IDE

Claude

ChatGPT

Cursor

Gemini

Windsurf

VS Code

JetBrains

Vercel

+ other MCP clients

What is the Ayuntamiento de Barcelona (CKAN) MCP Server?

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.

Built-in capabilities (7)

bcn_current_packages

List datasets including their resources

bcn_datastore_search

Search and filter records within a specific CSV resource

bcn_datastore_search_sql

The table name must be the resource_id wrapped in double quotes. Execute SQL queries directly against a resource

bcn_package_list

List all dataset names in the Open Data BCN catalogue

bcn_package_search

Search for datasets matching specific criteria

bcn_package_show

Get metadata for a specific dataset

bcn_resource_show

Get metadata for a specific resource

Why VS Code Copilot?

GitHub Copilot Agent mode brings Ayuntamiento de Barcelona (CKAN) data directly into your VS Code workflow. With a project-scoped config, the entire team shares access to 7 tools. Copilot queries live data, generates typed code, and writes tests from actual API responses, all without leaving the editor.

—
VS Code is used by over 70% of developers. adding MCP tools to Copilot means your team can leverage external data without leaving their primary editor
—
Project-scoped MCP configs (.vscode/mcp.json) let you commit server configurations to your repository, ensuring the entire team shares the same tool access
—
Copilot's Agent mode integrates MCP tools seamlessly with file editing, terminal commands, and workspace search in a single agentic loop
—
GitHub's enterprise compliance and audit features extend to MCP tool usage, providing visibility into how AI interacts with external services

See it in action

Ayuntamiento de Barcelona (CKAN) in VS Code Copilot

AI Agent→Vinkius

High Security·Kill Switch·Plug and Play

Why Vinkius

Ayuntamiento de Barcelona (CKAN) and 4,000+ other MCP servers. One platform. One governance layer.

Teams that connect Ayuntamiento de Barcelona (CKAN) to VS Code Copilot through Vinkius don't need to source, host, or maintain individual MCP servers. Every tool call runs inside a hardened runtime with credential isolation, DLP, and a signed audit chain.

4,000+MCP Servers ready

<40msCold start

60%Token savings

	Raw MCP	Vinkius
Server catalog	Find and host yourself	4,000+ managed
Infrastructure	Self-hosted	Sandboxed V8 isolates
Credential handling	Plaintext in config	Vault + runtime injection
Data loss prevention	None	Configurable DLP policies
Kill switch	None	Global instant shutdown
Financial circuit breakers	None	Per-server limits + alerts
Audit trail	None	Ed25519 signed logs
SIEM log streaming	None	Splunk, Datadog, Webhook
Honeytokens	None	Canary alerts on leak
Custom domains	Not applicable	DNS challenge verified
GDPR compliance	Manual effort	Automated purge + export

Unlock for AI Agents View step-by-step setup guide for VS Code Copilot →

Enterprise Security

Why teams choose Vinkius for Ayuntamiento de Barcelona (CKAN) in VS Code Copilot

The Ayuntamiento de Barcelona (CKAN) MCP Server runs on Vinkius-managed infrastructure inside AWS — a purpose-built runtime with per-request V8 isolates, Ed25519 signed audit chains, and sub-40ms cold starts. All 7 tools execute in hardened sandboxes optimized for native MCP execution.

Your AI agents in VS Code Copilot only access the data you authorize, with DLP that blocks sensitive information from ever reaching the model, kill switch for instant shutdown, and up to 60% token savings. Enterprise-grade infrastructure, zero maintenance.

Unlock for AI Agents View full Ayuntamiento de Barcelona (CKAN) details →

Fully ManagedVinkius Servers

60%Token savings

High SecurityEnterprise-grade

IAMAccess control

EU AI ActCompliant

DLPData protection

V8 IsolateSandboxed

Ed25519Audit chain

<40msKill switch

Stream every event to Splunk, Datadog, or your own webhook in real-time

* Every MCP server runs on Vinkius-managed infrastructure inside AWS - a purpose-built runtime with per-request V8 isolates, Ed25519 signed audit chains, and sub-40ms cold starts optimized for native MCP execution. See our infrastructure

The Vinkius Advantage

How Vinkius secures
Ayuntamiento de Barcelona (CKAN) for VS Code Copilot

Every tool call from VS Code Copilot to the Ayuntamiento de Barcelona (CKAN) MCP Server is protected by DLP redaction, cryptographic audit chains, V8 sandbox isolation, kill switch, and financial circuit breakers.

< 40msCold start

Ed25519Signed audit chain

60%Token savings

FAQ

Frequently asked questions

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.

Which VS Code version supports MCP?

MCP support requires VS Code 1.99 or later with the GitHub Copilot extension. Ensure both are updated to the latest version. Older versions of Copilot may not expose the Agent mode toggle.

How do I switch to Agent mode?

Open the Copilot Chat panel and look for two mode options: "Ask" and "Agent". Click "Agent" to enable autonomous tool calling. In Ask mode, Copilot provides conversational answers but cannot invoke MCP tools.

Can I restrict which MCP tools Copilot can access?

Yes. VS Code shows a tool consent dialog before any MCP tool is invoked for the first time. You can also configure tool access policies at the organization level through GitHub Copilot settings.

Does MCP work in VS Code Remote or Codespaces?

Yes. MCP servers configured via .vscode/mcp.json work in Remote SSH, WSL, and GitHub Codespaces environments. The MCP connection is established from the remote host, so ensure the server URL is accessible from that environment.