// The duckdb cli is installed on this system and is a good choice for ad-hoc data analysis from CSV, parquet or NDJSON files. Use it when the user asks for data values in the context of a specific data file or to join multiple files together.
Access Our World In Data's published datasets using the owid-catalog Python library. Provides a unified Python API for searching and fetching chart data, catalog tables, and indicators — returning enhanced pandas DataFrames with metadata. Use this as a Python-native alternative to the HTTP-based search-charts and fetch-chart-data skills.
This skill describes how to fetch data for an Our World In Data chart, once the relevant chart URL has been identified. Consult this skill to understand the possible query params to get the best results and to understand the response. Use it you need to fetch data and have already identified the relevant chart URL.
Our World In Data offers thousands of charts and related data on many important topics - from global population data, energy and electricity, economic data like GDP or poverty, health data like causes of death or prevalence of diseases, to data on democracy, violence and war. This skill describes how to effectively search for charts to either show visually or download the data for.
We always use `uv` for running python scripts (both standalone and complex python projects) and managing python dependencies. Always use this instead of running system `python`, `python3`, `pip` or `pip3`
Create interactive Our World In Data style charts using the owid-grapher-py Python library. Use this skill when the user wants to visualize data as charts (line charts, bar charts, scatter plots, maps, etc.) in a Jupyter notebook, standalone HTML, or export charts to PNG/SVG.
Access Our World In Data's internal datasette instance to query data from our main MySQL database mirror and analytics data store. Use this when you need to look up or explore data from our internal infrastructure. Does not contain any timeseries data i.e. this does not help to answer questions about data like "what is the life expectancy in Nigeria?". Instead, it is useful for questions like "how many published charts do we have?" or "get the title for all views for a multidim".
| name | duckdb |
| description | The duckdb cli is installed on this system and is a good choice for ad-hoc data analysis from CSV, parquet or NDJSON files. Use it when the user asks for data values in the context of a specific data file or to join multiple files together. |
| globs | ["*.csv","*.parquet"] |
| allowed-tools | ["Bash(duckdb:*)"] |
When using duckdb for querying single files, use the DESCRIBE SELECT and, optionally, SUMMARIZE SELECT statements to understand the structure beforehand.