baserow/baserow
Baserow
Baserow is a self-hosted, no-code relational database platform built on PostgreSQL. It provides a spreadsheet-like interface for structuring and managing data without writing code, while exposing all database resources via a REST API to support headless architectures.
The platform distinguishes itself by integrating large language models and embedding servers to power AI assistants and automated data generation. It further extends its utility as a no-code application builder, allowing users to create custom internal portals, dashboards, and business tools using visual logic and managed data.
The system covers a broad range of capabilities, including business process automation with visual triggers, collaborative workspace management, and flexible data visualization through kanban boards, calendars, and timelines. It also supports advanced extensibility via a plugin system for custom field types and view filters, and executes user-defined scripts within a secure webassembly sandbox.
Deployment is supported across various environments using Docker Compose, Helm charts for Kubernetes, and cloud infrastructure templates.
Features
- No-Code Database Interfaces - Provides a visual platform for managing relational database records using a spreadsheet-like interface without writing code.
- Programmatic Content APIs - Exposes all database resources via a REST API to support headless architectures for external tools.
- Business Process Automation - Provides visual triggers and logic to automate data synchronization and task execution across external services.
- Business Workflow Automation - Automates repetitive business processes and data operations through event-driven triggers.
- Internal Tool Builders - Provides a no-code environment to build and publish internal tools and dashboards on custom domains.
- AI-Integrated Knowledge Bases - Connects large language models to structured data and embedding servers to power intelligent assistants.
- Visual Workflow Automators - Offers a visual interface for designing business logic flows with triggers, branches, and loops.
- Calculated Fields - Computes cell values automatically using mathematical operators and conditional logic based on other fields.
- Visual Data Management Views - Presents database records through grids, kanban boards, calendars, timelines, forms, and surveys.
- Table Creation - Provides tools for initializing and modifying database tables, each with its own schema representation.
- Conditional Row Filters - Hides rows from a view that do not meet specific criteria using operators like equals or contains.
- Formula-Based Field Creations - Creates new fields by evaluating formulas that reference and depend on other existing fields in the record.
- PostgreSQL Database Platforms - Implements a comprehensive data management system built on PostgreSQL that exposes records via a REST API.
- Spreadsheet-Like Interfaces - Implements a visual interface that presents database tables as editable spreadsheets for non-technical data manipulation.
- Compiled Formula Engines - Translates a custom expression language into optimized SQL queries for efficient server-side data calculation.
- No-Code Platforms - Enables users to compose custom pages, dashboards, and internal business tools using managed data without writing code.
- Internal Application Builders - Allows users to create custom internal portals and business applications using managed data and visual logic.
- Self-Hosted Infrastructure - Supports deployment on private servers via Docker or Kubernetes to maintain full control over data residency.
- Real-Time Data Synchronization - Streams data changes to connected clients via a persistent connection to keep views synchronized.
- Action-Based Access Restrictions - Enforces granular permissions to grant or deny specific CRUD operations on secured resources.
- Database Query Permissions - Restricts database query results to only include objects that the current user is authorized to access.
- Data View Configuration - Defines how table data is displayed through customizable layout settings for the same data set.
- RESTful Data APIs - Exposes database resources through a REST API for headless data management.
- WebSocket State Synchronization - Broadcasts real-time database changes to connected clients via WebSockets to maintain view consistency.
- Knowledge Base Retrieval - Retrieves relevant documentation from an embeddings server to improve the accuracy of AI responses.
- AI Agent Integrations - Integrates AI assistants and specialized AI fields directly into business automation workflows.
- AI Assistants - Provides an AI assistant that streams conversational responses by connecting LLMs to knowledge bases.
- AI Knowledge Management - Retrieves external documentation and data from an embeddings server to support AI-driven query responses.
- AI Provider Integrations - Connects to various large language model providers via compatible API endpoints to provide agentic capabilities.
- Database-Integrated AI - Bridges machine learning inference and database operations to provide AI-powered data generation and assistance.
- Generative AI Provider Integrations - Connects external AI providers and embedding services to power generative features and assistant tools.
- Git Repository Plugin Installations - Supports bootstrapping additional system functionality by installing plugins directly from Git repositories or URLs.
- Natural Language Schema Generation - Creates databases and workflows using natural language prompts to speed up the build process.
- Structured Data Generation - Uses natural language assistants to generate database schemas and management tools.
- Data Filter Extensions - Adds custom filter logic and input components via a plugin system to support new data comparisons.
- Application Templates - Bundles applications into shareable packages that other users can preview and install.
- Workspace Collaboration - Provides shared environments for teams to manage applications and data with real-time synchronization.
- Activity Auditing - Provides historical log entries to track and filter specific user actions and workspace changes.
- Cloud Data Stores - Persists application state to remote cloud servers to ensure data availability and portability across deployments.
- Cloud Storage Services - Interfaces with remote object storage and database services to manage application state and simplify migrations.
- S3-Compatible Cloud Storage - Persists uploaded files to S3-compatible object storage to ensure data durability across container restarts.
- Custom Field Type Definitions - Allows the definition of new data types for columns by implementing both backend storage and frontend UI components.
- Granular Update Subscriptions - Allows clients to subscribe to granular notifications for specific data entities.
- Data Visualization Dashboards - Builds visual charts and analytical dashboards to track progress and communicate key performance metrics.
- Database-Backed Configurations - Creates a snapshot of the database state to prevent data loss and enable recovery.
- Database Backup and Restoration - Persists and recovers system data by managing the storage directory or targeting the database engine.
- Database Backups - Creates a copy of the database state to protect data against loss or corruption.
- Filtered View Generation - Creates views that display only the rows matching specific conditions through custom filter logic.
- Database Templates - Packages pre-configured applications into a shareable format that other users can preview and install.
- External Data Importers - Implements mechanisms for importing data from CSV, XML, and JSON formats into the structured database.
- Extensible Application Frameworks - Provides a modular framework where functional modules can be expanded via plugins to introduce new application types.
- Automation Workflow Management - Provides tools to organize and track the execution history of automated task sequences.
- Cloud Deployment Platforms - Offers step-by-step guides for installing the platform on scalable cloud hosting environments.
- Cloud Infrastructure Deployment - Provides cloud templates to automate the provisioning and scaling of the environment.
- Container Orchestration Deployments - Supports deployment using all-in-one images or separate service containers for flexible scaling.
- Docker Compose Deployments - Orchestrates the application using Docker Compose definitions for multi-service deployment.
- Code Execution Sandboxes - Runs user-defined scripts within a secure WASM sandbox with strict memory and timeout limits.
- S3 File Uploads - Saves user-uploaded files and images directly to S3-compatible cloud storage providers.
- Helm Chart Deployment - Installs the full application stack onto Kubernetes clusters using packaged Helm charts.
- Kubernetes Deployments - Orchestrates installation on Kubernetes clusters using Helm charts and configuration files.
- Data Platforms - Offers a deployable data infrastructure supporting Docker and Kubernetes with integrated S3 storage and SSO authentication.
- Self-Hosted Deployments - Supports launching the application via pre-configured templates from third-party DevOps platforms.
- Service Splitting Deployments - Enables running the application as separate services within AWS ECS or Fargate for fault isolation.
- Resource Update Subscriptions - Enables clients to track specific pages or rows and receive notifications about changes.
- Formula Language Extensions - Adds custom functions and data types to the expression language via a plugin registry.
- Custom Formula Definitions - Allows the creation of custom formula functions via stored procedures to extend spreadsheet calculation capabilities.
- Wasm Sandboxes - Runs user-defined scripts within a secure WebAssembly sandbox with strict memory and timeout limits.
- Custom Authorization Logic - Implements pluggable permission managers to define complex, business-specific access control logic.
- JWT Authentication - Secures API access using JSON Web Tokens for time-limited authorization.
- Single Sign-On Providers - Integrates with external identity providers to enable centralized single sign-on authentication.
- User Account Management - Manages user profiles and authentication states to secure access to the platform.
- Plugin Extenders - Adds custom application types and field formats through a plugin system to customize how data is stored and presented.
- Plugin Authoring Templates - Provides boilerplate templates for building custom application types and view filters to extend platform functionality.
- Plugin Installation and Management - Provides tools to list all active plugins to confirm successful installation and manage versions.
- Container-Based - Provides extensibility by installing functional modules via Docker images, environment variables, or CLI scripts.
- Plugin-Based Architectures - Provides a plugin system for adding custom field types and view filters by registering backend and frontend modules.
- Custom Table Views - Defines new ways to visualize table data by registering custom view types with backend models.
- Real-time Sync Engines - Broadcasts database changes to clients in real time using persistent connections to keep views synchronized.
- Collaborative Office Suites - API-first collaborative database platform with plugin support.
