Blog›Product Updates

Taskade Product Updates — Projects as Databases: Structured Data for Automation & AI Agents

Projects as Databases: Structured Data for Automation & AI Agents

December 20, 2025·10 min read·John Xie·Updates
#genesis#updates

Hey there 👋

Projects aren't just documents. They're databases.

Use Projects as structured databases with custom fields, table views, and automation workflows. Then connect them as knowledge bases for AI agents.

Tables. Custom Fields. Automation. AI Knowledge. Everything in one system.

🗄️ Projects as Structured Databases

Perfect for: Operators, builders, businesses needing structured data

What Projects Can Be:

  • Databases — Structured data with custom fields
  • Tables — Spreadsheet-like views with rows and columns
  • Knowledge Bases — Structured information for AI agents
  • Automation Sources — Data sources for workflow triggers and actions

Project Database Features:

  • Custom Fields — String, number, datetime, select, password fields
  • Table View — Spreadsheet-like interface for structured data
  • Unique Constraints — Ensure data uniqueness
  • Real-Time Updates — Changes sync instantly
  • Multiple Views — Table, board, list, calendar, gantt views

🌟 Example: Create "Customers" project → Add custom fields (Name, Email, Status, Value) → Switch to Table view → See database-like interface → Use in automation → Connect to AI agent.

👉 How to use: Create project → Add custom fields → Switch to Table view → Use as database

📊 Custom Fields: Structure Your Data

Define custom fields to structure your project data like a database.

Field Types:

  • String — Text fields for names, descriptions, notes
  • Number — Numeric fields with decimal, currency, or percent formats
  • DateTime — Date and time fields for scheduling
  • Select — Dropdown fields with predefined options
  • Password — Secure fields for credentials and sensitive data

Custom Field Features:

  • Unique Constraints — Ensure field values are unique
  • Required Fields — Make fields mandatory
  • Default Values — Set default values for fields
  • Field Descriptions — Add descriptions for clarity

🌟 Example: Create "Products" project → Add fields: Name (string), Price (number, currency), Category (select), Release Date (datetime) → Table view shows structured database → Each row is a product record.

Database Structure:

  • Rows — Each task/node is a database record
  • Columns — Custom fields are database columns
  • Data Types — Fields enforce data types (string, number, date)
  • Constraints — Unique constraints ensure data integrity

👉 How to use: Project settings → Add custom field → Choose type → Configure → Use in Table view

📋 Table View: Database Interface

Switch to Table view to see your project as a structured database.

Table View Features:

  • Spreadsheet Interface — Rows and columns like Excel/Sheets
  • Sorting — Sort by any column
  • Filtering — Filter rows by field values
  • Column Management — Show/hide columns
  • Inline Editing — Edit data directly in table
  • Bulk Operations — Select multiple rows for operations

🌟 Example: "Orders" project → Table view → Columns: Order ID, Customer, Amount, Status, Date → Sort by amount → Filter by status → See database-like interface → Edit directly in table.

Table View Benefits:

  • Familiar Interface — Spreadsheet-like experience
  • Data Analysis — Sort and filter for insights
  • Quick Editing — Edit multiple records quickly
  • Visual Organization — See all data at once

👉 How to use: Project → Switch to Table view → See structured data → Sort, filter, edit → Use as database

⚡ Projects as Automation Databases

Use projects as data sources and targets for automation workflows.

Automation Actions:

  • Create Task — Add new records to project database
  • Update Custom Fields — Update field values automatically
  • Find Tasks — Query project database
  • Move Task — Reorganize database records

Automation Triggers:

  • Task Created — Trigger when new record added
  • Task Completed — Trigger when record marked complete
  • Custom Field Updated — Trigger when field value changes
  • Task Assigned — Trigger when record assigned

🌟 Example: Form submission → Automation creates task in "Leads" project → Sets custom fields (Name, Email, Source) → Updates "CRM Dashboard" project → Triggers follow-up automation → Complete database workflow.

Database Workflow Example:

