Fire in da houseTop Tip:Paying $100+ per month for Perplexity, MidJourney, Runway, ChatGPT and other tools is crazy - get all your AI tools in one site starting at $15 per month with Galaxy AI Fire in da houseCheck it out free

kolada-mcp

MCP.Pizza Chef: aerugo

Kolada MCP Server is a middleware solution that connects LLMs with Kolada, Sweden's extensive municipal and regional statistical database. It enables structured querying and semantic search of thousands of Key Performance Indicators (KPIs), simplifying data-driven analysis and comparisons across Swedish municipalities and regions. This server facilitates rich exploration and interpretation of public sector statistics through intelligent, LLM-powered interfaces.

Use This MCP server To

Query Swedish municipal KPIs with natural language Perform data-driven comparisons of regional statistics Enable semantic search over public sector statistical data Integrate Kolada data into LLM-based analytic applications Generate reports from structured municipal performance data Support decision-making with real-time access to KPIs Automate extraction of insights from Swedish regional data

README

Kolada MCP Server

https://modelcontextprotocol.io

Kolada MCP Server enables seamless integration between Large Language Models (LLMs) and Kolada, Sweden’s comprehensive municipal and regional statistical database. It provides structured access to thousands of Key Performance Indicators (KPIs), facilitating rich, data-driven analysis, comparisons, and explorations of public sector statistics.

Overview

Kolada MCP Server acts as intelligent middleware between LLM-based applications and the Kolada database, allowing easy querying and analyzing of data related to Swedish municipalities and regions. With semantic search capabilities and robust analysis tools, Kolada MCP significantly simplifies navigating and interpreting the vast array of KPIs in Kolada.

Example Queries

Ask Kolada MCP Server complex questions requiring data analysis:

  • Where in Sweden should a family move to find affordable housing, good schools, and healthcare?
  • Investigate the connection between unemployment and mental illness in Västernorrland.
  • Identify municipalities with the highest increase in preschool quality over the last five years.
  • Create a dashboard visualizing municipalities with the best and worst public transportation.

Features

  • Semantic Search: Natural language queries for KPIs.
  • Category Filtering: Access KPIs grouped by thematic areas.
  • Municipal & Regional Data Retrieval: Fetch KPI data or historical time series.
  • Multi-Year Comparative Analysis: Evaluate KPI performance changes across municipalities.
  • Cross-KPI Correlation: Analyze relationships between KPIs.

Available Tools

  1. list_operating_areas: Retrieve available KPI categories.
  2. get_kpis_by_operating_area: List KPIs under a category.
  3. search_kpis: Discover KPIs using semantic search.
  4. get_kpi_metadata: Access detailed KPI metadata.
  5. fetch_kolada_data: Retrieve KPI values.
  6. analyze_kpi_across_municipalities: In-depth municipal KPI analysis.
  7. compare_kpis: Evaluate KPI correlations.
  8. list_municipalities: List municipality IDs and names.

Quick Start

Kolada MCP Server includes pre-cached KPI metadata. Delete kpi_embeddings.npz to refresh.

Installation

Use uv to install Kolada MCP dependencies:

uv sync

Running Locally for Development

Start the server locally:

uv run mcp dev server.py

Open MCP Inspector at http://localhost:5173 to test and debug.

Claude Desktop Integration

Edit your claude_desktop_config.json to add Kolada MCP Server:

Docker Image (Local Build)

"KoladaDocker": {
  "args": [
    "run",
    "-i",
    "--rm",
    "--name",
    "kolada-mcp-managed",
    "kolada-mcp:local"
  ],
  "command": "docker",
  "env": {}
}

Prebuilt Container via PyPI

"KoladaPyPI": {
  "args": ["kolada-mcp"],
  "command": "/Users/hugi/.cargo/bin/uvx"
}

Local UV Execution (without Docker)

Replace [path to kolada-mcp] with your local directory:

"KoladaLocal": {
  "args": [
    "--directory",
    "[path to kolada-mcp]/src/kolada_mcp",
    "run",
    "kolada-mcp"
  ],
  "command": "uv"
}

Restart Claude Desktop after updating.

Contributing

Contributions are welcome! Submit issues, enhancements, or PRs on GitHub.

Disclaimer

Kolada MCP Server is independently developed, not endorsed by or affiliated with RKA or other organizations.

License

Kolada MCP Server is licensed under the Apache License 2.0.

kolada-mcp FAQ

How does Kolada MCP Server connect to the Kolada database?
It acts as middleware, exposing Kolada's KPIs via structured APIs accessible to LLMs.
Can I query Kolada data using natural language?
Yes, the server supports semantic search and natural language queries for easy data access.
What types of data are available through Kolada MCP Server?
Thousands of KPIs covering Swedish municipalities and regions' public sector statistics.
Is Kolada MCP Server limited to Swedish data only?
Yes, it specifically provides access to Sweden's municipal and regional statistical data.
How does Kolada MCP Server improve LLM applications?
It enriches LLMs with real-time, structured public sector data for enhanced analysis and insights.
What are the technical requirements to deploy Kolada MCP Server?
It requires connectivity to the Kolada database and an environment supporting MCP server protocols.
Can Kolada MCP Server handle complex analytical queries?
Yes, it supports advanced querying and data analysis over large KPI datasets.
Is the Kolada MCP Server open source?
The GitHub repository provides source code and documentation for deployment and integration.