NocoDB

small businessdeveloper tools

Open-source Airtable alternative that turns any SQL database into a spreadsheet-style interface. Grid, kanban, gallery, calendar, and form views with role-based access and REST API — no data migration needed

#database#no-code#spreadsheet#airtable-alternative#collaboration#self-hosted

Quick Start

docker run -d -p 8080:8080 nocodb/nocodb:latest

Overview

NocoDB is an open-source alternative to Airtable that puts a spreadsheet-style interface on top of any SQL database. Connect it to an existing Postgres, MySQL, or SQLite database and it reads the schema and generates a usable UI immediately — no migration, no re-importing data, no restructuring tables. Non-technical team members can filter, sort, and edit records without writing SQL or touching the database directly.

The view system covers the most common ways people want to see data: grid for row-by-row editing, kanban for pipeline-style workflows, gallery for visual browsing, calendar for date-based scheduling, and form for data entry from a public-facing URL. Each view is independent, so different users can have the same underlying data arranged in the way that suits their workflow.

REST and GraphQL APIs are generated automatically from your tables, which means you can query NocoDB programmatically without writing custom API code. This makes it practical both as a standalone tool for internal teams and as a lightweight backend for simple applications.

NocoDB is trusted by large organisations including Walmart, Bosch, and American Express across their 35,000+ reported users. That said, it is not a full Airtable replacement for automation-heavy workflows. The built-in automation features cover basic triggers and actions; anything complex needs to be routed through an external tool like n8n.

The AGPL-3.0 licence covers self-hosted internal use. Commercial embedding in a product or SaaS requires an enterprise agreement. Railway has an official NocoDB template if you want a managed deployment without provisioning a full server.

NocoDB: Pros & Cons

Pros (The Wins)Cons (The Friction)
No migration needed:
Connects directly to existing
Postgres, MySQL, or SQLite.
AGPL licence:
Commercial SaaS embedding
requires an enterprise deal.
Five view types:
Grid, kanban, gallery,
calendar, and form included.
Basic automations:
Built-in workflows are limited;
complex logic needs n8n etc.
Auto-generated API:
REST and GraphQL created
from your tables instantly.
Scale limits:
Not designed for analytics
workloads or very large tables.
63k stars:
Widely adopted; large
enterprise customers on record.
UI rough edges:
Some Airtable features are
still catching up.

Use Cases

Specific ways to use NocoDB for your workflow.

01
Give a non-technical team member a spreadsheet interface to a Postgres or MySQL database they could not use directly
02
Replace Airtable for a small team managing CRM data, project tracking, or inventory without per-seat fees
03
Build a data entry form that writes directly to an existing SQL database
04
Expose an internal database table to clients or contractors with view-only access

Deployment Strategy

Recommended ways to host NocoDB in your own environment.

docker
self-hosted