How to Use the Ayuntamiento de Barcelona (CKAN) MCP in CrewAI

Q: How do I add the Ayuntamiento de Barcelona (CKAN) MCP Server to a CrewAI agent?

Pass the Vinkius server URL directly into your agent's mcps array parameter. CrewAI automatically configures the transport and exposes tools like bcnpackagesearch to that specific agent.

Q: How do CrewAI agents handle SQL query errors on Ayuntamiento de Barcelona (CKAN) resources?

If the analyst agent fails a query using bcndatastoresearchsql, CrewAI's shared memory allows a supervisor agent to intervene, inspect the error, and suggest a corrected query.

Deploy specialized CrewAI agent teams to research, query, and analyze Barcelona's public datasets autonomously.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Ayuntamiento de Barcelona (CKAN) MCP to CrewAI

Create your Vinkius account to connect Ayuntamiento de Barcelona (CKAN) to CrewAI and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Ayuntamiento de Barcelona (CKAN) with CrewAI

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Multi-agent research teams for Barcelona data

The `bcn_package_search` tool allows your research agent to scan the Open Data BCN catalog for specific urban datasets. Instead of a single agent doing everything, CrewAI lets you assign this search task to a dedicated researcher. Once the researcher finds the dataset, it passes the metadata to an analyst agent. This analyst uses `bcn_datastore_search` to extract specific CSV records, collaborating through CrewAI's shared memory to build a detailed report.

Autonomous SQL analysis with CrewAI agents

The `bcn_datastore_search_sql` tool executes raw SQL queries on Barcelona's public tables, which your analyst agent can run autonomously. The agent writes its own queries, wraps the resource ID in double quotes, and processes the returned rows. A moderator agent can monitor this session. If the analyst agent encounters an SQL syntax error, the moderator catches it, logs the issue, and instructs the analyst to rewrite the query using `bcn_resource_show` metadata.

Hierarchical catalog monitoring on Vinkius

The `bcn_package_list` tool fetches the entire active dataset catalog from the Barcelona portal, initiating your CrewAI workflow. A manager agent coordinates the process, assigning sub-tasks to worker agents based on the returned list. Worker agents then use `bcn_package_show` to inspect modified datasets. This hierarchical execution ensures your team of agents handles large-scale municipal data audits without overlapping tasks or wasting API calls.

Setup guide

Set up Ayuntamiento de Barcelona (CKAN) MCP in CrewAI

Prerequisites

Python 3.10+ installed
crewai package (pip install crewai)
Active Vinkius subscription with a valid endpoint token

1

Install CrewAI
Run pip install crewai to install the framework. MCP support is built-in via the mcps parameter.
2

Add the MCP URL to your agent
Pass your Vinkius endpoint directly to the mcps list. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. CrewAI handles tool discovery and caching automatically.
3

Kick off your crew
Create a Crew with your agent and tasks. Call crew.kickoff() — the agent will automatically invoke Ayuntamiento de Barcelona (CKAN) tools as needed.

crew.py

from crewai import Agent, Task, Crew

agent = Agent(
    role="Ayuntamiento de Barcelona (CKAN) Analyst",
    goal="Access and analyze Ayuntamiento de Barcelona (CKAN) data via MCP.",
    backstory="Expert analyst with direct Ayuntamiento de Barcelona (CKAN) access.",
    mcps=[
        "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    ],
)

task = Task(
    description="List recent Ayuntamiento de Barcelona (CKAN) transactions",
    agent=agent,
    expected_output="A summary of recent activity",
)

crew = Crew(agents=[agent], tasks=[task])
result = crew.kickoff()
print(result)

Get your connection token →

Prerequisites

Python 3.10+ installed
crewai + crewai-tools packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies
Run pip install crewai crewai-tools. The MCPServerAdapter handles lifecycle management and tool conversion.
2

Connect with MCPServerAdapter
Use MCPServerAdapter as a context manager with SseServerParameters pointing to your Vinkius endpoint. The adapter automatically manages connection lifecycle.
3

Assign tools and run
Pass the returned mcp_tools to your agent's tools parameter. The adapter converts MCP tools to native BaseTool objects compatible with all CrewAI agents.

crew.py

from crewai import Agent, Task, Crew
from crewai_tools import MCPServerAdapter
from mcp import SseServerParameters

server_params = SseServerParameters(
    url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
)

with MCPServerAdapter(server_params) as mcp_tools:
    agent = Agent(
        role="Ayuntamiento de Barcelona (CKAN) Analyst",
        goal="Access and analyze Ayuntamiento de Barcelona (CKAN) data via MCP.",
        backstory="Expert analyst with direct Ayuntamiento de Barcelona (CKAN) access.",
        tools=mcp_tools,
    )

    task = Task(
        description="List recent Ayuntamiento de Barcelona (CKAN) transactions",
        agent=agent,
        expected_output="A summary of recent activity",
    )

    crew = Crew(agents=[agent], tasks=[task])
    result = crew.kickoff()
    print(result)

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Open Data BCN. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Ayuntamiento de Barcelona (CKAN) now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Ayuntamiento de Barcelona (CKAN) MCP in CrewAI

Pass the Vinkius server URL directly into your agent's `mcps` array parameter. CrewAI automatically configures the transport and exposes tools like `bcn_package_search` to that specific agent.

Yes. You can expose the tools globally or use the MCP Server to filter which agents get access to specific tools like `bcn_datastore_search_sql` or `bcn_package_show`.

If the analyst agent fails a query using `bcn_datastore_search_sql`, CrewAI's shared memory allows a supervisor agent to intervene, inspect the error, and suggest a corrected query.

Yes. CrewAI supports stdio, SSE, and Streamable HTTP transports, allowing your multi-agent teams to connect to the Vinkius-hosted MCP Server with minimal configuration.

Yes. The server only reads public urban data, environmental records, and municipal statistics from the Open Data BCN portal. Vinkius runs the server in an ephemeral sandbox, securing your agent's session tokens.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript