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

Q: Can Claude Desktop perform SQL queries on Ayuntamiento de Barcelona (CKAN) data?

Yes, it uses the bcndatastoresearchsql tool to run commands directly. You just provide the resource ID and your query, and it returns the data.

Query Barcelona's public datasets directly in Claude Desktop with this MCP Server.

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 Claude Desktop

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Browse BCN Open Data in Claude Desktop

Get instant access to urban datasets using `bcn_package_list` or `bcn_package_search`. You can explore what's available without leaving your chat window. It pulls metadata through `bcn_package_show` so you know exactly what you're looking at before you commit to a deep dive.

Execute SQL on Barcelona Records

Run custom queries against specific datasets using `bcn_datastore_search_sql`. Write your SQL code and let Claude Desktop handle the heavy lifting of fetching the results. This bypasses the need for manual CSV downloads. You get the raw numbers fed straight into your conversation.

Filter Local Datasets by Resource

Use `bcn_datastore_search` to pinpoint specific records inside a Barcelona dataset. It's built for finding needles in data haystacks without manual filtering. `bcn_resource_show` gives you the context on those files. You'll see exactly how the data is structured before querying it.

Setup guide

Set up Ayuntamiento de Barcelona (CKAN) MCP in Claude Web or Desktop

1

Open Claude Settings

Go to claude.ai, click your profile icon, then navigate to Customize → Connectors.
2

Add Custom Connector

Click the "+" button and select Add custom connector. Paste your Vinkius endpoint URL: https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. For OAuth-protected servers, expand Advanced settings to add credentials.
3

Start a conversation

Open a new chat. The Ayuntamiento de Barcelona (CKAN) MCP tools are available immediately — no restart needed.

Endpoint URL

https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp

No configuration file needed — paste the URL directly in the Claude web interface.

Available on Free (1 connector), Pro, Max, Team, and Enterprise plans.

Prerequisites

Claude Desktop installed (macOS or Windows)
Active Vinkius subscription with a valid endpoint token

1

Open Claude Desktop Settings

Click the menu icon at the top-left corner, go to Settings → Developer → Edit Config. This opens claude_desktop_config.json in your default text editor.
2

Paste the Ayuntamiento de Barcelona (CKAN) MCP configuration

Copy the JSON snippet on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Restart Claude Desktop

Close and reopen the application. Claude needs a full restart to load new MCPs — refreshing a conversation is not enough.
4

Verify the connection

Open a new conversation. Click the 🔌 icon at the bottom of the message input. You should see tools listed under ayuntamiento-de-barcelona-ckan-mcp.

json

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

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 Claude Desktop

Open your configuration file located at your Claude Desktop settings path. Paste the server details under the mcpServers key, save the file, and restart the application.

Yes, it uses the `bcn_datastore_search_sql` tool to run commands directly. You just provide the resource ID and your query, and it returns the data.

Most public datasets are open, but check the documentation if you hit rate limits. The server connects directly to the portal's public API.

The server only touches public urban records and statistics. It does not handle your personal files or credentials.

Look for the hammer icon in your chat input area. If it's there, your tools are ready for use.

Use it with your favorite AI tools

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