query_iceberg
Query an Iceberg data lake table using Postgres foreign data wrapper. Filter, order, and limit results with optional WHERE, ORDER BY, and LIMIT clauses.
Instructions
SELECT from an Iceberg foreign table via Postgres FDW (e.g. 'iceberg.aud_analytics_lake')
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>"
},
"name": "query_iceberg"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Full table name including schema (e.g. 'iceberg.aud_analytics_lake') | |
| where | No | Optional WHERE clause (uses parameterized query) | |
| order_by | No | Optional ORDER BY clause (column.direction format) | |
| limit | No |