Stars
Forks
Watchers
Developer links
APITable
With over 15,000 GitHub stars and positioning itself as the most feature-complete open-source alternative to Airtable, APITable combines a buttery-smooth spreadsheet interface with a full database engine and automatic API generation that turns every datasheet into a queryable REST endpoint without writing a single line of backend code. Real-time collaborative editing powered by Operational Transformation algorithms supports 100,000+ rows with multiple simultaneous users, while seven built-in view types — Grid, Kanban, Gallery, Gantt chart, Calendar, Mindmap, and Form — let teams visualize the same data in whatever format suits their workflow. The one-click API panel exposes every table as a documented REST API with filtering, sorting, and pagination, effectively functioning as a backend-as-a-service for frontend developers and automation builders. Robot automation triggers workflows on record changes with integrations into n8n, Zapier, Appsmith, and Slack, while the extensible widget system provides 20+ open-source widgets for custom charts, dashboards, and data visualizations embedded directly into datasheets. Enterprise features include SAML single sign-on, field-level and row-level permissions via Mirrors, organizational team management, audit logging, database auto-backup, and data export. Bi-directional table linking with infinite cross-links creates relational data models across workspaces, and built-in templates cover CRM, project management, inventory, and content planning. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. AGPL-3.0 licensed.
Benefits
- Automatic REST API Generation
- Every datasheet automatically becomes a documented REST API endpoint with filtering, sorting, and pagination, eliminating the need for custom backend development.
- Real-Time Collaborative Editing
- Multiple users edit the same datasheet simultaneously with Operational Transformation synchronization supporting 100,000+ rows without conflicts or data loss across concurrent sessions.
- Seven Flexible View Types
- Visualize data as Grid spreadsheets, Kanban boards, Gallery cards, Gantt charts, Calendar timelines, Mindmaps, or Forms from a single underlying dataset.
- Enterprise Permissions and SSO
- Control access with field-level and row-level permissions via Mirrors, SAML single sign-on, organizational team management, audit logging, and database auto-backup.
Features
- Robot Automation
- Trigger workflows on record changes with built-in automation bots and integrations into n8n, Zapier, Appsmith, and Slack for cross-platform data orchestration.
- Widget Extensibility
- Embed 20+ open-source widgets for custom charts, pivot tables, dashboards, and data visualizations directly into datasheets with a pluggable architecture.
- Bi-Directional Table Links
- Create relational data models with one-direction and bi-directional cross-links between tables across workspaces with infinite linking depth.
- One-Click Form Builder
- Generate shareable and embeddable data collection forms from any datasheet with automatic field mapping and submission routing to the underlying table.
- Space-Based Organization
- Organize datasheets into workspaces with folder hierarchies, team permissions, and customizable tree-structured navigation instead of rigid app-based silos.