notion_query_database

Query and retrieve data from a Notion database with custom filters, sorting, and pagination. Choose response formats like JSON or Markdown for optimal readability or further processing.

Instructions

Query a database in Notion

Input Schema

Name	Required	Description	Default
`database_id`	Yes	The ID of the database to query.It should be a 32-character string (excluding hyphens) formatted as 8-4-4-4-12 with hyphens (-).
`filter`	No	Filter conditions
`format`	No	Specify the response format. 'json' returns the original data structure, 'markdown' returns a more readable format. Use 'markdown' when the user only needs to read the page and isn't planning to write or modify it. Use 'json' when the user needs to read the page with the intention of writing to or modifying it.	markdown
`page_size`	No	Number of results per page (max 100)
`sorts`	No	Sort conditions
`start_cursor`	No	Pagination cursor for next page of results

Input Schema (JSON Schema)

{
  "properties": {
    "database_id": {
      "description": "The ID of the database to query.It should be a 32-character string (excluding hyphens) formatted as 8-4-4-4-12 with hyphens (-).",
      "type": "string"
    },
    "filter": {
      "description": "Filter conditions",
      "type": "object"
    },
    "format": {
      "default": "markdown",
      "description": "Specify the response format. 'json' returns the original data structure, 'markdown' returns a more readable format. Use 'markdown' when the user only needs to read the page and isn't planning to write or modify it. Use 'json' when the user needs to read the page with the intention of writing to or modifying it.",
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "page_size": {
      "description": "Number of results per page (max 100)",
      "type": "number"
    },
    "sorts": {
      "description": "Sort conditions",
      "items": {
        "properties": {
          "direction": {
            "enum": [
              "ascending",
              "descending"
            ],
            "type": "string"
          },
          "property": {
            "type": "string"
          },
          "timestamp": {
            "type": "string"
          }
        },
        "required": [
          "direction"
        ],
        "type": "object"
      },
      "type": "array"
    },
    "start_cursor": {
      "description": "Pagination cursor for next page of results",
      "type": "string"
    }
  },
  "required": [
    "database_id"
  ],
  "type": "object"
}

Notion MCP Server

notion_query_database

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Notion MCP Server

Related Tools

MCP directory API