APITable is an open-source, API-first low-code platform designed as a powerful alternative to Airtable, combining the flexibility of spreadsheets with the power of databases and real-time collaboration. Built with TypeScript (Next.js + NestJS) and Java (Spring Boot), it enables teams to create custom internal tools, CRM systems, project trackers, and BI dashboards without writing code—while still providing full API access for developers. Unlike traditional no-code tools, APITable emphasizes extensibility and integration, allowing users to embed tables directly into applications, automate workflows via n8n/Zapier, and enforce granular permissions at the row and column level. It’s ideal for technical teams seeking a self-hostable, scalable database UI that bridges the gap between non-technical users and backend systems.
What You Get
- Realtime Collaboration - Multiple users can edit the same database simultaneously using Operational Transformation (OT) algorithms, supporting up to 100k+ rows with live updates.
- Automatic Form Generation - One-click creation of shareable, embeddable forms from any table, enabling data collection without manual UI development.
- API-first Panel - Full REST API access to both data and metadata, with a built-in DQL (Datasheet Query Language) for SQL-like queries directly from the UI.
- Unlimited Cross-Table Links - Create bidirectional and one-directional relationships between tables without limitations, enabling complex data modeling.
- 7 View Types - Grid, Gallery, Mindmap, Kanban, Gantt, Calendar, and more—each customizable for different use cases like project tracking or inventory management.
- Embeddable Tables - Generate HTML embed codes to integrate live APITable tables into websites, apps, or internal portals without redirects.
- Enterprise Permissions - Row-level and column-level permissions via mirroring, folder hierarchies, team management, and SSO/SAML support for secure deployments.
- Extensible Widget System - Over 20 open-source widgets available, with support for custom data column types, formulas, and automation robot actions.
- Built-in BI Dashboard - Visualize data with charts and graphs directly within tables, enabling analytics without external tools.
- Auto Backup & Data Export - Scheduled database backups and export functionality (CSV, Excel) for compliance and data portability.
- Multi-language Support - Full UI localization in English, Chinese, Spanish, French, German, and Japanese.
Common Use Cases
- Building a custom CRM - Sales teams use APITable to track leads, assign follow-ups via Kanban views, and embed forms on their website for lead capture—all with column-level permissions to restrict sensitive data.
- Creating a project management dashboard - Engineering teams manage sprints using Gantt and Kanban views, link tasks to Jira or GitHub via automation bots, and share live dashboards with stakeholders via embed codes.
- Internal tool for HR onboarding - HR departments create forms to collect new hire information, auto-generate employee records in a database, and use row permissions to ensure only managers can view salary fields.
- Central configuration management - DevOps teams use APITable as a single source of truth for environment variables, API keys, and service configurations—accessible via REST API and embedded in internal portals.
- Connecting disparate systems - Companies unify data from spreadsheets, forms, and legacy databases into one visual interface with APIs that feed into BI tools or custom apps.
- DevOps teams managing microservices across multiple cloud providers - APITable’s API and embed capabilities allow teams to monitor service statuses, track deployment pipelines via custom views, and share live dashboards across teams.
Under The Hood
Apitable is a large-scale, multi-language platform designed to provide a flexible and extensible environment for building collaborative tools, combining a TypeScript-based frontend with a Java-powered backend. The system emphasizes modular architecture and rich UI component integration, enabling seamless asset management and API-driven development.
Architecture
The system follows a monorepo structure with distinct frontend and backend modules, applying layered design principles to separate concerns effectively.
- The architecture utilizes a service-oriented pattern with clear separation between API layers, controllers, and data transfer objects
- Modular organization supports scalable development and maintainable component libraries
- Design patterns such as DTOs and controller-based routing are consistently applied across modules
Tech Stack
The platform leverages a modern tech stack combining TypeScript and Java, with extensive tooling for development and deployment.
- Built primarily with TypeScript for frontend UI components and Java for backend services using NestJS and Spring Boot
- Integrates React ecosystem tools like Redux, Ant Design, and utility libraries such as Lodash and ahooks
- Employs Nx for monorepo management, pnpm for package handling, Gradle for builds, and Docker for containerization
- Enforces code quality with ESLint and Prettier, and supports testing through Jest and Cypress
Code Quality
The codebase reflects a mature approach to quality with strong testing practices and consistent conventions.
- Comprehensive test coverage spans multiple layers, including unit and end-to-end testing strategies
- Error handling is standardized with clear validation and consistent logging practices
- Code style and formatting are enforced through linting and formatting tools, ensuring consistency
- Some technical debt is evident in legacy code paths that may impact long-term maintainability
What Makes It Unique
Apitable stands out with its hybrid backend architecture and advanced asset handling capabilities.
- Features a dual-language backend approach that combines Java services with TypeScript frontend components
- Offers a modular, extensible design supporting rich UI libraries and cross-platform asset integration
- Integrates comprehensive API documentation and a well-defined component architecture for scalability