How to Use the Ayuntamiento de Barcelona (CKAN) MCP in Vercel AI SDK

Q: How do I connect the Ayuntamiento de Barcelona (CKAN) tools to my Vercel AI SDK project?

Install @ai-sdk/mcp and initialize the client using createMCPClient with the Vinkius URL. Pass the tools from the server into your generateText or streamText function, then call mcpClient.close() once the execution finishes.

Q: Can my Vercel AI SDK app run raw SQL queries on Ayuntamiento de Barcelona (CKAN) tables?

Yes. Your agent uses bcndatastoresearchsql to run raw SQL queries, wrapping the resource ID in double quotes. The SDK streams the municipal data rows directly into your UI components in real-time.

Q: What happens if a Barcelona CKAN dataset search returns a massive payload?

Your agent uses bcnpackageshow to inspect the metadata first. The SDK allows you to stream specific resource links instead of downloading the entire dataset, preventing browser memory crashes.

Stream live Barcelona urban datasets and SQL query results directly into your Vercel AI SDK frontend without loading spinners.

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 Vercel AI SDK

Create your Vinkius account to connect Ayuntamiento de Barcelona (CKAN) to Vercel AI SDK 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 Vercel AI SDK

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Stream Barcelona SQL queries live with Vercel AI SDK

The `bcn_datastore_search_sql` tool lets your agent execute raw SQL queries directly against Barcelona's public data resources. Instead of waiting for a massive payload to download and parse, the Vercel AI SDK streams the resulting rows straight to your React or Next.js components. You set up the MCP client using `createMCPClient` and pass the tools directly to `streamText`. Your users watch the city's environmental metrics or traffic statistics render on screen line-by-line as the database processes the request.

Instant dataset discovery on the Edge

The `bcn_package_search` tool queries the Open Data BCN catalog to find matching datasets on demand. Running this inside Edge Functions means your application resolves search queries with minimal latency, avoiding heavy server-side overhead. Once your agent finds the dataset, it uses `bcn_resource_show` to inspect the available CSV files. The SDK handles the raw metadata stream, letting your frontend build dynamic data tables for the user on the fly.

Raw datastore filtering without UI blocking

The `bcn_datastore_search` tool filters specific records within Barcelona's CSV resources using direct search parameters. This MCP Server integration ensures your frontend stays interactive while your agent parses thousands of public records. By feeding these tools into the SDK's streaming loop, you bypass the traditional fetch-and-wait pattern. The user gets immediate visual feedback as the agent narrows down municipal statistics.

Setup guide

Set up Ayuntamiento de Barcelona (CKAN) MCP in Vercel AI SDK

Prerequisites

Node.js 18+ and a TypeScript project
ai + @modelcontextprotocol/sdk packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies

Run npm install ai @modelcontextprotocol/sdk plus your preferred model provider (e.g. @ai-sdk/openai).
2

Create the Streamable HTTP transport

Use StreamableHTTPClientTransport with your Vinkius endpoint URL. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Discover and use tools

Call mcpClient.tools() to auto-discover all Ayuntamiento de Barcelona (CKAN) tools. Pass them directly to generateText() or streamText() — no manual schema definitions needed.
4

Works with any model provider

Swap openai("gpt-4o") for any AI SDK provider — Anthropic, Google, Mistral. The MCP tools work identically across all supported models.

index.ts

import { experimental_createMCPClient as createMCPClient } from "ai";
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp";
import { generateText } from "ai";
import { openai } from "@ai-sdk/openai";

const transport = new StreamableHTTPClientTransport(
  new URL("https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp")
);

const mcpClient = await createMCPClient({ transport });
const tools = await mcpClient.tools();

const { text } = await generateText({
  model: openai("gpt-4o"),
  tools,
  prompt: "List recent Ayuntamiento de Barcelona (CKAN) transactions",
});

console.log(text);
await mcpClient.close();

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 Vercel AI SDK

Install `@ai-sdk/mcp` and initialize the client using `createMCPClient` with the Vinkius URL. Pass the tools from the server into your `generateText` or `streamText` function, then call `mcpClient.close()` once the execution finishes.

Yes. Your agent uses `bcn_datastore_search_sql` to run raw SQL queries, wrapping the resource ID in double quotes. The SDK streams the municipal data rows directly into your UI components in real-time.

This MCP Server runs on Vinkius's V8 sandbox, meaning your Edge Functions only make light HTTP calls. The `bcn_package_list` tool fetches dataset names instantly without bloating your edge deployment size.

Your agent uses `bcn_package_show` to inspect the metadata first. The SDK allows you to stream specific resource links instead of downloading the entire dataset, preventing browser memory crashes.

This MCP Server only handles public urban data, environmental records, and municipal statistics from Barcelona, meaning no personal user data is sent to the CKAN API. Vinkius secures the connection via ephemeral, zero-trust token isolation.

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