Teable is a next-generation no-code database platform that replaces Airtable with a PostgreSQL-powered backend, offering a familiar spreadsheet interface for non-technical users while supporting enterprise-scale data handling. It’s designed for teams needing to turn raw data into structured apps, dashboards, and workflows without writing code, while retaining full control over data through self-hosting options.
Built with TypeScript and Node.js, Teable uses a monorepo architecture with Next.js for the frontend, NestJS for the backend, and Prisma for database operations. It supports PostgreSQL and SQLite (for development), offers real-time collaboration via WebSockets, and provides plugins and a public API for extensibility. Deployment options include Docker, Railway, Zeabur, and Alibaba Cloud ComputeNest.
What You Get
- Real-time Collaboration - Multiple users can edit records simultaneously with live updates, comments, and history tracking, similar to Google Sheets but with database power.
- Multiple Data Views - Visualize data in Grid, Form, Kanban, Gallery, and Calendar views to suit different workflows without switching tools.
- AI-Powered Data Actions - Use natural language to generate apps, automate workflows, analyze data, migrate databases, and batch-generate images or copy via integrated AI agent.
- SQL Query & Field Formulas - Write raw SQL queries directly and use formula fields with functions like SUM, IF, and CONCAT to derive values dynamically.
- Custom Plugins & SDK - Extend functionality with custom plugins using the provided SDK, enabling integration with external services or custom UI components.
- Self-Hosting & Data Control - Deploy on-premise or in private clouds using Docker or one-click deployers (Railway, Zeabur, etc.) with full ownership of data and ISO27001-compliant security.
- Batch Editing & Import/Export - Edit multiple rows at once and import/export data in CSV, JSON, and Excel formats for seamless data migration.
- Advanced Field Types & Validation - Support for text, number, date, attachment, checkbox, single/multi-select, formula, and AI fields with customizable validation rules.
- Charting & Dashboard Builder - Create visual charts and dashboards from your data using the built-in app builder to turn tables into interactive reports.
- Undo/Redo & Record History - Track every change to records with full audit trails and the ability to revert to previous states.
Common Use Cases
- Running a marketing campaign tracker - A marketing team uses Teable to manage campaign assets, track ROI, and auto-generate social copy and images using AI, all in a shared, view-customizable database.
- Building an internal CRM without developers - A small sales team creates a custom CRM with Kanban views for deals, form views for intake, and AI-powered lead scoring—all without writing a line of code.
- Managing product roadmaps at scale - A product manager uses Teable’s 1M+ row capacity and calendar view to track feature releases, dependencies, and team assignments across hundreds of tickets.
- Migrating legacy spreadsheets into structured apps - An operations team converts hundreds of Excel files into Teable databases with AI-assisted schema mapping and automated field creation.
Under The Hood
Architecture
- Monorepo structure with clear separation of apps, packages, and plugins, enabling independent development and versioning of core modules
- Dependency injection via modular service providers and abstract interfaces promotes testability and backend flexibility
- Layered backend architecture decouples API layers from data access, with consistent validation and error handling patterns
- Domain-driven design isolates concerns like caching, authentication, and internationalization with shared contracts
- Build and test workflows are unified across subprojects using workspace-based tooling and strict file exclusion rules
- Strong TypeScript typing and modular configuration ensure type safety and developer consistency throughout the stack
Tech Stack
- NestJS backend with TypeScript, leveraging modular services, configuration management, and job queues for async workflows
- Multi-database support through Prisma and Knex with environment-aware migrations and PostgreSQL/SQLite backends
- Next.js frontend with OpenAPI type generation and strict TypeScript mode enforced across the monorepo
- Comprehensive monorepo tooling with pnpm, shared ESLint/Prettier configs, and consistent linting practices
- AI/ML integrations via industry-standard LLM libraries and AWS SDK for storage, with Keyv for flexible caching
- CI/CD and development automation powered by Docker, Makefile orchestration, Husky hooks, and Gitpod for instant setup
Code Quality
- Extensive test coverage across unit, integration, and e2e layers with robust validation of data transformations and schema mutations
- Strong type safety enforced through Zod schemas and TypeScript interfaces, with user-friendly error transformation pipelines
- Clear separation of domain logic, API layers, and test utilities enhances maintainability and testability
- Consistent naming, modular structure, and domain-specific test helpers ensure codebase coherence
- Structured error handling with explicit failure paths, though custom error classes are underutilized
- Comprehensive linting and fixture-based test isolation ensure reliability and repeatability
What Makes It Unique
- Native support for dynamic field relationships with real-time visibility and filtering controls, eliminating external dependencies
- Handlebars-based email templating with dynamic partials and conditional rendering, removing reliance on third-party email platforms
- Unified React SDK with composable field components that abstract API complexity while enabling deep extensibility
- Embedded SVG icon system with theming consistency across frontend and backend, preserving design-system integrity
- Tight coupling of client-side UI state with server-side query optimization via Prisma/Knex, enabling intelligent data fetching
- Custom Zod validation pipeline integrated into NestJS middleware for declarative, type-safe schema enforcement across all endpoints