Human Capital Analytics MCP Server
Analyse Latvia’s job market: 107,000+ unique vacancies from 4 employment portals with AI-extracted occupation codes, salary data, skills classification, and employer analytics.
Overview
This MCP server provides SQL access to a comprehensive job vacancy analytics database. Raw vacancy advertisements are collected daily from four Latvian employment portals, deduplicated, processed through LLM-based entity extraction, and enriched with business registry data, ISCO occupation codes, and ESCO skills classification.
Data Sources
nva.gov.lv (government employment agency), cv.lv, visidarbi.lv, and ss.lv — covering the vast majority of Latvia’s online job market.
AI Processing
Each vacancy is processed by LLM to extract 29 structured fields: occupation, salary, location, education requirements, language skills, and more.
Enrichment
Linked to Latvia’s business registry (111K companies) and classified with ISCO occupation codes and ESCO skills taxonomy.
Connection
{
"mcpServers": {
"latvia-human-capital": {
"url": "https://mcp-hc.stat.gov.lv/mcp"
}
}
}Endpoint: https://mcp-hc.stat.gov.lv/mcp · Transport: Streamable HTTP · No API key required
Available Tools
| Tool | Purpose | Key Parameters |
|---|---|---|
getContext |
Get database schema, table descriptions, join patterns, JSON structures, query templates | — |
execute_sql |
Execute read-only SQL queries against the human capital database | query: SQL string |
explain_query |
Get execution plan for a SQL query | query: SQL string |
list_objects |
List available tables and views | schema (optional) |
get_object_details |
Get column definitions for a table | object_name: table name |
Key Database Tables
| Table | Rows | Description |
|---|---|---|
vacancies_raw_unique | ~107,700 | Deduplicated vacancies with first/last seen dates |
vacancies_llm_res | ~98,300 | LLM-extracted structured data (29 fields per vacancy) |
vacancies_breg | ~127,400 | Links to business registry for employer identification |
vacancies_esco_skills | ~30,600 | ESCO skills classification per vacancy |
business_reg | ~111,000 | Latvia business registry with NACE codes |
nace_21 | — | NACE Rev 2.1 economic activity classification |
prof_klas | — | ISCO professional classification (occupation codes) |
vacancies_raw_all | ~1,658,000 | Complete raw scraping history from all sources |
Data Sources
| Portal | Vacancies | Type |
|---|---|---|
| ss.lv | ~51,200 | General classifieds |
| nva.gov.lv | ~28,500 | Government employment agency |
| cv.lv | ~23,000 | Commercial job portal |
| visidarbi.lv | ~5,000 | Commercial job portal |
Example Questions
- What are the most in-demand occupations in Latvia right now?
- What is the average salary for software developers in Riga?
- Which companies are hiring the most people?
- What percentage of jobs offer remote work?
- Which NACE sectors have the most job openings?
- What are the most demanded ESCO skills?
- How has vacancy volume changed week by week?
- Which occupations have the highest salary ranges?
- Compare salary ranges between Riga and other regions
- What education levels are most commonly required?
Data Coverage
Vacancy collection began in August 2025 and is ongoing. The database is updated daily with new vacancy scrapes from all four portals. LLM processing and ESCO classification run in batch after new vacancies are collected.
Free to use under CC BY 4.0 license. No authentication required.