explaingit

teableio/teable

📈 Trending21,210TypeScriptAudience · pm founderComplexity · 4/5ActiveSetup · hard

TLDR

Open-source no-code database with a spreadsheet interface backed by real PostgreSQL, letting you use SQL tools and BI platforms directly on your data.

Mindmap

mindmap
  root((Teable))
    What it does
      Spreadsheet interface
      PostgreSQL backend
      Real-time collaboration
      SQL query support
    Features
      Grid, Form, Kanban views
      Formulas and aggregations
      Sorting and filtering
      Import/export CSV, XLSX
    Use cases
      Replace Airtable
      Connect BI tools
      Self-hosted databases
      Team data management
    Tech stack
      TypeScript
      PostgreSQL
      React frontend
      Node.js backend

Things people build with this

USE CASE 1

Build a team-shared database with spreadsheet-like editing instead of paying for Airtable.

USE CASE 2

Connect Metabase or PowerBI directly to your data for real-time dashboards and reports.

USE CASE 3

Self-host a no-code database on your own infrastructure for data privacy and control.

USE CASE 4

Create forms and kanban boards for data entry and project tracking without writing code.

Tech stack

TypeScriptPostgreSQLReactNode.js

Getting it running

Difficulty · hard Time to first run · 1h+

Requires PostgreSQL setup and multiple services (backend, frontend, database) to run locally.

License could not be detected automatically. Check the repository's LICENSE file before use.

In plain English

Teable is a no-code database tool built on Postgres that gives you a spreadsheet-like interface for building applications without writing backend code. The pitch is a "Postgres-Airtable fusion": the familiar grid of rows and columns that Airtable popularised for non-developers, but with a real Postgres database underneath rather than a proprietary store. You get to design tables, enter data, and build small internal tools through clicking and typing, while developers can still talk to the same data with standard SQL. Inside the grid view, you can click into any cell and edit it directly, write formulas to auto-calculate values, sort and filter rows, group them into collapsible sections, freeze columns so they stay visible while you scroll, and import or export through .csv and .xlsx files. Beyond the default grid there is a form view for collecting data, with kanban, calendar, gallery, gantt, and timeline views listed as upcoming. Because the storage is plain Postgres, the project says you can connect business-intelligence tools like Metabase and PowerBI, no-code tools like Appsmith, or just query the data with native SQL. It is designed for real-time collaboration, with table-level and column-level permissions and updates that appear without refreshing the page. You would reach for Teable when a team needs to spin up an internal tool, a project tracker, or a customer database quickly, but does not want to be locked out of the underlying data. The project is written primarily in TypeScript and is self-hostable, with a one-click Deploy on Railway template offered. The full README is longer than what was provided.

Copy-paste prompts

Prompt 1
How do I set up Teable on my own server using Docker and PostgreSQL?
Prompt 2
Show me how to connect Metabase to a Teable database to build dashboards.
Prompt 3
What formulas and aggregations can I use in Teable cells, and how do they compare to Airtable?
Prompt 4
How do I configure column-level permissions so different team members see different data in Teable?
Prompt 5
Can I query my Teable data directly with SQL, and how do I connect external tools like Appsmith?
Open on GitHub → Explain another repo

Generated 2026-05-21 · Model: sonnet-4-6 · Verify against the repo before relying on details.