Tool Reference
Complete list of tools available across all three MCP servers. Each tool is callable by any connected AI assistant.
PX-Web General Statistics
Endpoint: https://mcp-px.stat.gov.lv/mcp · Server documentation
| Tool | Purpose | Parameters |
|---|---|---|
getContext |
Get server documentation, workflow patterns, API structure | — |
choose_lang |
Set language (English or Latvian) | lang: "en" | "lv" |
get_topics |
Browse statistical domains (Population, Economy, etc.) | name, lang |
get_topic_content |
Get sub-categories within a domain | topic, lang |
get_titles |
List data tables in a category | topic_content_code, lang, url |
get_tables_by_keyword |
Search tables by keyword | keyword, lang |
filter_by_code |
Filter tables by code pattern | code, lang, url |
get_query_values |
Get dimensions and filter values for a report | topic_params, lang |
get_csp_data |
Retrieve statistical data with filters | topic_params, query_filters, lang |
construct_csp_link |
Generate URL to view report on data.stat.gov.lv | params, lang |
Foreign Trade Statistics
Endpoint: https://mcp-ft.stat.gov.lv/mcp · Server documentation
| Tool | Purpose | Parameters |
|---|---|---|
getContext |
Get database schema, table descriptions, join patterns, query examples | — |
execute_sql |
Execute read-only SQL queries against the trade database | query: SQL |
explain_query |
Get execution plan for a SQL query | query: SQL |
list_objects |
List available tables and views | schema |
get_object_details |
Get column definitions for a table | object_name |
Human Capital Analytics
Endpoint: https://mcp-hc.stat.gov.lv/mcp · Server documentation
| Tool | Purpose | 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 |
explain_query |
Get execution plan for a SQL query | query: SQL |
list_objects |
List available tables and views | schema |
get_object_details |
Get column definitions for a table | object_name |
Common Patterns
All three servers follow a consistent pattern:
- Call
getContextfirst — every server provides a context tool that returns the complete schema, workflow patterns, and example queries. AI assistants call this automatically on first use. - Query the data — PX-Web uses hierarchical navigation tools; Foreign Trade and Human Capital use SQL queries.
- No authentication — all servers are free and open. No API key required.