Lead Management System:

  1. Form Trigger — New lead submits form
  2. Create Record — Automation creates task in "Leads" project
  3. Set Fields — Updates custom fields (Name, Email, Company, Status)
  4. Branch Logic — Routes based on lead source field
  5. Update Dashboard — Updates "Sales Dashboard" project
  6. Notify Team — Sends Slack notification

🌟 Result: Form → Project database → Automation processes → Dashboard updates → Team notified → Complete database workflow.

Automation Database Features:

  • CRUD Operations — Create, read, update, delete records
  • Field Updates — Update custom fields via automation
  • Data Validation — Unique constraints enforced
  • Bulk Operations — Process multiple records
  • Data Sync — Sync between projects automatically

👉 How to use: Create project database → Add custom fields → Create automation → Use "Create Task" / "Update Custom Fields" actions → Watch database update automatically

🤖 Projects as AI Agent Knowledge Bases

Connect projects as structured knowledge for AI agents. Agents can retrieve and understand structured project data.

How Agents Access Projects:

  • Project Connection — Connect project to agent as knowledge
  • Structured Retrieval — Agent uses retrieveProjectContext tool
  • Field Access — Agents understand custom fields and structure
  • Data Querying — Agents can query project data intelligently

Agent Knowledge Features:

  • Structured Data — Agents understand project structure
  • Custom Fields — Agents know field types and values
  • Relationships — Agents understand task relationships
  • Real-Time Data — Agents access current project data

🌟 Example: Connect "Product Catalog" project to agent → Agent understands product structure → Users ask "What products cost over $100?" → Agent queries project → Retrieves relevant products → Answers based on structured data.

Project Knowledge Benefits:

  • Structured Understanding — Agents understand data structure
  • Accurate Answers — Answers based on actual project data
  • Field Awareness — Agents know custom fields and types
  • Contextual Responses — Responses include relevant field values

How It Works:

  1. Connect Project — Add project to agent knowledge
  2. Agent Awareness — Agent knows project structure
  3. Query Tool — Agent uses retrieveProjectContext tool
  4. Structured Response — Agent answers with structured data

👉 How to use: Create project database → Add custom fields → Connect to agent → Agent understands structure → Users ask questions → Agent retrieves structured data → Answers accurately

🔄 Complete Database Workflow Example

CRM System Using Projects as Database:

Step 1: Create Database Project

  • Create "Customers" project
  • Add custom fields: Name (string), Email (string, unique), Status (select), Value (number, currency)
  • Switch to Table view
  • See database interface

Step 2: Automation Workflows

  • Form Submission → Creates customer record → Sets all fields
  • Status Change → Updates customer status → Triggers follow-up
  • Value Update → Updates customer value → Updates dashboard
  • Scheduled Sync → Syncs with external CRM → Updates project

Step 3: AI Agent Knowledge

  • Connect "Customers" project to support agent
  • Agent understands customer structure
  • Users ask "Who are our top customers?"
  • Agent queries project → Retrieves customers sorted by value → Answers with structured data

Step 4: Genesis App Integration

  • Build CRM dashboard Genesis app
  • App reads from "Customers" project
  • Dashboard displays customer data
  • Agent embedded in app answers questions

🌟 Result: Project database → Automation workflows → AI agent knowledge → Genesis app → Complete database system.

👉 Complete System: Database → Automation → AI → App → Everything connected

📊 Database Use Cases

1. CRM Database

  • Project: Customers database
  • Fields: Name, Email, Company, Status, Value, Last Contact
  • Automation: Form → Create customer → Update status → Notify team
  • Agent: Support agent connected → Answers customer questions

2. Inventory Database

  • Project: Products database
  • Fields: SKU, Name, Price, Stock, Category, Supplier
  • Automation: Order → Update stock → Alert on low inventory
  • Agent: Inventory agent → Answers product questions

3. Project Management Database

  • Project: Projects database
  • Fields: Name, Status, Budget, Deadline, Team, Progress
  • Automation: Task completed → Update progress → Check budget
  • Agent: Project agent → Answers project questions

