Teable

Teable is an open-source, self-hosted web app that combines database capabilities with a spreadsheet interface. It allows users to create database applications and manage large datasets through a web-based environment. The software is deployed as a server application, typically via Docker, and can be hosted on-premise or in the cloud to ensure data privacy and ownership.

Users organize data in a familiar grid format while maintaining the structure of a relational database. It supports real-time collaboration and is designed to handle datasets containing millions of rows without the performance degradation often found in traditional no-code platforms. The platform provides a template center to help users quickly deploy pre-defined scenarios for various business needs.

Key features

• Multiple data views including Grid, Form, Kanban, Gallery, and Calendar
• Support for millions of rows of data
• SQL query capabilities for direct data interaction
• Real-time collaboration and batch editing
• Formula support, aggregation, and field conversion
• Built-in charts and attachment previews
• Data import and export functionality
• Plugin system for extending application capabilities
• History tracking with undo and redo options

The architecture consists of a Next.js frontend and a NestJS backend, utilizing PostgreSQL for data storage and Prisma for schema management. It includes a dedicated SDK for extensions and a shared UI library to maintain consistency across the interface. The system is designed to bridge the gap between non-technical users who prefer no-code interfaces and developers who require standard software patterns, API access, and data portability. By utilizing common software standards, it allows teams to scale their internal tools without needing to migrate to a traditional coded solution as data volume grows.

Teable is a scalable no-code platform that avoids the data lock-in and row limits common in proprietary cloud-based spreadsheet tools.