Read a Notion database
query_notion_databaseRead and filter rows from a shared Notion database, including properties, links, and column types, to import calendars or locate records for updates.
Instructions
Read the ROWS of a Notion database the user shared with Hermoso — e.g. the team's content calendar: each row's title, id, link and every property as a plain value (status, date, channels, caption, links), plus the database's columns with their types and options. Filter with match {"Status": "Scheduled"} (typed from the database's own columns) or a raw Notion filter object; sort with sortBy (a column, or created_time / last_edited_time) and direction. Up to 100 rows per call, cursor for more; the answer says when Notion stopped at its 10,000-result limit. Use it to import a calendar and schedule its posts, or to find the row update_notion_row changes. Read-only, free. Needs Notion connected (Connectors > Notion).
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "query_notion_database"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | 1-100, default 50 | |
| match | No | {"Column": value} — equality for status/select/checkbox/number/date, contains for text/multi-select | |
| cursor | No | nextCursor from the previous page of rows | |
| filter | No | a raw Notion filter object | |
| sortBy | No | column name to sort by, or created_time or last_edited_time | |
| archived | No | read archived rows instead | |
| direction | No | ascending (default) or descending | |
| databaseId | No | database id or link (list_notion_pages type:"database") | |
| dataSourceId | No | data source id from an earlier read, as an alternative to databaseId |