databases
Define database schemas, query with filters and sorts, and perform bulk page create, update, and delete operations in Notion.
Instructions
Database schema, query, and bulk row operations.
Actions (required params -> optional):
create (parent_id -> title, properties, is_inline, icon, cover)
get (database_id)
query (database_id -> filters, sorts, limit, search)
create_page (database_id, pages[{properties}])
update_page (database_id, page_id, page_properties)
delete_page (database_id, page_ids)
create_data_source / update_data_source / update_database / list_templates
Use pages instead for single page CRUD. Accepts both database_id (from URL) and data_source_id (from workspace search) -- auto-resolved.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| icon | No | Icon (for update_database): emoji (e.g. "(icon)"), external URL (https://...), or built-in shorthand (name:color, e.g. "document:gray") | |
| cover | No | Cover image (for update_database): URL or built-in shorthand (gradient_1..11, solid_red/yellow/blue/beige, nasa_*, met_*, rijksmuseum_*, woodcuts_*) | |
| limit | No | Max query results | |
| pages | No | Array of pages for bulk create/update | |
| sorts | No | Query sorts | |
| title | No | Title (for database or data source) | |
| action | Yes | Action to perform | |
| search | No | Smart search across text fields (for query) | |
| filters | No | Query filters (for query action) | |
| page_id | No | Single page ID (for update_page) | |
| page_ids | No | Multiple page IDs (for delete_page) | |
| is_inline | No | Display as inline (for create/update_database) | |
| parent_id | No | Parent page ID (for create/update_database) | |
| properties | No | Schema properties (for create/update data source) | |
| database_id | No | Database ID (from Notion URL) or data_source_id (from workspace search). Auto-resolved for query/create_page/list_templates. | |
| description | No | Description | |
| data_source_id | No | Data source ID (for update_data_source action) | |
| page_properties | No | Page properties to update (for update_page) |