Update database
The Notion Update Database tool enables seamless modification of your Notion databases by allowing updates to properties, titles, descriptions, and other attributes. It outputs a detailed Markdown representation showing your updated database structure for easy reference.
Features
- Update database title and description effortlessly.
- Add, rename, or remove database properties including diverse types like select, multi-select, date, and formula.
- Toggle display mode between inline and full page for flexible viewing.
- Capability to move databases to trash with user confirmation to prevent accidental loss.
- Support for rich data types and complex schema updates including relations and rollups.
Benefits
- Streamlines management of Notion databases with easy updates to schema and metadata.
- Enhances productivity by reducing manual database configuration tasks.
- Provides clear feedback with rendered Markdown reflecting current database structure.
- Allows dynamic customization of database views and properties to fit evolving project needs.
- Ensures data integrity with controlled trash operations and comprehensive property support.
Description
Update a Notion database's properties, name, description, or other attributes. The tool returns a rendered Markdown string showing the updated database structure, including its properties, data sources, and schema information. Database properties define the columns/fields that pages in the database can have. Each property has a type (text, number, select, etc.) and configuration options. Examples: (1) Update database title and description: { "database_id": "f336d0bc-b841-465b-8045-024475c079dd", "title": [{"type": "text", "text": {"content": "Project Tracker 2024"}}], "description": [{"type": "text", "text": {"content": "Track all projects and deliverables"}}] } (2) Add new properties to a database: { "database_id": "f336d0bc-b841-465b-8045-024475c079dd", "properties": { "Priority": { "select": { "options": [ {"name": "High", "color": "red"}, {"name": "Medium", "color": "yellow"}, {"name": "Low", "color": "green"} ] } }, "Due Date": {"date": {}}, "Assigned To": {"people": {}} } } (3) Rename an existing property (use the property ID or current name): { "database_id": "f336d0bc-b841-465b-8045-024475c079dd", "properties": { "Status": {"name": "Project Status"} } } (4) Remove a property (set to null): { "database_id": "f336d0bc-b841-465b-8045-024475c079dd", "properties": { "Old Property": null } } (5) Change display mode from inline to full page: { "database_id": "f336d0bc-b841-465b-8045-024475c079dd", "is_inline": false } (6) Move database to trash (WARNING: cannot be undone without going to the Notion app UI so explicitly confirm with the user that they really want to do this): { "database_id": "f336d0bc-b841-465b-8045-024475c079dd", "in_trash": true } Common property types:
- title: The main property (required, cannot be deleted)
- rich_text: Multi-line text
- number: Numeric values with optional formatting
- select: Single choice from options
- multi_select: Multiple choices from options
- date: Date with optional time
- people: User references
- checkbox: Boolean values
- url: Web links
- email: Email addresses
- phone_number: Phone numbers
- formula: Calculated values based on other properties
- relation: Links to pages in another database
- rollup: Aggregated values from related pages Notes:
- You cannot delete or create new title properties
- A database can only have one unique_id property
- Synced databases cannot be updated
- Use the "fetch" tool first to see the current database schema
Parameters
6 parameters
| Name | Type | Description |
|---|---|---|
| database_idrequired | string | The ID of the database to update. This is a UUID v4, with or without dashes, and can be parsed from a database URL. |
| title | array | The new title of the database, as a rich text object, if you want to update it. |
| description | array | The new description of the database, as a rich text object, if you want to update it. |
| properties | object | Updates to make to the database's schema. Use null to remove a property, or provide the |
| is_inline | boolean | Whether the database should be displayed inline in the parent page, if you want to change this setting. |
| in_trash | boolean | Whether to move the database to the trash. WARNING: This operation currently cannot be undone without going to the Notion app UI. Make sure you want to do this before proceeding. |
