Notion Systems Claude Architects From Scratch
20 Claude prompts for database schemas, formulas, workspace architecture, workflow design, and the structured thinking Notion power users need.
In short: This page contains 20 copy-paste ready prompts, organized into 4 categories with a description and pro tip for each. The first 5 prompts are free instantly, no signup needed. Hand-curated and tested by the AI Academy team.
Architecture
5 promptsWorkspace Architect
1/20✨ What it does
Designs Notion workspaces with page hierarchy, database relations, and usage rituals.
<task>Design my Notion workspace</task> <role>[describe]</role> <needs>[areas to manage]</needs> <team>[solo / team size]</team> <output> 1. Page hierarchy (5-7 hubs max) 2. Database vs page per area 3. Relation structure 4. What NOT to put in Notion 5. Daily + weekly usage ritual </output>
Pro tip: Most Notion workspaces die from too many databases. Start with 3-5 (Tasks, Projects, Notes) and expand only when real pain forces it. Over-architecting kills adoption.
Database Schema
2/20✨ What it does
Designs Notion database schemas with properties, relations, rollups, and purposeful views.
<task>Design database schema for [tracking need]</task> <entities>[list]</entities> <output> 1. Properties with types 2. Relation + rollup to avoid redundancy 3. Views per use case 4. Filters and sorts 5. What NOT to track </output>
Pro tip: 5-8 properties per database is the sweet spot. More and you've probably needed a second database with a relation, not more columns.
Second Brain / PKM
3/20✨ What it does
Builds PKM systems in Notion with capture workflow, organization, and retrieval.
<task>Build second brain in Notion</task> <capture_habits>[describe]</capture_habits> <output_needs>[writing / teaching / decisions]</output_needs> <output> 1. Notes database schema 2. PARA or similar organization 3. Quick capture workflow 4. Weekly review ritual 5. Retrieval surfacing </output>
Pro tip: Design retrieval first, capture second. "How will I find this in 6 months?" matters more than "how do I capture fast?" Notes without retrieval are cemeteries.
Project Management Template
4/20✨ What it does
Builds Notion PM templates with related databases, views, and automation.
<task>Build PM template in Notion</task> <project_type>[describe]</project_type> <team_size>[number]</team_size> <output> 1. Projects DB with properties 2. Tasks DB related 3. Role-specific views 4. Automation opportunities 5. Archive strategy </output>
Pro tip: Notion's relation property is what makes it real PM. Flat task lists without relations are prettier sticky notes. Relations unlock the system.
CRM Lightweight
5/20✨ What it does
Builds Notion CRMs with contact management, pipelines, and graduation plan.
<task>Build lightweight CRM in Notion</task> <business>[describe]</business> <output> 1. Contacts DB + stages 2. Interactions DB related 3. Kanban by stage 4. Calendar view for next steps 5. When to graduate to real CRM </output>
Pro tip: Notion CRMs work up to ~100 active contacts. Past that, real CRMs win. Don't force Notion to be Salesforce — use it for the 80% solopreneur case.
Formulas & Automation
5 promptsFormula Builder (2.0)
6/20✨ What it does
Writes Notion 2.0 formulas with if/let/switch syntax and edge case handling.
<task>Write Notion formula for [need]</task> <properties>[list with types]</properties> <output> 1. Formula in 2.0 syntax (if/let/switch) 2. Each part explained 3. Edge cases (empty, divide-by-zero) 4. Display formatting </output>
Pro tip: Notion Formula 2.0 is a massive upgrade — let/if/switch cleanly. If you're still using nested prop() 1.0 formulas, upgrade. Cleaner, faster, easier to debug.
Rollup Master
7/20✨ What it does
Configures Notion rollups with filtering, performance, and dashboard display.
<task>Configure rollup for [scenario]</task> <output> 1. Rollup setup 2. When rollup vs formula-that-does-it 3. Filtered rollup (e.g., active tasks only) 4. Performance on big DBs 5. Dashboard display </output>
Pro tip: Rollups are Notion's most underused feature. "How many open tasks per project?" updates automatically. Most "I need a spreadsheet" moments actually need rollups.
Status Automation
8/20✨ What it does
Automates status with formulas, buttons, Notion Automations, or external tools.
<task>Automate status changes</task> <current_process>[describe]</current_process> <rules>[describe]</rules> <output> 1. Formula-based automation where possible 2. Button automations 3. Notion Automations if paid 4. External tools (Make/Zapier) for complex </output>
Pro tip: Automation only pays when process is truly repetitive. Changing status once a day = don't automate. 20 times a day = absolutely. Count first.
Dashboard with Rollups
9/20✨ What it does
Builds Notion dashboards aggregating across databases with filter controls.
<task>Build cross-database dashboard</task> <databases>[list]</databases> <kpis>[describe]</kpis> <output> 1. KPI formulas/rollups 2. Single-page layout 3. Filter controls 4. Visual hierarchy 5. Refresh cadence </output>
Pro tip: Dashboards with 20+ linked databases load slowly. Show only 5-7 KPIs that matter. Everything else belongs one click away.
Template Gallery for Teams
10/20✨ What it does
Builds team template galleries with governance, featured rotation, and onboarding.
<task>Build team template gallery</task> <team_templates>[list]</team_templates> <output> 1. Categorized hub page 2. Usage instructions per template 3. Governance 4. Featured rotation 5. Onboarding guide </output>
Pro tip: Template galleries die without shepherds. Assign one owner, review quarterly, retire unused. Without ownership: 50 templates nobody uses.
Workflows
5 promptsDaily Dashboard
11/20✨ What it does
Designs daily command center dashboards with morning and evening rituals.
<task>Design daily dashboard</task> <priorities>[describe]</priorities> <output> 1. Page layout (Today, This Week, Waiting, Capture) 2. Linked views filtered to today 3. Morning intentions 4. Quick capture buttons 5. End-of-day review </output>
Pro tip: Daily page is the front door. If finding what you need takes >10 seconds, system isn't working. Test: can I start my day in under 5 min?
Weekly Review Template
12/20✨ What it does
Builds weekly review templates with auto-stats, patterns, and celebration.
<task>Build weekly review template</task> <areas>[work / health / etc.]</areas> <output> 1. Review questions per area 2. Auto-populated stats from other DBs 3. Pattern notes 4. Next week top 3 priorities 5. Wins celebration </output>
Pro tip: Weekly reviews are where productivity systems earn their keep. 20 minutes every Friday beats any app or template. Without review, capture creates clutter.
Meeting Notes Template
13/20✨ What it does
Builds meeting notes templates with linked action items and scratchpad variant.
<task>Build meeting notes template</task> <meeting_types>[describe]</meeting_types> <output> 1. Meetings DB 2. Template with agenda/notes/decisions/action items 3. Action items linked to Tasks DB 4. Follow-up reminders 5. Scratchpad variant </output>
Pro tip: Meeting notes die when action items don't escape the notes page. Always link to your Tasks DB — otherwise decisions decompose into noise.
Content Calendar
14/20✨ What it does
Builds Notion content calendars with pipelines, performance tracking, and task linkage.
<task>Build content calendar in Notion</task> <content_types>[describe]</content_types> <output> 1. Content DB with properties 2. Calendar/Kanban/Timeline views 3. Idea backlog → scheduled pipeline 4. Post-publish performance tracking 5. Linked to Tasks DB </output>
Pro tip: Content calendars work when connected to work needed. Without linked tasks, deadlines slip. With them, deadlines stay real.
Goals / OKRs Tracker
15/20✨ What it does
Sets up goals/OKRs tracking with parent-child structure and weekly check-ins.
<task>Set up goals / OKRs in Notion</task> <horizon>[annual / quarterly]</horizon> <output> 1. Goals DB with parent-child structure 2. Key results as children 3. Weekly check-in updating progress % 4. Dashboard per season 5. Retrospective template </output>
Pro tip: OKRs fail when reviewed quarterly. Notion makes weekly check-ins trivial — 10 min per week is the entire secret to OKRs actually working.
These prompts give you the what. Tutorials give you the why.
Learn when to use extended thinking, how to build Claude Projects, and workflows that compound. 300+ tutorials and growing.
Advanced
5 promptsNotion AI Workflow Design
16/20✨ What it does
Designs Notion AI integration with pain-specific usage and guardrails.
<task>Design Notion AI usage</task> <pain_points>[describe]</pain_points> <output> 1. Specific Notion AI commands per pain 2. What stays manual (AI slop worse than human) 3. AI blocks in templates 4. Notion AI vs Claude vs ChatGPT for different tasks 5. Guardrails </output>
Pro tip: Notion AI is best for context-aware work (summarizing, rewriting). For strategic/creative work, Claude and ChatGPT still win. Pick tools by strength.
Public Notion Site
17/20✨ What it does
Publishes Notion to public sites with SEO, custom domains, and migration guidance.
<task>Publish Notion page as public site</task> <purpose>[describe]</purpose> <output> 1. Native Notion Sites vs third-party (Super/Potion/Feather) 2. SEO considerations 3. Custom domain 4. Design limitations 5. When to migrate off Notion </output>
Pro tip: Notion Sites (official) is now good for simple sites. For heavy customization or high-traffic, migrate to a real CMS — Notion's SEO ceiling is real.
Notion + Calendar Sync
18/20✨ What it does
Syncs Notion with calendars including Notion Calendar app and automation tools.
<task>Sync Notion with calendar</task> <calendar>[Google / Outlook / Apple]</calendar> <output> 1. Native integration options 2. Notion Calendar app setup 3. Zapier/Make for complex sync 4. Source-of-truth management </output>
Pro tip: Notion Calendar (standalone app) blends tasks + events. Best Notion feature you're not using. Schedule tasks directly alongside meetings.
Migration Plan (To/From)
19/20✨ What it does
Plans Notion migrations with phased approach, preservation analysis, and rollback.
<task>Migrate [from / to] Notion</task> <source>[describe]</source> <volume>[describe]</volume> <output> 1. Export format 2. Import approach 3. What preserves vs loses 4. Phased migration plan 5. Rollback plan </output>
Pro tip: Never migrate everything at once. Pick one use case, migrate, use 2 weeks, then migrate next. Big-bang migrations fail because you don't know what to keep.
Habit Tracker Template
20/20✨ What it does
Builds habit trackers with streak formulas, consistency review, and home-page widget.
<task>Build habit tracker</task> <habits>[list]</habits> <frequency>[daily / weekly]</frequency> <output> 1. DB schema with checkboxes 2. Streak formulas (current + longest) 3. Weekly review showing consistency 4. Progress bars 5. Home page widget </output>
Pro tip: Habit trackers fail when daily logging takes >60 seconds. Make it one click. If you can't log during a toothbrush session, the system dies within 3 weeks.
Free tool
Prompt Optimizer
Turn a rough idea into a structured, professional AI prompt.
Frequently Asked Questions
Prompts are the starting line. Tutorials are the finish.
A growing library of 300+ hands-on tutorials on ChatGPT, Claude, Midjourney, and 50+ AI tools. New tutorials added every week.
7-day free trial. Cancel anytime.
Related guides