Bring Open Data
to Google ADK
Learn how to connect Ayuntamiento de Barcelona (CKAN) to Google ADK and start using 7 AI agent tools in minutes. Fully managed, enterprise secure, and ready to use without writing a single line of code.
Compatible with every major AI agent and IDE
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_searchto filter records within CSV resources or execute complexbcn_datastore_search_sqlqueries 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)
List datasets including their resources
Search and filter records within a specific CSV resource
The table name must be the resource_id wrapped in double quotes. Execute SQL queries directly against a resource
List all dataset names in the Open Data BCN catalogue
Search for datasets matching specific criteria
Get metadata for a specific dataset
Get metadata for a specific resource
Why Google ADK?
Google ADK natively supports Ayuntamiento de Barcelona (CKAN) as an MCP tool provider. declare Vinkius Edge URL and the framework handles discovery, validation, and execution automatically. Combine 7 tools with Gemini's long-context reasoning for complex multi-tool workflows, with production-ready session management and evaluation built in.
- —
Google ADK natively supports MCP tool servers. declare a tool provider and the framework handles discovery, validation, and execution
- —
Built on Gemini models, ADK provides long-context reasoning ideal for complex multi-tool workflows with Ayuntamiento de Barcelona (CKAN)
- —
Production-ready features like session management, evaluation, and deployment come built-in. not bolted on
- —
Seamless integration with Google Cloud services means you can combine Ayuntamiento de Barcelona (CKAN) tools with BigQuery, Vertex AI, and Cloud Functions
Ayuntamiento de Barcelona (CKAN) in Google ADK
Ayuntamiento de Barcelona (CKAN) and 4,000+ other MCP servers. One platform. One governance layer.
Teams that connect Ayuntamiento de Barcelona (CKAN) to Google ADK 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.
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 |
Why teams choose Vinkius for Ayuntamiento de Barcelona (CKAN) in Google ADK
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 Google ADK 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.

* 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
How Vinkius secures
Ayuntamiento de Barcelona (CKAN) for Google ADK
Every tool call from Google ADK 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.
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.
How does Google ADK connect to MCP servers?
Import the MCP toolset class and pass the server URL. ADK discovers and registers all tools automatically, making them available to your agent's tool-use loop.
Can ADK agents use multiple MCP servers?
Yes. Declare multiple MCP tool providers in your agent configuration. ADK merges all tool schemas and the agent can call tools from any server in a single turn.
Which Gemini models work best with MCP tools?
Gemini 2.0 Flash and Pro models both support function calling required for MCP tools. Flash is recommended for latency-sensitive use cases, Pro for complex reasoning.
McpToolset not found
Update: pip install --upgrade google-adk
Explore More MCP Servers
View all →
Everyware Payments & Messaging
10 toolsEquip your AI agent to manage payments, track digital invoices, and monitor SMS messages via the Everyware API.

Envoy
10 toolsManage workplace operations via Envoy — register visitors, book desks and rooms, track deliveries, and monitor office capacity directly from any AI agent.

PBGC Pension Data
4 toolsAccess official US Pension Benefit Guaranty Corporation data — query single and multiemployer plans, ERISA 4044 rates, and financial assistance records.

Smeetz
6 toolsManage your Smeetz commerce operations — list products, handle bookings, and manage customer data directly from any AI agent.
