estat-mcp

What This Skill Does

The estat-mcp skill is an official integration tool designed for OpenClaw to interact with the e-Stat (政府統計の総合窓口) API, which is the central portal for all Japanese government open data. By utilizing this skill, agents can search through over 3,000 statistical tables encompassing demographic, economic, and social data. The skill bridges the gap between complex raw government data and actionable insights, allowing for automated data retrieval of key indicators like population trends, GDP, Consumer Price Index (CPI), labor market status, and trade statistics. It processes complex table codes into manageable JSON outputs, which can be further analyzed by your AI agent.

Installation

To integrate this skill, use the following installation command in your terminal: clawhub install openclaw/skills/skills/ajtgjmdjp/estat-mcp

Ensure you have registered for a free API key at the official e-Stat website. Once obtained, export your key as an environment variable in your system: export ESTAT_APP_ID='your_api_key_here'. You may need to install the underlying Python package via pip install estat-mcp or uv tool install estat-mcp if it is not automatically managed by the OpenClaw environment.

Use Cases

• Demographic Analysis: Tracking population growth or decline by specific prefectures over several decades.
• Economic Reporting: Generating monthly reports on CPI (Consumer Price Index) to monitor inflation in Japan.
• Trade & Industry Research: Fetching specific import/export volumes by country and commodity for market entry studies.
• Labor Market Monitoring: Analyzing the Labor Force Survey to extract current unemployment rates and workforce participation demographics.
• Macroeconomic Forecasting: Pulling time-series data for GDP to compare against historical growth patterns.

Example Prompts

1. "Search for the latest population data for Tokyo and summarize the trend since 2020."
2. "Retrieve the CPI figures for the last 6 months using the estat-mcp tool and plot the general trend."
3. "Fetch the latest unemployment statistics from the Labor Force Survey and explain the current labor market situation in Japan."

Tips & Limitations

• API Rate Limits: The e-Stat API enforces a limit of 1 request per second. Excessive querying in short windows may result in rate-limiting errors.
• Code Knowledge: For advanced filtering, familiarize yourself with standard e-Stat table codes (e.g., area codes like 13000 for Tokyo). Use the search command first to find the relevant Table ID before attempting to data fetch.
• Data Accuracy: Always verify table IDs, as some datasets are updated at different frequencies (monthly vs. annually).