Nocodb
NocoDB is a visual platform that transforms relational databases into collaborative, spreadsheet-style workspaces. By acting as a headless database backend, it provides a unified environment for designing database structures, managing record relationships, and interacting with data without requiring manual SQL queries. The platform normalizes interactions across various SQL and NoSQL data sources, allowing users to manage complex datasets through a centralized interface.
The project distinguishes itself by automatically generating RESTful and GraphQL APIs from existing database schemas, enabling external applications to interact with data programmatically. It features a robust event-driven engine that monitors database state changes to trigger webhooks and execute custom logic within a sandboxed automation runtime. This allows for the creation of complex business workflows that synchronize information across third-party services based on real-time data updates.
Beyond its core management capabilities, the platform offers a flexible view abstraction layer that renders data in multiple formats, including grids, kanban boards, galleries, forms, and calendars. It supports team collaboration through shared workspaces and provides tools for data visualization, schema design, and automated record manipulation.
Comprehensive documentation is available to guide users through the API reference, script creation, and integration workflows.
Features
- Dynamic REST API Generators - Exposes database tables as programmable endpoints by intercepting incoming requests and translating them into native SQL queries at runtime.
- Headless Database Backends - A service layer that automatically generates RESTful and GraphQL APIs from database schemas to support external application development and integration.
- Bases - Create Base — a named example documented in this learning resource.
- Database-Agnostic Query Layers - Normalizes interactions across various SQL and NoSQL data sources by using a unified abstraction layer for all CRUD operations.
- No-Code Database Interfaces - A visual platform that transforms existing relational databases into collaborative spreadsheet-style workspaces for managing and organizing complex data sets.
- Visual Database Builders - A unified environment for designing database structures, managing record relationships, and building custom views without writing manual SQL queries.
- Instant API Generation - Automatically exposing database tables as secure RESTful endpoints to allow external applications to interact with data programmatically.
- Database REST APIs - Generate RESTful endpoints for database tables to allow external applications to securely query, insert, update, or delete records through programmatic requests using standard authentication.
- Records - Create Record — a named example documented in this learning resource.
- Data Grids - Arrange and manipulate database records using a spreadsheet-style grid interface to perform bulk updates, sorting, and filtering for efficient data management.
- Data Entry Forms - Generate custom input forms to allow users to add or update information without requiring direct access to the underlying database tables or technical knowledge.
- Database-as-a-Service Transformations - Converting existing relational databases into collaborative, spreadsheet-like interfaces to make data management accessible to non-technical team members.
- Schema Designers - Design and modify database structures using visual diagrams and field editing tools to ensure data integrity and maintain clear relationships between different information sets.
- Database Automation APIs - URL: /docs/scripts/api-reference Explore the NocoDB Scripts API for advanced automation and integration ### Core Objects * Base Object - Access tables, collaborators, and create new structures * Table Object - Query, cre
- Record Management APIs - URL: /docs/scripts/api-reference Explore the NocoDB Scripts API for advanced automation and integration ### Core Objects * Base Object - Access tables, collaborators, and create new structures * Table Object - Query, cre
- Scripting APIs - URL: /docs/scripts/api-reference Explore the NocoDB Scripts API for advanced automation and integration ### Core Objects * Base Object - Access tables, collaborators, and create new structures * Table Object - Query, cre
- Data View Modes - Switch between multiple display formats including grids, kanban boards, galleries, forms, and calendars to view and interact with data in ways that best suit specific tasks.
- View Management - Actions on View — a named example documented in this learning resource.
- Table Management APIs - URL: /docs/scripts/api-reference Explore the NocoDB Scripts API for advanced automation and integration ### Core Objects * Base Object - Access tables, collaborators, and create new structures * Table Object - Query, cre
- External Database Connectors - Connect external data sources or import information into a centralized interface to manage high-volume datasets alongside existing records within a single unified environment.
- Webhook Engines - Monitors database state changes to trigger external HTTP requests based on user-defined rules and asynchronous background task execution.
- API Authentication - API Tokens — a named example documented in this learning resource.
- Visual Data Management Views - Organizing and interacting with complex datasets through flexible views like kanban boards, calendars, and galleries for better visibility.
- Database-Driven Automation Engines - A set of event-driven tools that trigger external actions and synchronize data across third-party services based on database changes.
- Automated Data Workflows - Triggering external actions and system integrations based on database events to synchronize information across platforms without manual intervention.
- Business Workflow Automations - Trigger automated actions across external services based on database events to synchronize information and eliminate manual data entry tasks for improved operational efficiency.
- Workflow Actions - Actions on Workflow — a named example documented in this learning resource.
- Custom Scripting Engines - Create Script — a named example documented in this learning resource.
- Webhook Integrations - Send HTTP requests to external services when specific data changes occur to trigger real-time workflows and keep connected systems synchronized with the latest information.
- Custom Data Collection Forms - Building user-friendly input forms that allow stakeholders to submit or update information directly into a database without technical access.
- Data Source Connections - Connect to Data Source — a named example documented in this learning resource.
- Table Data Managers - Filter, sort, and group records within tables to organize large datasets and extract meaningful insights through efficient data manipulation and analysis tools.
- Scriptable Automation Runtimes - Executes custom logic within a sandboxed environment to manipulate data records and interact with external services via programmatic APIs.
- Team Management - Invite colleagues to access shared projects to enable collaborative data management and improve overall productivity by allowing multiple users to work on records simultaneously.
- Workspace Collaboration - Workspace Collaboration — a named example documented in this learning resource.
- Webhooks - Create Webhook — a named example documented in this learning resource.
- AI-Powered Database Creation - Create Base using AI — a named example documented in this learning resource.
- Field Manipulation APIs - URL: /docs/scripts/api-reference Explore the NocoDB Scripts API for advanced automation and integration ### Core Objects * Base Object - Access tables, collaborators, and create new structures * Table Object - Query, cre
- Script Actions - Actions on Script — a named example documented in this learning resource.
- Workflow Orchestration - Create Workflow — a named example documented in this learning resource.
- Schema Mappers - Translates database table structures into dynamic application models by reading system catalogs and mapping them to a unified internal representation.
- Record Schemas - Expanded Record — a named example documented in this learning resource.
- Record Templates - Record Templates — a named example documented in this learning resource.
- Data Source Synchronizers - Sync with Data Source — a named example documented in this learning resource.
- Gallery Views - Transform raw database records into visual gallery layouts to display information in a descriptive and accessible format for better readability and user engagement.
- Kanban Boards - Organize database records into a kanban board layout to track task progress and streamline project workflows through a visual, column-based management system.
- Calendar Views - Display time-based records on a calendar interface to track deadlines and schedule events by utilizing date and time fields stored within the database.