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 ?

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

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

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

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

More :

• As an open source project how NocoDB got angel funded