AITable

AITable is an open-source, self-hosted visual database platform that combines the interface of a spreadsheet with the capabilities of a database, allowing users to build internal tools, admin dashboards, and project management systems without extensive coding.

The software is deployed as a web application, typically hosted via Docker and Docker Compose on a server. It provides a low-code environment where users can manage data through a browser, while developers can interact with the system via a REST API or a custom Datasheet Query Language (DQL) for SQL-like querying of spreadsheet contents.

Key features

• Real-time collaboration using the Operational Transformation algorithm
• Seven view types including Grid, Gallery, Mindmap, Kanban, Gantt, and Calendar
• Full-stack API access for both data and metadata
• Automatic form generation and embeddable pages
• Unlimited one-direction and bi-direction cross-table links
• Row and column level permissions for enterprise access control
• Built-in BI dashboards and a customizable widget system
• Integration with n8n, Zapier, and Appsmith

The architecture is built using a modern stack featuring TypeScript with NextJS and NestJS on the frontend and backend, alongside Java and Spring Boot. It is designed for scalability, supporting over 100,000 data rows per table while maintaining real-time synchronization. The platform is intended for teams needing a flexible CRM, ERP, or a visual database infrastructure that can be embedded into other software UIs via HTML scripts. It includes a space-based structure that allows unlimited tables to link together, moving beyond simple app-based constraints.

Beyond basic data entry, the system supports complex workflow automation through robot actions and customizable formulas. It provides enterprise-grade security options such as SAML and Single-Sign-On (SSO) for organization management. The extensible nature of the platform allows for the addition of custom data column types and third-party widgets to tailor the interface to specific business needs.

AITable is a visual database infrastructure for those who require an extensible, API-first no-code platform.