NocoDB

Introduction to NocoDB

NocoDB acts as an alternative to Airtable that allows you to easily build databases online. For organizations that rely on traditional relational databases like MySQL or PostgreSQL, making the data accessible to non-technical users often requires building custom internal tools from scratch. NocoDB addresses this by instantly turning your existing databases into a smart, spreadsheet-like interface. It allows marketing, sales, and operations teams to interact with live data without having to run SQL queries.

An automatic installation script is available to set up NocoDB with all necessary prerequisites on a production server. This capability means you can quickly get up and running without manually provisioning every piece of the tech stack.

Setting Up the Database Interface

When you first start with NocoDB, your initial task will be connecting your data sources. Once connected, the schema is introspected, and you are presented with a tabular view. Users can add columns, apply filters, and manipulate records just as they would in a traditional spreadsheet application.

The core value here is eliminating the learning curve associated with database administration tools, empowering end-users to manage data efficiently while the engineering team maintains full control over the underlying infrastructure and schema.

Deploying with Docker and PostgreSQL

For those deploying in their own environment, Docker provides the most straightforward path. You can connect your NocoDB instance to a PostgreSQL database by supplying the NC_DB environment variable in your Docker setup. This allows you to integrate NocoDB directly into your existing PostgreSQL infrastructure.

Here is an example of the official command used to run NocoDB via Docker connected to a PostgreSQL instance:

This command mounts the data directory, exposes the application on port 8080, and configures the database connection using the provided connection string.

Creating Custom Applications with Interfaces

As your organization's usage of NocoDB grows, giving everyone full access to the base data can become overwhelming and a security risk. The Interfaces feature in NocoDB allows administrators to create focused, custom pages for specific audiences using the base data without exposing the entire database configuration. Whether it is a review queue for approvers, a reporting dashboard for management, or a data entry form for field teams, Interfaces provide a tailored experience. The underlying base remains the single source of truth, while the interface layers abstract away the complexity.

Row-Level Security for Controlled Access

To further lock down access to sensitive data, granular permissions are essential. NocoDB provides functionality to restrict user access at the row level based on the viewer's identity, such as their email or team. A policy like "Assignee is the current user" ensures that individuals only see the records they are authorized to manage, effectively covering the entire workspace with a single rule.

This makes NocoDB an extremely flexible platform for managing relational data across different departments, providing the right tools and security measures to maintain data integrity while promoting operational agility.