`psa_ph_search_tables`

Pack: psa-ph · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/psa_ph_search_tables for the schema, then POST the same URL with its arguments for the data.

Find Philippine Statistics Authority (PSA) statistical tables by keyword — consumer prices and inflation, labour force, population, poverty, GDP, trade, agriculture, tourism and the rest of the Philippine official statistics. Returns each table’s native id (e.g. “2M/PI/CPI/2018/0012M4ACP09.px”), title and last-updated date; pass that id unchanged to psa_ph_table_info and psa_ph_get_data. Index hits for tables the publisher has since removed are dropped and counted; results in a frozen old-series folder carry newer_series_folder. Pass folder to browse the tree. Philippines only.

Parameters

Name	Type	Required	Description
`query`	string	no	Keywords, e.g. “consumer price index”, “unemployment rate”, “palay production”.
`limit`	integer	no	Max tables to return (default 10, max 15).
`folder`	string	no	Browse instead of searching: a folder path such as “2M/PI/CPI/2018NEW” (empty string lists the theme folders). Ignores query.

Example call

Arguments

{
  "query": "consumer price index",
  "limit": 5
}

curl

curl -X POST https://gateway.pipeworx.io/psa-ph/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"psa_ph_search_tables","arguments":{"query":"consumer price index","limit":5}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('psa_ph_search_tables', {
  "query": "consumer price index",
  "limit": 5
});

Response shape

Field	Type	Description
`query`	string
`source`	string
`total_hits`	number
`tables`	array
`note`	string

Full JSON Schema

{
  "type": "object",
  "properties": {
    "query": {
      "type": "string"
    },
    "source": {
      "type": "string"
    },
    "total_hits": {
      "type": "number"
    },
    "tables": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "table_id": {
            "type": "string"
          },
          "title": {
            "type": "string"
          },
          "theme_code": {
            "type": "string"
          },
          "updated": {
            "type": "string"
          }
        },
        "additionalProperties": true
      }
    },
    "note": {
      "type": "string"
    }
  },
  "additionalProperties": true
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the psa-ph pack

{
  "mcpServers": {
    "psa-ph": {
      "url": "https://gateway.pipeworx.io/psa-ph/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

psa_ph_search_tables