Latvia Foreign Trade Statistics MCP Server
Query Latvian import and export data through AI assistants. Annual and monthly trade by partner country, HS/CN commodity code, with values in euros and weight in kilograms.
Quick Connect
Add to your AI client — no API key required:
{
"mcpServers": {
"latvia-foreign-trade": {
"url": "https://mcp-ft.stat.gov.lv/mcp"
}
}
}Streamable HTTP Free No auth
Available Tools
| Tool | Purpose |
|---|---|
getContext | Get database schema, table descriptions, join patterns, query examples |
execute_sql | Execute read-only SQL queries against the trade database |
explain_query | Get execution plan for a SQL query |
list_objects | List available tables and views |
get_object_details | Get column definitions for a table |
Database Tables
| Table | Description |
|---|---|
ft.impexp_data | Annual import/export data: country, HS code, flow, value (EUR), weight (kg) |
ft.impexp_data_m | Monthly import/export data with same structure |
ft.countries | Country reference: ISO codes, names in English and Latvian |
ft.hs_classification | Hierarchical HS/CN product classification (2–8 digit codes) |
ft.business_glossary | Trade terminology dictionary |
Example Questions
- What are Latvia’s top 10 export destinations?
- Show monthly imports of machinery from Germany in 2024
- Calculate the trade balance with EU countries
- Which HS chapters had the highest export growth?
- Compare food imports from Lithuania vs Estonia
- What are the main commodities Latvia exports to the US?
- Show seasonal patterns in agricultural exports
- Which product categories have the largest trade deficit?
Data Source
Published by the Central Statistical Bureau of Latvia (Centrālā statistikas pārvalde). Data is free under CC BY 4.0.