Logo
Deploy Now

Stars

21499

Forks

1297

Watchers

90

Developer links

Teable

An Airtable-style spreadsheet interface directly on PostgreSQL: Teable is an open-source no-code database where every table is a real Postgres table. Unlike tools that store records in a metadata abstraction layer, every Teable table is a real Postgres table with standard column types, so filtering, sorting, and grouping run at database speed, million-row tables answer complex filters in roughly 200 milliseconds without index tuning, and any PostgreSQL-compatible tool - psql, BI dashboards, ETL pipelines - can query the same data directly. The interface offers Grid, Kanban, Gallery, Calendar, and Form views as non-destructive overlays with their own filters and hidden fields, plus 20+ field types, formulas, comments, attachments, batch editing, undo/redo, and edit history. Collaboration is real-time with live cursors and instant sync across views, backed by Redis, and a REST API is auto-generated per table, largely compatible with Airtable API clients - alongside native SQL access for BI tools, analytics pipelines, and your own applications to JOIN and query directly, with no exports, API rate limits, or sync jobs. Global search spans all records, chart plugins handle quick visualization, and CSV and Excel import/export cover migrations. Where Airtable caps paid plans at 100K-500K rows and charges roughly $20 per user per month, a self-hosted Teable instance has neither limit: the Postgres database itself is the export if you ever leave. Built in TypeScript with NestJS, deployed via Docker with PostgreSQL and Redis, and licensed AGPL-3.0.

Teable
Teable
Teable

Benefits

  • No Row Limits, Real Performance
  • Airtable caps paid plans at 100K-500K rows. Teable tables are physical Postgres tables, tested past a million rows with sub-second complex queries, and indexable for more.
  • Your Data Is Just PostgreSQL
  • Records live in standard SQL tables, so BI tools, analytics pipelines, and your own applications can JOIN and query them directly - no exports, API rate limits, or sync jobs.
  • Airtable UX Without Per-Seat Fees
  • The drag-and-drop, inline-editing interface closely matches Airtable's feel, while self-hosting replaces $20-per-user-per-month pricing with flat infrastructure cost.
  • No Vendor Lock-In
  • AGPL-licensed with data in an open format on your own server; if you ever leave, the Postgres database itself is the export.

Features

  • Spreadsheet-Grade Editing
  • Inline editing, batch operations, drag-and-drop columns, undo/redo, validation, field conversion, and full edit history on real database tables.
  • Five View Types
  • Grid, Kanban, Gallery, Calendar, and Form views as non-destructive overlays, each with independent filters, sorts, grouping, and hidden fields.
  • Real-Time Collaboration
  • Live multi-user editing with cursor presence and instant sync across views, backed by Redis.
  • Rich Field Types and Formulas
  • 20+ field types including attachments with preview, links between tables, formulas, and aggregation across grouped records.
  • Auto-Generated REST API
  • Every table exposes a REST API compatible with most Airtable API clients, plus native SQL query support for direct access.
  • Search, Charts, and Plugins
  • Global search across records, chart plugins for quick visualization, and import/export for CSV and Excel data.