DEV Community

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

Posted on • Updated 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

WebsiteDiscordTwitter

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. 🙌

Discussion (2)

Collapse
abhinav1217 profile image
Abhinav Kulshreshtha

What is the status of GraphQL support in NocoDB?

Collapse
o1lab profile image
o1lab Author • Edited on

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