Notion
notion-create-database
Creates a new Notion database with the specified properties schema. If no title property provided, "Name" is auto-added. Returns Markdown with schema, SQLite definition, and data source ID in <data-source> tag for use with update_data_source and query_data_sources tools. Property types: title (required), rich_text, number, select, multi_select, date, people, checkbox, url, email, phone_number, formula, relation, rollup. <example description="Minimal">{"properties": {}}</example> <example description="Task DB">{"parent": {"page_id": "f336d0bc-b841-465b-8045-024475c079dd"}, "title": [{"text": {"content": "Tasks"}}], "properties": {"Status": {"type": "select", "select": {"options": [{"name": "To Do", "color": "red"}, {"name": "Done", "color": "green"}]}}, "Due Date": {"type": "date", "date": {}}}}</example>
Remote notion
Other tools also called notion-create-database?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"title": {
"type": "array",
"items": {
"allOf": [
{
"type": "object",
"properties": {
"annotations": {
"type": "object",
"properties": {
"bold": {
"type": "boolean"
},
"code": {
"type": "boolean"
},
"color": {
"type": "string"
},
"italic": {
"type": "boolean"
},
"underline": {
"type": "boolean"
},
"strikethrough": {
"type": "boolean"
}
},
"description": "All rich text objects contain an annotations object that sets the styling for the rich text.",
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"anyOf": [
{
"type": "object",
"required": [
"text"
],
"properties": {
"text": {
"type": "object",
"required": [
"content"
],
"properties": {
"link": {
"anyOf": [
{
"type": "object",
"required": [
"url"
],
"properties": {
"url": {
"type": "string",
"description": "The URL of the link."
}
},
"additionalProperties": true
},
{
"type": "null"
}
],
"description": "An object with information about any inline link in this text, if included."
},
"content": {
"type": "string",
"maxLength": 2000,
"description": "The actual text content of the text."
}
},
"description": "If a rich text object's type value is `text`, then the corresponding text field contains an object including the text content and any inline link.",
"additionalProperties": false
},
"type": {
"enum": [
"text"
],
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"mention"
],
"properties": {
"type": {
"enum": [
"mention"
],
"type": "string"
},
"mention": {
"anyOf": [
{
"type": "object",
"required": [
"user"
],
"properties": {
"type": {
"enum": [
"user"
],
"type": "string"
},
"user": {
"type": "object",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "The ID of the user."
},
"object": {
"enum": [
"user"
],
"type": "string"
}
},
"description": "Details of the user mention.",
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"date"
],
"properties": {
"date": {
"type": "object",
"required": [
"start"
],
"properties": {
"end": {
"anyOf": [
{
"type": "string",
"format": "date"
},
{
"type": "null"
}
],
"description": "The end date of the date object, if any."
},
"start": {
"type": "string",
"format": "date",
"description": "The start date of the date object."
},
"time_zone": {
"type": [
"string",
"null"
],
"description": "The time zone of the date object, if any. E.g. America/Los_Angeles, Europe/London, etc."
}
},
"description": "Details of the date mention.",
"additionalProperties": false
},
"type": {
"enum": [
"date"
],
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"page"
],
"properties": {
"page": {
"type": "object",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "The ID of the page in the mention."
}
},
"description": "Details of the page mention.",
"additionalProperties": true
},
"type": {
"enum": [
"page"
],
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"database"
],
"properties": {
"type": {
"enum": [
"database"
],
"type": "string"
},
"database": {
"type": "object",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "The ID of the database in the mention."
}
},
"description": "Details of the database mention.",
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"template_mention"
],
"properties": {
"type": {
"enum": [
"template_mention"
],
"type": "string"
},
"template_mention": {
"anyOf": [
{
"type": "object",
"required": [
"template_mention_date"
],
"properties": {
"type": {
"enum": [
"template_mention_date"
],
"type": "string"
},
"template_mention_date": {
"enum": [
"today",
"now"
],
"type": "string"
}
},
"additionalProperties": false
},
{
"type": "object",
"required": [
"template_mention_user"
],
"properties": {
"type": {
"enum": [
"template_mention_user"
],
"type": "string"
},
"template_mention_user": {
"enum": [
"me"
],
"type": "string"
}
},
"additionalProperties": false
}
],
"description": "Details of the template mention."
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"custom_emoji"
],
"properties": {
"type": {
"enum": [
"custom_emoji"
],
"type": "string"
},
"custom_emoji": {
"type": "object",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "The ID of the custom emoji."
},
"url": {
"type": "string",
"description": "The URL of the custom emoji."
},
"name": {
"type": "string",
"description": "The name of the custom emoji."
}
},
"description": "Details of the custom emoji mention.",
"additionalProperties": true
}
},
"additionalProperties": true
}
],
"description": "Mention objects represent an inline mention of a database, date, link preview mention, page, template mention, or user. A mention is created in the Notion UI when a user types `@` followed by the name of the reference."
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"equation"
],
"properties": {
"type": {
"enum": [
"equation"
],
"type": "string"
},
"equation": {
"type": "object",
"required": [
"expression"
],
"properties": {
"expression": {
"type": "string",
"description": "A KaTeX compatible string."
}
},
"description": "Notion supports inline LaTeX equations as rich text objects with a type value of `equation`.",
"additionalProperties": true
}
},
"additionalProperties": true
}
]
}
]
},
"maxItems": 100,
"description": "The title of the new database, as a rich text object."
},
"parent": {
"type": "object",
"required": [
"page_id"
],
"properties": {
"type": {
"enum": [
"page_id"
],
"type": "string"
},
"page_id": {
"type": "string",
"description": "The ID of the parent page (with or without dashes), for example, 195de9221179449fab8075a27c979105"
}
},
"description": "The parent under which to create the new database. If omitted, the database will be created as a private page at the workspace level.",
"additionalProperties": true
},
"properties": {
"type": "object",
"description": "The property schema of the new database. If no title property is provided, one will be automatically added.",
"additionalProperties": {
"allOf": [
{
"type": "object",
"properties": {
"description": {
"anyOf": [
{
"type": "string",
"maxLength": 280,
"minLength": 1
},
{
"type": "null"
}
],
"description": "The description of the property."
}
},
"additionalProperties": true
},
{
"anyOf": [
{
"type": "object",
"required": [
"number"
],
"properties": {
"type": {
"enum": [
"number"
],
"type": "string"
},
"number": {
"type": "object",
"properties": {
"format": {
"type": "string"
}
},
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"formula"
],
"properties": {
"type": {
"enum": [
"formula"
],
"type": "string"
},
"formula": {
"type": "object",
"properties": {
"expression": {
"type": "string"
}
},
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"select"
],
"properties": {
"type": {
"enum": [
"select"
],
"type": "string"
},
"select": {
"type": "object",
"properties": {
"options": {
"type": "array",
"items": {
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string"
},
"color": {
"enum": [
"default",
"gray",
"brown",
"orange",
"yellow",
"green",
"blue",
"purple",
"pink",
"red"
],
"type": "string"
},
"description": {
"type": [
"string",
"null"
]
}
},
"additionalProperties": true
},
"maxItems": 100
}
},
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"multi_select"
],
"properties": {
"type": {
"enum": [
"multi_select"
],
"type": "string"
},
"multi_select": {
"type": "object",
"properties": {
"options": {
"type": "array",
"items": {
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string"
},
"color": {
"enum": [
"default",
"gray",
"brown",
"orange",
"yellow",
"green",
"blue",
"purple",
"pink",
"red"
],
"type": "string"
},
"description": {
"type": [
"string",
"null"
]
}
},
"additionalProperties": true
},
"maxItems": 100
}
},
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"status"
],
"properties": {
"type": {
"enum": [
"status"
],
"type": "string"
},
"status": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"relation"
],
"properties": {
"type": {
"enum": [
"relation"
],
"type": "string"
},
"relation": {
"allOf": [
{
"type": "object",
"required": [
"data_source_id"
],
"properties": {
"data_source_id": {
"type": "string"
}
},
"additionalProperties": true
},
{
"anyOf": [
{
"type": "object",
"required": [
"single_property"
],
"properties": {
"type": {
"enum": [
"single_property"
],
"type": "string"
},
"single_property": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"dual_property"
],
"properties": {
"type": {
"enum": [
"dual_property"
],
"type": "string"
},
"dual_property": {
"type": "object",
"properties": {
"synced_property_id": {
"type": "string"
},
"synced_property_name": {
"type": "string"
}
},
"additionalProperties": true
}
},
"additionalProperties": true
}
]
}
]
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"rollup"
],
"properties": {
"type": {
"enum": [
"rollup"
],
"type": "string"
},
"rollup": {
"allOf": [
{
"type": "object",
"required": [
"function"
],
"properties": {
"function": {
"type": "string"
}
},
"additionalProperties": true
},
{
"anyOf": [
{
"type": "object",
"required": [
"relation_property_name",
"rollup_property_name"
],
"properties": {
"rollup_property_name": {
"type": "string"
},
"relation_property_name": {
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"relation_property_id",
"rollup_property_name"
],
"properties": {
"relation_property_id": {
"type": "string"
},
"rollup_property_name": {
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"relation_property_name",
"rollup_property_id"
],
"properties": {
"rollup_property_id": {
"type": "string"
},
"relation_property_name": {
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"relation_property_id",
"rollup_property_id"
],
"properties": {
"rollup_property_id": {
"type": "string"
},
"relation_property_id": {
"type": "string"
}
},
"additionalProperties": true
}
]
}
]
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"unique_id"
],
"properties": {
"type": {
"enum": [
"unique_id"
],
"type": "string"
},
"unique_id": {
"type": "object",
"properties": {
"prefix": {
"type": [
"string",
"null"
]
}
},
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"title"
],
"properties": {
"type": {
"enum": [
"title"
],
"type": "string"
},
"title": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"rich_text"
],
"properties": {
"type": {
"enum": [
"rich_text"
],
"type": "string"
},
"rich_text": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"url"
],
"properties": {
"url": {
"type": "object",
"properties": {},
"additionalProperties": false
},
"type": {
"enum": [
"url"
],
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"people"
],
"properties": {
"type": {
"enum": [
"people"
],
"type": "string"
},
"people": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"files"
],
"properties": {
"type": {
"enum": [
"files"
],
"type": "string"
},
"files": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"email"
],
"properties": {
"type": {
"enum": [
"email"
],
"type": "string"
},
"email": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"phone_number"
],
"properties": {
"type": {
"enum": [
"phone_number"
],
"type": "string"
},
"phone_number": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"date"
],
"properties": {
"date": {
"type": "object",
"properties": {},
"additionalProperties": false
},
"type": {
"enum": [
"date"
],
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"checkbox"
],
"properties": {
"type": {
"enum": [
"checkbox"
],
"type": "string"
},
"checkbox": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"created_by"
],
"properties": {
"type": {
"enum": [
"created_by"
],
"type": "string"
},
"created_by": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"created_time"
],
"properties": {
"type": {
"enum": [
"created_time"
],
"type": "string"
},
"created_time": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"last_edited_by"
],
"properties": {
"type": {
"enum": [
"last_edited_by"
],
"type": "string"
},
"last_edited_by": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"last_edited_time"
],
"properties": {
"type": {
"enum": [
"last_edited_time"
],
"type": "string"
},
"last_edited_time": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"button"
],
"properties": {
"type": {
"enum": [
"button"
],
"type": "string"
},
"button": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"location"
],
"properties": {
"type": {
"enum": [
"location"
],
"type": "string"
},
"location": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"verification"
],
"properties": {
"type": {
"enum": [
"verification"
],
"type": "string"
},
"verification": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"last_visited_time"
],
"properties": {
"type": {
"enum": [
"last_visited_time"
],
"type": "string"
},
"last_visited_time": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"place"
],
"properties": {
"type": {
"enum": [
"place"
],
"type": "string"
},
"place": {
"type": "object",
"properties": {},
"additionalProperties": false
}
},
"additionalProperties": true
}
]
}
]
}
},
"description": {
"type": "array",
"items": {
"allOf": [
{
"type": "object",
"properties": {
"annotations": {
"type": "object",
"properties": {
"bold": {
"type": "boolean"
},
"code": {
"type": "boolean"
},
"color": {
"type": "string"
},
"italic": {
"type": "boolean"
},
"underline": {
"type": "boolean"
},
"strikethrough": {
"type": "boolean"
}
},
"description": "All rich text objects contain an annotations object that sets the styling for the rich text.",
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"anyOf": [
{
"type": "object",
"required": [
"text"
],
"properties": {
"text": {
"type": "object",
"required": [
"content"
],
"properties": {
"link": {
"anyOf": [
{
"type": "object",
"required": [
"url"
],
"properties": {
"url": {
"type": "string",
"description": "The URL of the link."
}
},
"additionalProperties": true
},
{
"type": "null"
}
],
"description": "An object with information about any inline link in this text, if included."
},
"content": {
"type": "string",
"maxLength": 2000,
"description": "The actual text content of the text."
}
},
"description": "If a rich text object's type value is `text`, then the corresponding text field contains an object including the text content and any inline link.",
"additionalProperties": false
},
"type": {
"enum": [
"text"
],
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"mention"
],
"properties": {
"type": {
"enum": [
"mention"
],
"type": "string"
},
"mention": {
"anyOf": [
{
"type": "object",
"required": [
"user"
],
"properties": {
"type": {
"enum": [
"user"
],
"type": "string"
},
"user": {
"type": "object",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "The ID of the user."
},
"object": {
"enum": [
"user"
],
"type": "string"
}
},
"description": "Details of the user mention.",
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"date"
],
"properties": {
"date": {
"type": "object",
"required": [
"start"
],
"properties": {
"end": {
"anyOf": [
{
"type": "string",
"format": "date"
},
{
"type": "null"
}
],
"description": "The end date of the date object, if any."
},
"start": {
"type": "string",
"format": "date",
"description": "The start date of the date object."
},
"time_zone": {
"type": [
"string",
"null"
],
"description": "The time zone of the date object, if any. E.g. America/Los_Angeles, Europe/London, etc."
}
},
"description": "Details of the date mention.",
"additionalProperties": false
},
"type": {
"enum": [
"date"
],
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"page"
],
"properties": {
"page": {
"type": "object",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "The ID of the page in the mention."
}
},
"description": "Details of the page mention.",
"additionalProperties": true
},
"type": {
"enum": [
"page"
],
"type": "string"
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"database"
],
"properties": {
"type": {
"enum": [
"database"
],
"type": "string"
},
"database": {
"type": "object",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "The ID of the database in the mention."
}
},
"description": "Details of the database mention.",
"additionalProperties": true
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"template_mention"
],
"properties": {
"type": {
"enum": [
"template_mention"
],
"type": "string"
},
"template_mention": {
"anyOf": [
{
"type": "object",
"required": [
"template_mention_date"
],
"properties": {
"type": {
"enum": [
"template_mention_date"
],
"type": "string"
},
"template_mention_date": {
"enum": [
"today",
"now"
],
"type": "string"
}
},
"additionalProperties": false
},
{
"type": "object",
"required": [
"template_mention_user"
],
"properties": {
"type": {
"enum": [
"template_mention_user"
],
"type": "string"
},
"template_mention_user": {
"enum": [
"me"
],
"type": "string"
}
},
"additionalProperties": false
}
],
"description": "Details of the template mention."
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"custom_emoji"
],
"properties": {
"type": {
"enum": [
"custom_emoji"
],
"type": "string"
},
"custom_emoji": {
"type": "object",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "The ID of the custom emoji."
},
"url": {
"type": "string",
"description": "The URL of the custom emoji."
},
"name": {
"type": "string",
"description": "The name of the custom emoji."
}
},
"description": "Details of the custom emoji mention.",
"additionalProperties": true
}
},
"additionalProperties": true
}
],
"description": "Mention objects represent an inline mention of a database, date, link preview mention, page, template mention, or user. A mention is created in the Notion UI when a user types `@` followed by the name of the reference."
}
},
"additionalProperties": true
},
{
"type": "object",
"required": [
"equation"
],
"properties": {
"type": {
"enum": [
"equation"
],
"type": "string"
},
"equation": {
"type": "object",
"required": [
"expression"
],
"properties": {
"expression": {
"type": "string",
"description": "A KaTeX compatible string."
}
},
"description": "Notion supports inline LaTeX equations as rich text objects with a type value of `equation`.",
"additionalProperties": true
}
},
"additionalProperties": true
}
]
}
]
},
"maxItems": 100,
"description": "The description of the new database, as a rich text object."
}
}
}