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

> Projects as Databases: Structured Data for Automation & AI Agents

- Source: https://www.taskade.com/blog/projects-as-databases
- Published: 2025-12-20
- Updated: 2026-01-12
- Author: John Xie

Hey there 👋

**[Projects](https://www.taskade.com/templates) aren't just documents. They're databases.**

Use [Projects](https://www.taskade.com/templates) as structured databases with custom fields, table views, and [automation workflows](https://www.taskade.com/automate). Then connect them as [knowledge bases](https://www.taskade.com/learn/agents/custom-agents) for [AI agents](https://www.taskade.com/agents).

> **TL;DR:** Taskade [projects](https://www.taskade.com/templates) now work as structured databases with custom fields, multiple project views, and direct connections to [AI agents](https://www.taskade.com/agents) and [automations](https://www.taskade.com/automate). Store, query, and act on your data — all in one workspace. [Try it free →](https://www.taskade.com/create)

**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](https://www.taskade.com/learn/agents/custom-agents)** — Structured information for [AI agents](https://www.taskade.com/agents)
* **Automation Sources** — Data sources for workflow [triggers](https://www.taskade.com/learn/automation/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](https://www.taskade.com/templates) as data sources and targets for [automation workflows](https://www.taskade.com/automate).** Set up [triggers](https://www.taskade.com/learn/automation/triggers) that fire when your data changes.

**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](https://www.taskade.com/templates) as structured [knowledge](https://www.taskade.com/learn/agents/custom-agents) for [AI agents](https://www.taskade.com/agents).** Agents can retrieve and understand structured project data. Learn more about [training custom agents](https://www.taskade.com/blog/custom-ai-agents-training).

**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 in Community Gallery](https://www.taskade.com/apps)

* * *

🔗 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

```mermaid
graph TD
    A[📋 Project Data] --> B[🗃️ Structured Fields]
    A --> C[🔗 Relations]
    B --> D[🤖 AI Agents]
    C --> D
    D --> E[⚡ Automations]
    E -->|updates| A
    style A fill:#2a1225,color:#ff8fa3,stroke:#ff2d60,stroke-width:2px
    style D fill:#11111b,color:#cdd6f4,stroke:#00d4aa
    style E fill:#0d1a0e,color:#86efac,stroke:#22c55e,stroke-width:1.5px
```

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

👉 **See Integration**: [Automation](https://www.taskade.com/automate) → [AI Agents](https://www.taskade.com/agents) → [Genesis Apps](https://www.taskade.com/create)

* * *

📈 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 using [Taskade Genesis](https://www.taskade.com/create)
* **[Automation](https://www.taskade.com/automate) Integration** — Connect databases to [workflows](https://www.taskade.com/blog/advanced-automation-workflows)
* **[AI](https://www.taskade.com/agents) Intelligence** — Make databases intelligent with [agents](https://www.taskade.com/learn/agents/custom-agents)
* **App Integration** — Use databases in [Taskade Genesis](https://www.taskade.com/create) 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](https://www.taskade.com/changelog).

* * *

🚀 Join the Community
---------------------

Great things are built together. Your ideas, feedback, and creations shape the future of [Taskade Genesis](https://www.taskade.com/create). Connect, learn, and build with us:

[Feedback](https://www.taskade.com/feedback) | [Reddit](https://www.reddit.com/r/taskade/) | [Facebook Group](https://www.facebook.com/groups/taskade) | [Updates](https://www.taskade.com/blog/updates) | [Tutorials](https://www.taskade.com/learn) | [Docs](https://www.taskade.com/docs) | [Community](https://www.taskade.com/apps)

* * *

Memory That Never Forgets
---------------------------

Before: Documents. Static data. Manual updates.

Now: Databases. Structured memory. Automated processing.

[Projects](https://www.taskade.com/templates) remember. [Agents](https://www.taskade.com/agents) understand. [Automations](https://www.taskade.com/automate) act. Get started on any device — [download Taskade](https://www.taskade.com/downloads).

**Your workspace is alive.**

_[Start building](https://www.taskade.com/create) and [exploring](https://www.taskade.com/apps) now_

_This is the origin of living software 🌱_

— [John Xie](https://www.taskade.com/about), Co-founder & CEO, Taskade

## Frequently Asked Questions

### How do Taskade Projects work as databases?

Taskade Projects can store structured data with custom fields (text, number, date, status, people, URL, email), table views with sorting and filtering, and relationships between records. This turns projects from simple documents into queryable databases that AI agents and automations can read, write, and act upon.

### What is structured data in Taskade?

Structured data in Taskade means projects with defined field types — each task or record has consistent, typed data (not just free text). This enables powerful features: filter by status, sort by date, group by assignee, calculate totals, and let AI agents query specific fields. It's the foundation for building apps with reliable, organized information.

### Can AI agents access database data in Taskade?

Yes. AI agents can query, analyze, and act on data stored in Taskade projects. They can look up specific records, calculate aggregates, find patterns, generate reports, and update entries based on conditions. This creates an intelligent database where AI doesn't just store information — it understands and acts on it.

### How is Taskade different from Airtable or Notion databases?

Taskade combines database functionality with AI agents and automations in one platform. Unlike Airtable (databases only) or Notion (docs with databases), Taskade's projects serve as the Memory pillar of Workspace DNA — directly connected to AI Intelligence (agents) and Execution (automations). Your data isn't just stored — it powers intelligent, autonomous workflows.