APITable is an open-source, API-first alternative to Airtable and Notion that lets teams build collaborative databases, internal tools, and automation workflows without writing code. Designed for developers and non-technical users alike, it solves the problem of fragmented data systems by unifying spreadsheets, databases, and APIs into a single visual interface with real-time collaboration. Built with TypeScript, Next.js, NestJS, and Spring Boot, it supports both cloud-hosted and self-hosted deployments via Docker, with enterprise-grade features like SSO, audit logs, and auto-backups.
The platform’s architecture is built around a database-native model using Changesets, Operations, and Snapshots, enabling real-time sync for 100k+ rows. It exposes full Data and Metadata APIs, supports SQL-like DQL queries, and integrates with n8n, Zapier, and Appsmith. Deployment options include one-click Docker installs, DigitalOcean, Dome, and Gitpod for instant demos.
What You Get
- Realtime Collaboration with OT Algorithm - Multiple users can edit the same table simultaneously using Operational Transformation (OT) for conflict-free updates, supporting 100k+ rows with smooth performance.
- Automatic API Generation - Every table automatically exposes a full REST API for Data and Metadata, eliminating the need to manually build backend endpoints.
- Unlimited Cross-Table Links - Create bidirectional and one-directional relationships between tables without limits, enabling complex data modeling like CRM or ERP systems.
- 7 View Types - Grid, Gallery, Kanban, Mindmap, Gantt, Calendar, and Form views — each fully customizable with filters, sorting, and grouping for diverse use cases.
- Embeddable Tables & Dashboards - Generate HTML embed codes to insert live tables or dashboards into websites, apps, or documentation without iframes or redirects.
- Built-in Automation & Robots - Trigger actions like Slack messages, emails, or API calls on form submissions or row updates, with extensible custom robot actions.
- Enterprise Permissions System - Granular control over rows, columns, folders, and sub-folders with Mirror views for row-level permissions and team-based access control.
- SSO & SAML Integration - Enterprise-grade authentication via SAML and Single Sign-On for secure deployment in corporate environments.
- Data Exporter & Auto-Backup - Export data in multiple formats and schedule automatic database backups to prevent data loss in production environments.
- Widget System with 20+ Open-Source Widgets - Extend functionality with customizable widgets for charts, dashboards, formulas, and custom column types.
- DQL (Datasheet Query Language) - Query tables using a SQL-like syntax to filter, join, and aggregate data directly from the UI or API.
- AI-Powered Copilot & Automation - Chat with your database to generate charts, analyze data, create workflows, write content, or build chatbots using AI.
Common Use Cases
- Building a CRM without code - A sales team uses APITable to track leads, link contacts to deals, and embed forms on their website — all with automatic API access for their marketing tools.
- Creating an internal project management tool - A product team uses Kanban and Gantt views to manage sprints, assign tasks, and link issues to documentation — all shared via embeds across Slack and Confluence.
- Connecting 6,000+ apps via automation - A marketing ops team automates lead capture from web forms to CRM, email campaigns, and Slack alerts using Zapier and Make integrations.
- Embedding a live database into a customer portal - A SaaS company embeds APITable tables into their help center to let users view their subscription data, invoices, and support tickets in real time.
Under The Hood
Architecture
- Monorepo structure with clear separation of frontend, backend, and shared utilities via modular packages
- Layered backend design with entity and mapper layers, though lacking explicit dependency injection or service registry
- Hybrid SSR/SSG frontend with Next.js and Handlebars, integrated with backend APIs through well-defined endpoints
- Microservices orchestrated via Docker Compose with dedicated services for real-time collaboration and data storage
- Absence of event-driven patterns or CQRS suggests a controller-centric, procedural approach
Tech Stack
- Java backend powered by Spring Boot, packaged as a JAR and communicating via REST
- Frontend built with React and TypeScript, managed through pnpm and documented with Storybook
- Microservices architecture leveraging Redis, MySQL, and MinIO for caching, relational data, and object storage
- Real-time collaboration enabled by a dedicated Room Server using WebSocket protocols
- CI/CD pipelines powered by Docker, Render, and Gitpod with comprehensive testing via Jest and Cypress
Code Quality
- Extensive test coverage across units, integrations, and repositories with realistic fixtures and mocking
- Strong type safety enforced through TypeScript interfaces and clear separation of domain models and APIs
- Consistent naming conventions and modular file organization by feature domain
- Robust error handling with transactional boundaries and custom repository logic
- Strict linting, annotated SQL fixtures, and disciplined dependency management ensure maintainability
What Makes It Unique
- Unified visual automation engine that natively connects database triggers, workflows, and external APIs
- Real-time collaborative editing optimized for multi-grid data structures with operational transformation
- Dynamic schema evolution that allows structural changes without downtime or data migration
- Embedded node-based visual scripting for non-developers to create automations
- Granular permission-aware data views with row/column-level access control and client-side conflict resolution