NocoDB

NocoDB is an open-source, self-hosted web app and server that transforms existing databases into a no-code platform by providing a spreadsheet-like interface for data management. The software is deployed as a server application and can be installed via Docker, binaries, or an automated installation script that handles the setup of necessary dependencies.

Users can connect NocoDB to external databases such as PostgreSQL and MySQL or use a built-in SQLite instance for simpler setups. The platform allows for the creation and manipulation of tables, columns, and rows without writing SQL, making database administration accessible to non-technical users while maintaining the full structure and scale of a relational database. This approach enables teams to manage millions of rows of data through a familiar web interface.

Key features

• Grid, Gallery, Form, Kanban, and Calendar view types
• Support for various cell types including Lookup, Rollup, Formula, and Attachment
• Fine-grained access control using roles and permissions at different levels
• Automatic generation of REST APIs for programmatic data access
• Public and private sharing of bases and views with password protection
• Integration with chat tools like Slack, Discord, and Mattermost
• Storage connectivity for AWS S3, Google Cloud Storage, and Minio
• Sorting, filtering, and grouping of columns and rows

The architecture is designed to support both local testing and production environments. For production deployments, the auto-upstall script configures a full stack including PostgreSQL, Redis, and a Traefik gateway to manage SSL certificates and domain routing. Developers can interact with the data through a dedicated SDK or JWT-authorized REST APIs, which allows NocoDB to function as a backend for other applications while providing a visual management layer for administrators.

NocoDB is a tool to democratize database access by removing vendor lock-in and providing a flexible, open interface for business data management.