Prompt
Notion Database Schema Designer
Design the perfect Notion database schema for any use case. Outputs property types, formulas, views, and automation ideas.
notionpkmproductivitydatabasetools
Design a Notion database schema for the following use case:
Use Case: {{use_case}} (e.g., project tracker, CRM, content calendar, reading list, habit tracker) User Type: {{user_type}} (individual / small team / large team) Key Goals: {{goals}} (what decisions or workflows will this database support?) Integrations Needed: {{integrations}} (e.g., Zapier, Google Calendar, Slack — or none)
Output:
1. Database Name and Purpose Statement
2. Properties (for each property):
- Property name
- Property type (Text, Number, Select, Multi-select, Date, Relation, Rollup, Formula, etc.)
- Description and how it will be used
- For Formula properties: the formula logic explained in plain language
3. Recommended Views (Gallery / Table / Board / Calendar / Timeline):
- View name, type, and grouping/filter logic
4. Automation Ideas (button properties or Notion automations)
5. Template Setup — one template entry showing what a filled record looks like
6. Scaling Tips — what to add when this database grows
Variables
{{use_case}}stringrequiredWhat the database is for{{user_type}}stringWho will use it{{goals}}stringrequiredWhat it needs to support{{integrations}}stringExternal integrations needed