Open Data

Scottish Government Statistics MCP Server

Chat with AI and run tools instantly.

Scottish Government official statistics via the statistics.gov.scot SPARQL endpoint. Query datasets on earnings, housing, health, education, crime, population, and more for Scottish regions and council areas.

Chat with AI
Managed
2 tools
Agent guide included

Chat with AI and run tools instantly.

Browse all tools

AI Skill
SKILL.md

Domain knowledge for Scottish Government Statistics — workflow patterns, data models, and gotchas for your AI agent.

Scottish Government Statistics

statistics.gov.scot is the Scottish Government's official open data platform built on linked data (RDF). Data is queried via a SPARQL endpoint.

Data Model

  • Datasets — Statistical datasets identified by URI (e.g. http://statistics.gov.scot/data/earnings). Each dataset has observations with dimensions and measures.
  • Dimensions — Categories like geography, time period, gender, age group.
  • Measures — Numeric values (counts, percentages, rates).
  • Geographies — Scottish council areas, health boards, parliamentary constituencies, data zones.

Common Dataset URIs

  • http://statistics.gov.scot/data/earnings — Earnings by geography and gender
  • http://statistics.gov.scot/data/house-sales-prices — House prices
  • http://statistics.gov.scot/data/economic-inactivity — Economic inactivity
  • http://statistics.gov.scot/data/mid-year-pop-est — Mid-year population estimates
  • http://statistics.gov.scot/data/crime-and-justice — Crime and justice
  • http://statistics.gov.scot/data/hospital-admissions — Hospital admissions

SPARQL Patterns

List all datasets
SELECT DISTINCT ?dataset ?label WHERE { ?dataset a <http://publishmydata.com/def/dataset#Dataset> . ?dataset <http://www.w3.org/2000/01/rdf-schema#label> ?label } ORDER BY ?label
Get observations from a dataset
SELECT ?geo ?period ?value WHERE { ?obs <http://purl.org/linked-data/cube#dataSet> <http://statistics.gov.scot/data/earnings> . ?obs <http://purl.org/linked-data/sdmx/2009/dimension#refArea> ?geo . ?obs <http://purl.org/linked-data/sdmx/2009/dimension#refPeriod> ?period . ?obs <http://statistics.gov.scot/def/measure-properties/median> ?value } LIMIT 20

Gotchas

  • Queries can be slow for large datasets; always use LIMIT
  • The SPARQL endpoint accepts POST with query form parameter
  • Results return as application/sparql-results+json
  • Geographic URIs use Scottish-specific codes (S-codes)
  • Time periods are URIs like http://reference.data.gov.uk/id/year/2023

Tools in this Server (2)

Scottish Stats Datasets

List all available datasets on the Scottish Government Statistics platform. Returns dataset URIs and labels. Optionally filter by keyword. Covers earn...

Scottish Stats Sparql

Execute a custom SPARQL query against the Scottish Government Statistics linked data endpoint. Supports querying any dataset on statistics.gov.scot in...

Frequently Asked Questions

What is the Scottish Government Statistics MCP server?

Scottish Government official statistics via the statistics.gov.scot SPARQL endpoint. Query datasets on earnings, housing, health, education, crime, population, and more for Scottish regions and council areas. It provides 2 tools that AI agents can use through the Model Context Protocol (MCP).

How do I connect Scottish Government Statistics to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/scottish-stats. Authentication is handled automatically.

How many tools does Scottish Government Statistics provide?

Scottish Government Statistics provides 2 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does Scottish Government Statistics require?

Scottish Government Statistics uses open data APIs — no authentication required.

Setup Instructions

Connect Scottish Government Statistics to any MCP client in minutes

MCP URL
https://mcp.mcpbundles.com/bundle/scottish-stats
Claude.aiCursorVS CodeVS Code InsidersGooseLM StudioCherry StudioChatGPT

One-click install:

Install on Claude.aiInstall for organization (admins)

The link prefills the Add custom connector dialog — you still review the values and click Add, then Connect to complete OAuth.

Or add manually

  1. Open claude.ai → Settings → Connectors.
  2. Click the + button and choose Add custom connector.
  3. Set Name to Scottish Government Statistics and paste the MCP URL into Remote MCP server URL.
  4. Click Add. Scottish Government Statistics will appear under Not connected — select it and click Connect to complete OAuth.
Name: Scottish Government Statistics
Remote MCP server URL: https://mcp.mcpbundles.com/bundle/scottish-stats
Authentication: OAuth

Custom connectors at claude.ai require a paid Claude plan (Pro, Max, Team, or Enterprise).

Related MCP Servers

More open data integrations you might like

National Archives Discovery

The National Archives Discovery API — search and retrieve records from the UK's national archive cat...

4 tools
Open Data
HTS Tariff Codes

Search the US Harmonized Tariff Schedule (HTS) for import duty rates, tariff classifications, trade ...

3 tools
Open Data
UK Case Law

Search and retrieve UK court judgments and tribunal decisions from the National Archives Find Case L...

3 tools
Open Data
BGS OpenGeoscience OGCAPI

British Geological Survey OpenGeoscience OGC API. Access geology, earthquake, landslide, borehole, a...

3 tools
Open Data
Charge Atlas

Find EV charging stations anywhere in the world. Search by coordinates, map area, or driving route. ...

12 tools
Open Data
UK Civic & Parliamentary Data

UK democratic institutions, public records, and national statistics. Combines UK Parliament members,...

33 tools
Open Data

Try Scottish Government Statistics now

No API key or third-party login required. Chat with AI and run tools instantly.

Scottish Government Statistics MCP Server & Skill