Idescat MCP: official Catalan statistics in your AI app

Connect Idescat to Claude, ChatGPT or Cursor

1. 1Click Connect Idescat free. There's no sign-in, so its tools are ready at once.
2. 2Idescat's seven tools query statistics, and all start on. If your AI app should show finished tables rather than raw JSON-stat, keep `render_table` and switch off `get_table_data`.
3. 3Add ContextGate to your AI app as a connector or MCP server. The steps for each app are on the Works with page.
4. 4Ask your AI app for an Idescat table on a topic you're researching and what its metadata says, then look the query up in Activity.

Working with Catalan statistics

• Find a statistic by its acronym, such as EPA or PIBC, and list its tables with `get_idescat_stat_tables`.
• Read a table's metadata with `get_table_metadata` to understand what it measures.
• Pull data in JSON-stat format for Catalonia, its counties or its municipalities, for analysis in Cursor or a notebook.
• Get a ready-to-read Markdown table with `render_table`.

Queries on record

• Tools you switch off are hidden from Claude, ChatGPT and Cursor alike.
• Activity records every Idescat query.

What you get with Idescat and ContextGate

• Your AI apps can use IdescatClaude, Cursor, ChatGPT and other AI apps reach Idescat through the one ContextGate connection you add to them.
• You choose which tools they can useSwitch off any Idescat tool you don't want used. It's hidden from your AI apps and refused if called.
• Every call is checked and recordedYour policies check each call (for example, personal data is hidden and secrets are blocked), and Activity keeps a record of it.

ContextGate sees only the tool calls that go through it, not your AI app's built-in tools or your chats.

Idescat tools

Examples of what your AI apps can do in Idescat. You'll see the exact list of tools after you connect it.

• get_idescat_statsObtains the complete list of Idescat statistics (all, normalized and non-normalized). It has no parameters. The response contains a 'statistics' array where each element has: 'acronym' (lowercase acronym, e.g., 'censph', to be used as the 'stat' argument of the other tools), 'name' (title), 'description' (summary), 'datasets' (boolean), 'geo' (array of available territorial disaggregations), and '
• get_idescat_statObtains information about an Idescat (Statistical Institute of Catalonia) statistic given its acronym. Use it when the user asks about a specific statistic identified by its acronym (for example, CENSPH, EPA, PIBC, AFI, etc.). The 'datasets' field is a key boolean: if true, the statistic is normalized and therefore available in get_idescat_stat_tables and the rest of the table-level tools (metadat
• get_idescat_stat_tablesObtains the list of tables for an Idescat statistic given its official acronym. Use it when the user asks what tables or information a statistic has. The response contains a 'tables' array where each element has 'id' (numerical identifier) and 'name' (table title). Present each table as: name (id). Inform the user that they can request more details about a table by indicating its identifier.
• get_table_metadataObtains the metadata for a specific Idescat table in JSON-stat format, given the statistic acronym (stat) and the table identifier (table). Use it when the user wants to know the details of a table: dimensions, categories available for each dimension (time periods, territorial scopes, sex, etc.), date of last update, units, etc. The acronym and identifier are previously obtained with get_idescat_s
• get_table_dataRetrieves the data (values) of an Idescat table in JSON-stat format for a territorial division. You can retrieve the ENTIRE table (without filters) or only a SUBSET by passing the OPTIONAL parameters 'filters' (specific categories per dimension) and/or 'last' (number of last time periods); filtering returns smaller responses and allows querying tables that as a whole would exceed the limit. The fi
• get_table_geoObtains the list of territorial divisions available for an Idescat table (for example: cat=Catalonia, com=counties and Aran, mun=municipalities, prov=provinces, at=territorial plan areas). The response contains a 'divisions' array where each element has 'id' (division code) and 'name' (label). Often it is NOT necessary to call it because get_table_metadata already returns these divisions in 'link.
• render_tableReturns a Markdown table already built with the filtered data from an Idescat table, ready to be shown to the user without having to interpret the JSON-stat. It includes the title, units, the table with category labels, status notes (e.g., provisional data), and ALWAYS a final link to the table on the Idescat website that must be kept in the response to the user. By default, it puts the time dimen