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.