4. Content Database

  • Project: Content database
  • Fields: Title, Type, Status, Author, Publish Date, Views
  • Automation: Content published → Update status → Notify team
  • Agent: Content agent → Answers content questions

🌟 Example: Each use case shows project as database → Automation workflows → AI agent knowledge → Complete system.

👉 Explore Use Cases: View Examples

🔗 Integration with Automation & Agents

Projects connect automation and AI agents:

Automation → Project Database:

  • Create Records — Automation creates tasks with custom fields
  • Update Records — Automation updates field values
  • Query Data — Automation finds tasks based on field values
  • Sync Data — Automation syncs between projects

Project Database → AI Agents:

  • Knowledge Source — Projects provide structured knowledge
  • Data Retrieval — Agents query project data
  • Structured Answers — Agents answer with field values
  • Context Awareness — Agents understand project structure

Complete Integration:

  • Form → Creates record in project database
  • Automation → Processes record → Updates fields
  • AI Agent → Answers questions about data
  • Genesis App → Displays database → Embeds agent

🌟 Example: Form submission → Project database → Automation processes → AI agent answers questions → Genesis app displays → Complete integrated system.

👉 See Integration: Automation → AI Agents → Genesis Apps

📈 Database Benefits

For Operators:

  • Structured Data — Organize data like a database
  • Automation Ready — Use projects in automation workflows
  • AI Knowledge — Connect projects to AI agents
  • Real-Time Updates — Data updates instantly

For Builders:

  • Database System — Build database systems without code
  • Automation Integration — Connect databases to workflows
  • AI Intelligence — Make databases intelligent with agents
  • App Integration — Use databases in Genesis apps

For Businesses:

  • Data Organization — Structure business data efficiently
  • Workflow Automation — Automate database operations
  • Intelligent Access — AI agents answer data questions
  • Scalable Systems — Handle large datasets

ROI Impact:

  • Time Savings — Automate database operations
  • Data Accuracy — Unique constraints ensure integrity
  • Intelligent Access — AI agents answer questions
  • Scalability — Handle large datasets efficiently

🧩 Other Improvements

Database Features:

  • Custom Fields — String, number, datetime, select, password
  • Unique Constraints — Ensure data uniqueness
  • Table View — Database-like interface
  • Multiple Views — Table, board, list, calendar, gantt
  • Real-Time Sync — Changes sync instantly

Automation Integration:

  • Create Task — Add records with custom fields
  • Update Custom Fields — Update field values
  • Find Tasks — Query database
  • Custom Field Triggers — Trigger on field updates

AI Agent Integration:

  • Project Knowledge — Connect projects as knowledge
  • Structured Retrieval — Agents query structured data
  • Field Awareness — Agents understand custom fields
  • Contextual Answers — Answers include field values

🧩 Other Improvements

Database Features:

  • Custom Fields — String, number, datetime, select, password
  • Unique Constraints — Ensure data uniqueness
  • Table View — Database-like interface
  • Multiple Views — Table, board, list, calendar, gantt
  • Real-Time Sync — Changes sync instantly

Automation Integration:

  • Create Task — Add records with custom fields
  • Update Custom Fields — Update field values
  • Find Tasks — Query database
  • Custom Field Triggers — Trigger on field updates

AI Agent Integration:

  • Project Knowledge — Connect projects as knowledge

  • Structured Retrieval — Agents query structured data

  • Field Awareness — Agents understand custom fields

  • Contextual Answers — Answers include field values

  • Improved security, stability, and overall speed

  • Various bug fixes and optimizations

Check all updates on the Changelog Forum.

🚀 Join the Community

Great things are built together. Your ideas, feedback, and creations shape the future of Taskade Genesis. Connect, learn, and build with us:

Forum | Reddit | Facebook Group | Updates | Tutorials | Docs | Community

Memory That Never Forgets

Before: Documents. Static data. Manual updates.

Now: Databases. Structured memory. Automated processing.

Projects remember. Agents understand. Automations act.

Your workspace is alive.

Start building and exploring now

This is the origin of living software 🌱

— John Xie, Co-founder & CEO, Taskade