---
title: Tables
description: Create, query, and manage workspace tables from Mothership.
---

import { Image } from '@/components/ui/image'
import { FAQ } from '@/components/ui/faq'

<Image src="/static/mothership/table-example.png" alt="Mothership resource panel showing the pipeline_deals table with company, deal_owner, stage, and amount columns, alongside a chat summary of total pipeline value and breakdown by stage" width={900} height={500} />

Create a table from a description or a CSV, query it in plain language, add or update rows, and export the results — all through conversation. Tables open in the resource panel as soon as they're created or referenced.

## Creating Tables

Describe the schema and Mothership creates the table:

- "Create a leads table with columns for name, email, company, status, and created date"
- "Create a table that matches the structure of this CSV [attach file]"
- "Set up an errors table with: id (text), message (text), workflow (text), timestamp (date), resolved (boolean)"
- "Create a prospect table for outbound — company, domain, employee count, industry, ICP score, and last contacted date"
- "Set up an enrichment results table to store output from the lead enrichment workflow: email, company, title, LinkedIn URL, fit score"

## Querying Data

Ask questions about table contents in plain language:

- "How many rows in the leads table have status 'qualified'?"
- "Show me all records from the past 7 days where score is above 0.8"
- "What are the top 5 most common error messages in the failures table?"
- "Are there any duplicate emails in the contacts table?"
- "How many prospects have an ICP score above 0.75 and haven't been contacted in the past 30 days?"
- "What's the conversion rate from 'contacted' to 'meeting booked' in the pipeline table this month?"

Mothership translates the question into a structured query and returns the results.

## Adding and Updating Rows

Add individual rows, bulk-update based on a condition, or delete records — all in plain language:

- "Add a row to the leads table: Acme Corp, jane@acme.com, status pending"
- "Mark all rows in the queue table as processed where created_at is before today"
- "Update the price column for all rows where tier is 'pro' to 49"
- "Delete all rows in the test_events table"

## Exporting

Export a full table or a filtered subset as a CSV. The file is saved to your workspace and can be downloaded or referenced in other workflows:

- "Export the leads table to a CSV"
- "Export all rows where status is 'closed' and save as a file"

## Using Tables in Workflows

Tables created in Mothership are immediately available in workflows via the [Table tool](/tools/table). Reference a table by name — no additional configuration needed.

<FAQ items={[
  { question: "Can Mothership join or combine data from multiple tables?", answer: "Yes. Describe the relationship and what you want — Mothership will query both tables and combine the results." },
  { question: "Is there a row limit?", answer: "There is no hard row limit set by Mothership. Performance for very large tables may vary." },
  { question: "Can I use a table created in Mothership as a workflow data source?", answer: "Yes. All workspace tables are accessible to the Table tool in any workflow." },
]} />
