Back to Details

notion-databases

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Notion Databases

Notion数据库

Query structured data, list databases, and add entries.
查询结构化数据、列出数据库并添加条目。

Prerequisites

前提条件

Run 
notion-connect --check
first. If not configured, load 
notion-connect/SKILL.md
.
首先运行
notion-connect --check
。如果未配置，请查看
notion-connect/SKILL.md
。

Commands

命令

List all databases

列出所有数据库

bash
python3 databases/scripts/notion_databases.py list
bash
python3 databases/scripts/notion_databases.py list

Query a database

查询数据库

bash
undefined
bash
undefined

All entries

所有条目

python3 databases/scripts/notion_databases.py query <database-id>
python3 databases/scripts/notion_databases.py query <database-id>

With filter

带筛选条件

python3 databases/scripts/notion_databases.py query <database-id> --filter '{"property": "Status", "select": {"equals": "In Progress"}}'
python3 databases/scripts/notion_databases.py query <database-id> --filter '{"property": "Status", "select": {"equals": "In Progress"}}'

With sort

带排序

python3 databases/scripts/notion_databases.py query <database-id> --sort '{"property": "Created", "direction": "descending"}'
python3 databases/scripts/notion_databases.py query <database-id> --sort '{"property": "Created", "direction": "descending"}'

Limit results

限制结果数量

python3 databases/scripts/notion_databases.py query <database-id> --limit 5
undefined
python3 databases/scripts/notion_databases.py query <database-id> --limit 5
undefined

Create a database entry

创建数据库条目

bash
python3 databases/scripts/notion_databases.py create <database-id> --props '{"Name": "New Task", "Status": "To Do", "Priority": "High"}'
bash
python3 databases/scripts/notion_databases.py create <database-id> --props '{"Name": "New Task", "Status": "To Do", "Priority": "High"}'

Get database schema (see what properties exist)

获取数据库架构（查看存在的属性）

bash
python3 databases/scripts/notion_databases.py schema <database-id>
bash
python3 databases/scripts/notion_databases.py schema <database-id>

Common Filters

常用筛选条件

json
// Select property
{"property": "Status", "select": {"equals": "Done"}}

// Checkbox
{"property": "Completed", "checkbox": {"equals": true}}

// Date (after)
{"property": "Due Date", "date": {"after": "2026-04-01"}}

// Text contains
{"property": "Name", "rich_text": {"contains": "meeting"}}
json
// 选择属性
{"property": "Status", "select": {"equals": "Done"}}

// 复选框
{"property": "Completed", "checkbox": {"equals": true}}

// 日期（之后）
{"property": "Due Date", "date": {"after": "2026-04-01"}}

// 文本包含
{"property": "Name", "rich_text": {"contains": "meeting"}}

Follow-Up Questions

后续问题示例

  • "List all my Notion databases"
  • "Query my tasks database for items due this week"
  • "Add a new entry to my projects database"
  • "Show the schema of my CRM database"
  • "列出我所有的Notion 数据库"
  • "查询我的任务数据库中本周到期的项目"
  • "添加一个新条目到我的项目数据库"
  • "显示我的CRM数据库的架构"