DEV Community

Cover image for Generate REST APIs on ANY MySQL database.
o1lab
o1lab

Posted on Edited on

Generate REST APIs on ANY MySQL database.

NocoDB

NocoDB is an Open Source Airtable and also the easiest way to create instant REST APIs on any MySQL/Postgres databases.

GitHub logo nocodb / nocodb

šŸ”„ šŸ”„ The Open Source Airtable Alternative - Powered by Vue.js ā¤ļø

NocoDB
šŸŽƒ The Open Source Airtable Alternative šŸŽƒ

Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart-spreadsheet

Build Status Node version Twitter

Website • Discord • Twitter

The Open Source Airtable Alternative - works on MySQL, Postgres SQL Server & MariaDB

NocoDB - The Open Source Airtable alternative | Product Hunt

Quick try

1-Click Deploy

Heroku

Deploy NocoDB to Heroku with 1-Click

Using Docker

docker run -d --name nocodb -p 8080:8080 nocodb/nocodb:latest
Enter fullscreen mode Exit fullscreen mode

To persist data you can mount volume at /usr/app/data/.

Using Npm

npx create-nocodb-app

Using Git

git clone https://github.com/nocodb/nocodb-seed
cd nocodb-seed
npm install
npm start

GUI

Access Dashboard using : http://localhost:8080/dashboard

Join Our Community


Screenshots

2

1

7

5

6

3

4

11

10

8

9

Features

Rich Spreadsheet Interface

  • ⚔ Ā Search, sort, filter, hide columns with uber ease
  • ⚔ Ā Create Views : Grid, Gallery, Kanban, Gantt, Form
  • ⚔ Ā Share Views : public & password protected
  • ⚔ Ā Personal & locked Views
  • ⚔ Ā Upload images to cells (Works with S3, Minio, GCP, Azure, DigitalOcean, Linode, OVH, BackBlaze)
  • ⚔ Ā Roles : Owner, Creator, Editor, Viewer, Commenter, Custom Roles.
  • ⚔ Ā Access Control : Fine-grained access control even at database, table & column level.

App

…

Why this ?

Generating REST APIs for ANY exisitng MySql/Postgres database which does not follow conventions of frameworks such as rails, django, laravel etc is a small adventure that one like to avoid .. Hence this.

Getting started :

NocoDB is really simple and minimalistic to get started. NocoDB requires either node or docker installed on your machine.

Using npm

npx create-nocodb-app
Enter fullscreen mode Exit fullscreen mode

Using docker

docker run -d -p 8080:8080 nocodb/nocodb
Enter fullscreen mode Exit fullscreen mode

Demo

Documentation

Join our community :

Would love to hear your usecases & feedbacks. šŸ™Œ

Top comments (2)

Collapse
 
abhinav1217 profile image
Abhinav Kulshreshtha

What is the status of GraphQL support in NocoDB?

Collapse
 
o1lab profile image
o1lab • Edited

Thank you for checking - NocoDB does support GraphQL too! And you can choose the API type while creating the project. :D