NocoDB is a free, open source databases project written in TypeScript and released under a custom open-source licence. It has 64,998 GitHub stars, 5,054 forks and 710 open issues, and was last pushed 9 hours ago. On this registry it ranks #3 of 81 tracked projects in Databases, and is listed as an open source replacement for 2 paid products, with 5 head-to-head comparisons available. It gained 52 stars over the last 6 tracked days.

NocoDB — Transform databases into intuitive spreadsheets instantly

What is NocoDB?

NocoDB is a free and self-hostable open-source Airtable alternative that turns an existing relational database into an intuitive spreadsheet interface, built for teams who want no-code data management without moving their data into a hosted SaaS product.

What it is

NocoDB is a TypeScript no-code database platform that sits on top of a database and presents the underlying tables as spreadsheets. It lives in the Infrastructure & Operations / Databases category of this registry and is described by its own GitHub listing as "A Free & Self-hostable Airtable Alternative". The project ships as a Docker image, as prebuilt binaries for macOS, Linux and Windows, and through an installer script, and its topics list covers no-code-database, no-code-platform, low-code, spreadsheet, and automatic-api.

The concrete problem it solves is the gap between a real database and the people who need to work in it. Instead of a database administrator writing ad-hoc queries and exporting CSV files, or a team paying for a hosted grid product, NocoDB provides the spreadsheet view directly over the data, plus an automatically generated REST API over the same tables. It replaces Airtable and Microsoft Excel in that role: the interface and the API come from the project, while the data continues to live in a database the operator controls.

Key capabilities

  • Spreadsheet interface over database tables, exposed in the browser dashboard at http://localhost:8080/dashboard.
  • Automatic REST API generated over existing tables, so no separate API layer has to be written.
  • PostgreSQL support through the NC_DB environment variable, for example pg://host.docker.internal:5432?u=root&p=password&d=d1.
  • SQLite as the default local storage, used by the plain docker run path with a volume mounted at /usr/app/data/.
  • Self-hosting through the published image nocodb/nocodb:latest, run on port 8080.
  • Authentication configuration through NC_AUTH_JWT_SECRET, passed as an environment variable alongside the database connection.
  • Low-code and no-code build model, aimed at users who work with data rather than with SQL or schema migrations.

Who uses it and how

  • Self-hosters who run the nocodb/nocodb:latest container themselves and keep the database alongside it, rather than renting a hosted grid per seat.
  • Teams already running PostgreSQL that want a spreadsheet front end and a REST API over the same tables without duplicating the data.
  • Operators deploying to a server for production use, using the auto-upstall path, which generates a docker-compose configuration automatically.
  • Developers who want a quick local instance, using the per-platform binaries for macOS, Linux or Windows.
  • Organisations replacing spreadsheet-driven workflows, where Airtable or Microsoft Excel previously held the working data.

Getting started

The documented Docker path is a single docker run command against nocodb/nocodb:latest, with a volume mounted at /usr/app/data/ and port 8080 published. For production, the README documents auto-upstall, run as bash install.nocodb.com/noco.sh, which sets up NocoDB on a server and generates the docker-compose file behind the scenes.

How it compares

The project positions itself as an open alternative to Airtable and Microsoft Excel, both of which are proprietary paid products, while NocoDB is free and can be self-hosted. That shifts the cost model away from per-seat subscription pricing and keeps data ownership with the operator, since the records stay in the operator's own PostgreSQL or SQLite database. The trade-off is that the hosting, upgrades and backups become the operator's responsibility rather than the vendor's.

When to use it — and when not to

A self-hoster must run and maintain the application container along with whichever database backs it, either SQLite or PostgreSQL, and must set a JWT secret through NC_AUTH_JWT_SECRET. The licence is recorded as NOASSERTION, so anyone needing a clearly declared licence should confirm the terms before adopting it. The README is sparse, covering installation rather than a full feature list, and the binaries are documented as being for quick local testing only, not production; with 710 open issues, teams expecting a fully managed product should look elsewhere.

project readme (upstream, from github) — read inline



NocoDB is the fastest and easiest way to build databases online.

WebsiteDiscordCommunityTwitterRedditDocumentation

video avi

See other languages »

Join Our Community

Stargazers repo roster for @nocodb/nocodb

Installation

Docker with SQLite

docker run -d \
  --name noco \
  -v "$(pwd)"/nocodb:/usr/app/data/ \
  -p 8080:8080 \
  nocodb/nocodb:latest

Docker with PG

docker run -d \
  --name noco \
  -v "$(pwd)"/nocodb:/usr/app/data/ \
  -p 8080:8080 \
  -e NC_DB="pg://host.docker.internal:5432?u=root&p=password&d=d1" \
  -e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010" \
  nocodb/nocodb:latest

Auto-upstall

Auto-upstall is a single command that sets up NocoDB on a server for production usage. Behind the scenes it auto-generates docker-compose for you.

bash <(curl -sSL http://install.nocodb.com/noco.sh) <(mktemp)

Auto-upstall does the following: 🕊

  • 🐳 Automatically installs all pre-requisites like docker, docker-compose
  • 🚀 Automatically installs NocoDB with PostgreSQL, Redis, Traefik gateway using Docker Compose. 🐘 🗄️ 🌐
  • 🔄 Automatically upgrades NocoDB to the latest version when you run the command again.
  • 🔒 Automatically setups SSL and also renews it. Needs a domain or subdomain as input while installation.

install.nocodb.com/noco.sh script can be found here in our github

Other Methods

Binaries are only for quick testing locally.

Install Method Command to install
🍏 MacOS arm64
(Binary)
curl http://get.nocodb.com/macos-arm64 -o nocodb -L && chmod +x nocodb && ./nocodb
🍏 MacOS x64
(Binary)
curl http://get.nocodb.com/macos-x64 -o nocodb -L && chmod +x nocodb && ./nocodb
🐧 Linux arm64
(Binary)
curl http://get.nocodb.com/linux-arm64 -o nocodb -L && chmod +x nocodb && ./nocodb
🐧 Linux x64
(Binary)
curl http://get.nocodb.com/linux-x64 -o nocodb -L && chmod +x nocodb && ./nocodb
🪟 Windows arm64
(Binary)
iwr http://get.nocodb.com/win-arm64.exe -OutFile Noco-win-arm64.exe && .\Noco-win-arm64.exe
🪟 Windows x64
(Binary)
iwr http://get.nocodb.com/win-x64.exe -OutFile Noco-win-x64.exe && .\Noco-win-x64.exe

When running locally access nocodb by visiting: http://localhost:8080/dashboard

For more installation methods, please refer to our docs

Screenshots

2 3 4 5

5 7 8

8 9 10 11 12

Features

Rich Spreadsheet Interface

  • ⚡ &nbs

readme truncated — read the full docs on github

Frequently asked questions

Is NocoDB free to use?

NocoDB is open source. There is no licence fee and no seat count — you can self-host it or, where the project offers one, pay a vendor for a managed version instead.

What does NocoDB do?

Transform databases into intuitive spreadsheets instantly

What is NocoDB written in?

NocoDB is primarily written in TypeScript. Its source is publicly available at https://github.com/nocodb/nocodb, and it has 64,998 GitHub stars.

What is a good open source alternative to Airtable?

NocoDB is one of the open source options listed as an alternative to Airtable, Microsoft Excel. Compare licences, stars and activity side by side on the NocoDB profile.