NocoDB

NocoDB puts a spreadsheet in front of a database so people who will never write SQL can work with the data directly. Tables, columns and rows are created and edited in the browser, backed by SQLite or PostgreSQL.

Installation is a single Docker command for a local instance. For production there is an auto-upstall script that installs Docker, brings up NocoDB with PostgreSQL, Redis and a Traefik gateway, sets up and renews SSL for a domain you supply, and upgrades the deployment whenever you run it again.

The interface covers what a team actually does with shared data.

• Multiple view types: grid, gallery, form, kanban and calendar over the same underlying table.
• Field operations: sort, filter, group and hide columns without touching the schema.
• Varied cell types: links, lookups, rollups, formulas, attachments, currency and user fields.
• Sharing controls: bases and views publish publicly or stay protected behind a password.
• Role-based access: fine-grained permissions apply at several levels, including locked views.

An app store adds workflow integrations across chat, email and storage, covering Slack, Discord, Mattermost, SES, SMTP, S3, Google Cloud Storage and Minio among others. REST APIs and an SDK handle programmatic access with signed tokens, and binaries exist for macOS, Linux and Windows for quick local testing.