Teable — No-Code Postgres Spreadsheet Database

What Teable Does

Teable provides a powerful data management experience:

• Spreadsheet Interface: Familiar grid view with sorting, filtering, grouping, and conditional formatting
• Multiple Views: Grid, Kanban, Gallery, Form, and Calendar views for the same data
• Real-time Collaboration: Multiple users editing simultaneously with live updates
• Field Types: 20+ field types including text, number, date, attachment, link, formula, rollup, lookup, and rating
• API Access: Auto-generated REST API for every table with full CRUD operations
• Automations: Trigger-action workflows for notifications, data sync, and integrations
• Forms: Public forms for data collection with customizable layouts
• PostgreSQL Native: All data stored in standard PostgreSQL tables, accessible via SQL

Architecture

┌──────────────┐     ┌──────────────┐     ┌──────────────┐
│  Next.js     │────▶│  NestJS      │────▶│  PostgreSQL  │
│  Frontend    │     │  Backend     │     │  (Your Data) │
└──────────────┘     └──────┬───────┘     └──────────────┘
                            │
                     ┌──────┴───────┐
                     │  Redis       │
                     │  (Realtime)  │
                     └──────────────┘

Self-Hosting

Docker Compose

services:
  teable:
    image: ghcr.io/teableio/teable:latest
    ports:
      - "3000:3000"
    environment:
      PRISMA_DATABASE_URL: postgresql://teable:teable@postgres:5432/teable
      BACKEND_CACHE_PROVIDER: redis
      BACKEND_CACHE_REDIS_URI: redis://redis:6379/0
    depends_on:
      - postgres
      - redis

  postgres:
    image: postgres:16-alpine
    environment:
      POSTGRES_USER: teable
      POSTGRES_PASSWORD: teable
      POSTGRES_DB: teable
    volumes:
      - pg-data:/var/lib/postgresql/data

  redis:
    image: redis:7-alpine

volumes:
  pg-data:

Key Features

PostgreSQL Native

Unlike Airtable, all Teable data lives in standard PostgreSQL:

-- Your Teable data is just PostgreSQL tables
SELECT * FROM tbl_customers WHERE status = 'active' ORDER BY created_at DESC;

-- Join across tables
SELECT c.name, COUNT(o.id) as order_count
FROM tbl_customers c
JOIN tbl_orders o ON o.customer_id = c.id
GROUP BY c.name;

This means you can:

• Query data with any SQL client or BI tool
• Connect Metabase, Grafana, or Tableau directly
• Use pg_dump for backups
• Write custom reports with raw SQL

Formula Fields

// Basic formulas
{Total} = {Price} * {Quantity}
{Full Name} = CONCATENATE({First Name}, " ", {Last Name})
{Days Until Due} = DATETIME_DIFF({Due Date}, NOW(), 'days')

// Conditional
{Status} = IF({Progress} >= 100, "Done", IF({Progress} > 0, "In Progress", "Not Started"))

Auto-Generated API

Every table gets a REST API automatically:

# List records
curl http://localhost:3000/api/table/{tableId}/record 
  -H "Authorization: Bearer YOUR_TOKEN"

# Create record
curl -X POST http://localhost:3000/api/table/{tableId}/record 
  -H "Authorization: Bearer YOUR_TOKEN" 
  -d '{"fields": {"Name": "John", "Email": "john@example.com"}}'

Teable vs Alternatives

FAQ

Q: Is Teable data really standard PostgreSQL? A: Yes. Each Teable table maps to a PostgreSQL table; fields map to PostgreSQL columns. You can query and manipulate the data with any PostgreSQL tool directly.

Q: Can I connect to an existing PostgreSQL database? A: Yes. Teable can connect to an external PostgreSQL database and map existing tables as Teable views — no data migration needed.

Q: How's the performance for large datasets? A: Because PostgreSQL is underneath, Teable handles millions of rows. For large tables, add appropriate indexes to maintain query performance.