DevPik Logo
databasespreadsheetno codeairtable alternativeself hostedproductivity

NocoDB: A Free Self-Hosted Airtable Alternative That Turns Any Database Into a Spreadsheet

NocoDB turns any database into a spreadsheet you can actually work in. It is a free self-hosted Airtable alternative with gallery, kanban, form, and calendar views, team sharing, automations, and a full REST API. It has 65,000+ stars on GitHub and runs on your own server with one Docker command.

ByMuhammad Tayyab7 min read
All open source picks
nocodb/NocoDB
The official repository — this write-up is not affiliated with the project.
65.6kTypeScriptSustainable Use License

What NocoDB Is: A Spreadsheet Front End for Real Databases

NocoDB is the fastest and easiest way to build databases online, and it has 65,582 stars on GitHub. It turns any database into a smart spreadsheet interface: the tables you already have become rows and columns you can sort, filter, and edit like a spreadsheet, while the data stays in a real database underneath. The idea behind it is simple. Spreadsheets are used by more than a billion people every day, but databases, which are far more powerful for computing, are much slower to work in. NocoDB closes that gap. One honest note on the license: NocoDB is free for personal and internal business use under its own Sustainable Use License. Its code is on GitHub, but it is source-available, not open source in the strict sense. If you need a permissively licensed database tool, that distinction matters, and this project states it plainly.

The Spreadsheet Interface: Grid, Gallery, Kanban, Form, Calendar

The core of NocoDB is a rich spreadsheet interface. You get the usual operations, create, read, update, and delete tables, columns, and rows, plus sort, filter, group, and hide or unhide columns. The same data can switch views: a grid by default, or a gallery, a form, a kanban board, or a calendar. Cell types cover the real cases: ID, links between tables, lookup, rollup, single line text, attachment, currency, formula, and user, among others. Views can be collaborative, so the whole team edits together, or locked, so nobody rearranges a shared view by accident. It feels like a spreadsheet because it is designed to be one, and the database underneath is what makes it scale past the point where a spreadsheet file falls over.

Put It on Top of a Database You Already Have

NocoDB does not ask you to move your data into its own silo. You can point it at a database you already have, MySQL, PostgreSQL, or SQLite, and it builds the spreadsheet interface on top of it. That is the part Airtable cannot do: your data stays where it lives, under your control, and NocoDB is the friendly face on it. Getting data in is straightforward too. If your starting point is a spreadsheet export, a quick CSV to JSON pass lets you check the shape of the data before you import it, so column names and types land correctly instead of needing a cleanup round afterwards. Once the data is in, the interface, the views, and the API all work the same way, whether the rows came from an import or from a database that has been running for years.

Sharing and Access Control: Your Team Sees Only What They Should

A database tool is only useful if you can share it safely, and NocoDB treats that as a core feature. You can share a whole base or a single view, either public or private, with password protection on shared links. Access control works at different levels with fine-grained roles, so one teammate can edit, another can only comment, and a client can see a single view and nothing else. Combined with locked views, that means a shared board stays the way you designed it while the team still works in it every day. For a small business, this is the difference between a spreadsheet that anyone can accidentally break and a system that holds its shape.

Automations and APIs: Slack, Email, and a REST API

NocoDB has an app store for workflow automations in three categories. Chat integrations cover Slack, Discord, and Mattermost. Email covers AWS SES, SMTP, and MailerSend. Storage covers AWS S3, Google Cloud Storage, and Minio. You can connect a table to Slack or email and automate the follow-up work that usually means copying data between apps by hand. For developers, there is programmatic access through REST APIs and a NocoDB SDK, with tokens, either JWT or social auth, to sign requests. The API is automatic: every table you build gets one. And when a view needs to leave the app, a Markdown Table Generator turns the exported rows into a clean markdown table for a doc, a wiki page, or a README, without reformatting by hand.

Installing NocoDB: One Docker Command

The recommended install is Docker. With SQLite it is one command: docker run -d, name it noco, mount a data volume, map port 8080, and pull nocodb/nocodb:latest. With PostgreSQL you add the connection string as an environment variable. Auto-upstall goes further: one command installs Docker and Docker Compose, sets up NocoDB with PostgreSQL, Redis, and a Traefik gateway, and upgrades everything when you run it again, including automatic SSL if you give it a domain. Once it is running, open http://localhost:8080/dashboard and you are in. The docs cover Docker Compose, Kubernetes, and Helm for production setups. Note that prebuilt binaries are no longer published, so Docker is the way to run it now.

Frequently Asked Questions

What is NocoDB?

NocoDB is a free self-hosted Airtable alternative that turns any database into a spreadsheet interface. It has 65,000+ stars on GitHub. You get grid, gallery, kanban, form, and calendar views, team sharing, automations, and a REST API, all running on your own server.

Is NocoDB open source?

Not in the strict sense. NocoDB is source-available under its own Sustainable Use License, and it is free for personal and internal business use. Its code is on GitHub, but the Sustainable Use License is not an OSI-approved open source license, so it should not be called open source.

What databases can NocoDB connect to?

NocoDB works on top of MySQL, PostgreSQL, and SQLite databases, including databases you already have. You point it at your existing database and it builds the spreadsheet interface on top, instead of asking you to migrate your data into its own system.

How is NocoDB different from Airtable?

Airtable is a hosted service: your data lives on their servers and you pay per seat. NocoDB runs on your own server, connects to databases you already own, and is free for personal and internal business use. You keep control of the data and the bill.

How do I install NocoDB?

The recommended way is Docker. One docker run command starts it with SQLite, or you can use the Auto-upstall script, which sets up Docker, PostgreSQL, Redis, and SSL automatically. Then open http://localhost:8080/dashboard in your browser.

Does NocoDB have an API?

Yes. NocoDB provides REST APIs and an SDK. Every table you build gets an automatic API, and requests are signed with a token, either JWT or social auth. You can also use the API to build your own apps on top of your data.

Related DevPik tools

Muhammad Tayyab

Written by

Muhammad Tayyab

Founder of DevPik

Muhammad Tayyab founded DevPik and builds its free developer tools. He writes about developer tools, AI and web technology.

More open source picks