explaingit

teableio/teable

Analysis updated 2026-05-18

21,210TypeScriptAudience · pm founderComplexity · 4/5Setup · 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
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

What do people build with it?

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.

What is it built with?

TypeScriptPostgreSQLReactNode.js

How does it compare?

teableio/teableaidenybai/react-scanpmndrs/jotai
Stars21,21021,20621,146
LanguageTypeScriptTypeScriptTypeScript
Setup difficultyhardeasyeasy
Complexity4/52/52/5
Audiencepm founderdeveloperdeveloper

Figures from each repo's GitHub metadata at analysis time.

How do you get 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 top of Postgres that lets you build database-driven apps using a familiar spreadsheet-like interface. The pitch is a "Postgres-Airtable fusion": you click into cells, type values, sort, filter, and build little applications without writing backend code, but underneath everything is being stored in a real Postgres database. That means the speed, data capacity, and SQL access of a serious database are available even though the experience looks like a smart spreadsheet. What you actually get in the interface is a grid where each table can have formulas, sorting, filtering, grouping, frozen columns, aggregations like sum or average, formatting for numbers and dates, and import or export through formats such as .csv and .xlsx. Beyond the basic grid view, Teable supports a form view for collecting data, with kanban, calendar, gallery, gantt, and timeline views listed as coming soon. Because the data sits in Postgres, you can also point business-intelligence tools like Metabase or PowerBI at it, plug it into no-code app builders, or run native SQL queries directly. Real-time collaboration is built in: multiple people can edit at the same time without refreshing, with permissions that go down to the column level. The README also previews future features such as backend-less extensions written in a JavaScript-style flavor, a visual automation workflow builder, and an AI "copilot" that can generate apps, charts, and views from natural-language prompts. Teable is aimed at teams or solo builders who want internal tools, trackers, project boards, or small CRUD applications without standing up a backend, while keeping the option to graduate later to native database queries. The project is written primarily in TypeScript and can be self-deployed.

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?

Frequently asked questions

What is teable?

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.

What language is teable written in?

Mainly TypeScript. The stack also includes TypeScript, PostgreSQL, React.

What license does teable use?

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

How hard is teable to set up?

Setup difficulty is rated hard, with roughly 1h+ to a first successful run.

Who is teable for?

Mainly pm founder.

Open on GitHub → Explain another repo

This repo across BitVibe Labs

Scan in gitsafehub Deploy in gitdeployhub teableio on gitmyhub

Verify against the repo before relying on details.