开源软件名称：

开源软件地址：

开源软件介绍：

NocoDB
✨ The Open Source Airtable Alternative ✨

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

Website • Discord • Twitter

Quick try

1-Click Deploy

Using Docker

docker run -d --name nocodb -p 8080:8080 nocodb/nocodb

Using Npm

npx create-nocodb-app

Using Git

git clone https://github.com/nocodb/nocodb-seedcd nocodb-seednpm installnpm start

GUI

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

Join Our Community

Screenshots

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, Commenter, Viewer, Commenter, Custom Roles.
• ⚡  Access Control : Fine-grained access control even at database, table & column level.

App Store for workflow automations :

• ⚡  Chat : Microsoft Teams, Slack, Discord, Mattermost
• ⚡  Email : SMTP, SES, Mailchimp
• ⚡  SMS : Twilio
• ⚡  Whatsapp
• ⚡  Any 3rd Party APIs

Programmatic API access via :

• ⚡  REST APIs (Swagger)
• ⚡  GraphQL APIs.
• ⚡  Includes JWT Authentication & Social Auth
• ⚡  API tokens to integrate with Zapier, Integromat.

Production Setup

NocoDB requires a database to store metadata of spreadsheets views and external databases.And connection params for this database can be specified in NC_DB environment variable.

Docker

Example MySQL

docker run -d -p 8080:8080 \    -e NC_DB="mysql2://host.docker.internal:3306?u=root&p=password&d=d1" \    -e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010" \    nocodb/nocodb

Example Postgres

docker run -d -p 8080:8080 \    -e NC_DB="pg://host:port?u=user&p=password&d=database" \    -e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010" \    nocodb/nocodb

Example SQL Server

docker run -d -p 8080:8080 \    -e NC_DB="mssql://host:port?u=user&p=password&d=database" \    -e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010" \    nocodb/nocodb

Docker Compose

git clone https://github.com/nocodb/nocodbcd docker-composecd mysql or pg or mssqldocker-compose up

Environment variables

Running locally

git clone https://github.com/nocodb/nocodbcd nocodb# run backendcd packages/nocodbnpm installnpm run watch:run# open localhost:8080/dashboard in browser# run frontend cd packages/nc-guinpm installnpm run dev# open localhost:3000/dashboard in browser

Changes made to code automatically restart.

Contributing

• Please take a look at ./contribute/HowToApplyLicense.md
• Ignore adding headers for .json or .md or .yml