Bring Open Data
to Cursor
Learn how to connect Ayuntamiento de Barcelona (CKAN) to Cursor 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 SubscribersCompatible with every major AI agent and IDE
Gemini
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 Cursor?
Cursor's Agent mode turns Ayuntamiento de Barcelona (CKAN) into an in-editor superpower. Ask Cursor to generate code using live data from Ayuntamiento de Barcelona (CKAN) and it fetches, processes, and writes. all in a single agentic loop. 7 tools appear alongside file editing and terminal access, creating a unified development environment grounded in real-time information.
- —
Agent mode turns Cursor into an autonomous coding assistant that can read files, run commands, and call MCP tools without switching context
- —
Cursor's Composer feature can generate entire files using real-time data fetched through MCP. no copy-pasting from external dashboards
- —
MCP tools appear alongside built-in tools like file reading and terminal access, creating a unified agentic environment
- —
VS Code extension compatibility means your existing workflow, keybindings, and extensions all work alongside MCP tools
Ayuntamiento de Barcelona (CKAN) in Cursor
Ayuntamiento de Barcelona (CKAN) and 4,000+ other MCP servers. One platform. One governance layer.
Teams that connect Ayuntamiento de Barcelona (CKAN) to Cursor 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 Cursor
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 Cursor 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 Cursor
Every tool call from Cursor 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.
What is Agent mode and why does it matter for MCP?
Agent mode is Cursor's autonomous execution mode where the AI can perform multi-step tasks: reading files, editing code, running terminal commands, and calling MCP tools. Without Agent mode, Cursor operates in a simpler ask-and-answer mode that doesn't support tool calling. Always ensure you're in Agent mode when working with MCP servers.
Where does Cursor store MCP configuration?
Cursor looks for MCP server configurations in a mcp.json file. You can configure servers at the project level (.cursor/mcp.json in your project root) or globally (~/.cursor/mcp.json). Project-level configs take precedence.
Can Cursor use MCP tools in inline edits?
No. MCP tools are only available in Agent mode through the chat panel. Inline completions and Tab suggestions do not trigger MCP tool calls. This is by design. tool calls require user visibility and approval.
How do I verify MCP tools are loaded?
Open Settings → Features → MCP and look for your server name. A green indicator means the server is connected. You can also check Agent mode's available tools by clicking the tools dropdown in the chat panel.
Tools not appearing in Cursor
Ensure you are in Agent mode (not Ask mode). MCP tools only work in Agent mode.
Server shows as disconnected
Check Settings → Features → MCP and verify the server status. Try clicking the refresh button.
Explore More MCP Servers
View all →
NASA APOD — Astronomy Picture of the Day
3 toolsAccess NASA's most popular service: the Astronomy Picture of the Day. Browse today's image, explore the 30-year archive back to 1995, retrieve images by date range, or discover random astronomical treasures — each with expert explanations from professional astronomers.
Zoho Desk
13 toolsAI-powered helpdesk: manage tickets, contacts, and support workflows via agents.
Calendly
10 toolsAutomate scheduling workflows via Calendly — manage event types, scheduled events, invitees, and availability directly from any AI agent.
Odoo Helpdesk
7 toolsCreate and manage support tickets, track SLAs, organize helpdesk teams — Odoo Helpdesk through natural conversation.