1. Project Overview

vika.cnAPITable Community Edition, an exceptionally powerful open-source low-code and multidimensional spreadsheet tool, a free and open-source alternative to Airtable.

2. Open Source License

Licensed under AGPL-3.0

3. Screenshots

4. Feature Overview

APITable offers a range of amazing features for everyone, from individuals to enterprises.

• Advanced technology stack and open source
• Real-time collaboration: Allows multiple users to edit simultaneously in real time using Operational Transformation (OT) algorithms.
• An extremely smooth, user-friendly, and high-performance database-spreadsheet interface rendered with Canvas.
• Native database architecture: change sets, operations, actions, snapshots, and more.
• Real-time collaboration with 100k+ data rows
• Full-stack API access from Data to Metadata.
• One-way/two-way table links and unlimited cross-linking
• Community-friendly programming languages and frameworks: TypeScript (NextJS + NestJS) and Java (Spring Boot)
• Beautiful and fully featured multidimensional spreadsheet UI
• CRUD: Create, Read, Update, and Delete tables, columns, and rows
• Field operations: Sort, filter, group, hide/unhide, and adjust height.
• Space-based architecture: Replace the App/Base structure with separate workspaces, enabling unlimited table connections.
• Dark mode and customizable themes.
• 7 view types: Grid View (Datasheet) / Gallery View / Mind Map View / Kanban View / Full-featured Grid View / Calendar View
• One-click API panel
• Fully equipped
• 10+ built-in official templates
• Bot automation and custom configurations
• Business Intelligence (BI) dashboards
• One-click automatic form generation
• Shareable and embeddable pages
• Multi-Language Support
• Integrations with n8n.io / Zapier / Appsmith... and more
• Outstanding extensibility
• Over 20 official open-source components, plus an extensible component system
• Customizable charts & dashboards
• Customizable data column types
• Customizable formulas
• Customizable automation bot behaviors
• Enterprise-grade permissions
• Mirroring: Turn views into mirrors to implement row-level permissions
• Enable column-level permissions with a very simple operation
• Folder/subfolder/file permissions
• Tree-structured folders and customizable nodes (files)
• Team management & organizational structure
• Enterprise-grade application features
• SAML
• Single Sign-On (SSO)
• Audit
• Automatic database backups
• Data Export
• Watermarks
• ....

Use extensible components and plugins to add more features.

Use Cases

Why should you know about APITable and choose it as your next software solution?

• As a super management software
• Flexible project management & task/issue management
• Marketing lead management.
• The most flexible and connectable CRM
• Flexible BI charting system
• Easy-to-use tables and survey forms
• Flexible ERP
• Low-code and no-code platform.
• ...and more. APITable puts 1,000 software solutions in your pocket.
• As a visual database infrastructure
• Embed APITable into your own software UI
• Visual database with REST API
• Administrator dashboard
• Centralized configuration management
• All-in-one enterprise database that connects all your software
• ...and more, APITable connects everything
• In addition, it is open source and extensible

API-oriented

API panel

Click the API button in the upper-right corner to display the API panel

SQL-like queries

APITable provides a Data Query Language (DQL) for querying the contents of your database spreadsheets.

Embedding-friendly

Share and embed

Share your datasheets or folders. Embed them by copying and pasting HTML scripts.

Enterprise-ready embedding

APITable provides more enterprise-ready embedding features for the securities industry.

5. Tech Stack

Installation

Please make sure you have installed docker & curl locally.

If Docker is installed on your computer, open your terminal and run the following command:

curl https://apitable.github.io/install.sh | bash

Then open [https://localhost:80](https://localhost:80) in your browser to access it. (Default username: admin@apitable.com and password: Apitable2022)

If you want to set up your local development environment, please read our Developer Guide

Roadmap

Upcoming features

• Code-heavy UI generator
• Embeddable third-party document components
• SQL-like DSL
• As an IdP
• Web 3 features
• ...

Advanced features are available in the hosted and enterprise editions

• As an IdP
• SAML
• Single sign-on
• Audit
• Database backups
• Watermarks

Why did we create APITable and make it open source?

• We believe databases are the foundation of all software.
• We believe that creating a visual database with a rich and simple user interface for everyone can lower the barriers to the software industry and increase the adoption of digital applications worldwide.
• We believe open-sourcing APITable can move humanity forward

We are hiring remote developers!

We are always looking for talented people to join APITable:

• Full-stack Developer: Experience working with React, NextJS, TypeScript, Spring Boot, Java, and Terraform. Passionate about writing high-quality code with clear documentation and unit tests.
• Backend Developer: Experience working with NestJS, TypeScript, Spring Boot, Java, SQL, Kubernetes, and Terraform. Passionate about writing high-quality code with clear documentation and unit tests.
• Frontend Developer: Experience working with React, NextJS, TypeScript, and WebPack. Passionate about writing high-quality code with clear documentation and unit tests.

Regardless of your availability or circumstances, if you would like to join the APITable team, please feel free to send your resume to talent@apitable