NocoDB is an open source Airtable alternative that instantly also generates REST APIs on any MySQL database!
For this example :
We will be using a fairly large mysql database (close to 400 tables) as input to NocoDB and create REST APIs automatically.
Without further ado-lets get into the gist of things.
Pre-requisites
- Node.js or Docker
- An existing MySQL database
Getting started
Using npx
npx create-nocodb-app
Using Docker
docker run -d --name nocodb -p 8080:8080 nocodb/nocodb
Now, let's see a quick demo
In the demo, NocoDB automatically first inferred the database schema then generated REST APIs for each table-and-relation with Swagger documentation! All of this was without write a single line of code.
Where can I find more details about NocoDB ?
The Open Source Airtable Alternative
NocoDB is the fastest and easiest way to build databases online
Website • Discord • Community • Twitter • Reddit • Documentation
Join Our Community
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
# replace with your pg connection string
-e NC_DB="pg://host.docker.internal:5432?u=root&p=password&d=d1"
# replace with a random secret
-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, Minio…
Does NocoDB support other databases ?
Yes - we do!
NocoDB does support all of the below databases :
- Postgres
- SQL-server
- SQLite
- MySQL & MariaDB.
Please join our community
- 📣 Github : https://github.com/nocodb/nocodb
- 📣 Docs : https://docs.nocodb.com
- 📣 Discord : https://discord.gg/5RgZmkW
- 📣 Twitter : https://twitter.com/nocodb
FAQs
- Is authentication built in ? Yes
- Is ACL built in ? Yes
- Is collaboration built in ? Yes
- Are webhooks built in ? Yes
- Is there an audit log ? Yes
Top comments (1)
Misleading title. No relation between content and title