https://github.com/teableio/teable Skip to content Toggle navigation Sign in * Product + Actions Automate any workflow + Packages Host and manage packages + Security Find and fix vulnerabilities + Codespaces Instant dev environments + Copilot Write better code with AI + Code review Manage code changes + Issues Plan and track work + Discussions Collaborate outside of code Explore + All features + Documentation + GitHub Skills + Blog * Solutions For + Enterprise + Teams + Startups + Education By Solution + CI/CD & Automation + DevOps + DevSecOps Resources + Learning Pathways + White papers, Ebooks, Webinars + Customer Stories + Partners * Open Source + GitHub Sponsors Fund open source developers + The ReadME Project GitHub community articles Repositories + Topics + Trending + Collections * Pricing Search or jump to... Search code, repositories, users, issues, pull requests... Search [ ] Clear Search syntax tips Provide feedback We read every piece of feedback, and take your input very seriously. [ ] [ ] Include my email address so I can be contacted Cancel Submit feedback Saved searches Use saved searches to filter your results more quickly Name [ ] Query [ ] To see all available qualifiers, see our documentation. Cancel Create saved search Sign in Sign up You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert {{ message }} teableio / teable Public * * Notifications * Fork 9 * Star 489 * A Super fast, Real-time, Professional, Developer friendly, No code database teable.io License AGPL-3.0 license 489 stars 9 forks Branches Tags Activity Star Notifications * Code * Issues 1 * Pull requests 1 * Discussions * Actions * Projects 0 * Security * Insights Additional navigation options * Code * Issues * Pull requests * Discussions * Actions * Projects * Security * Insights teableio/teable This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. develop BranchesTags Go to file Code Folders and files Last commit Last Name Name message commit date Latest commit History 671 Commits .changeset .changeset .github .github .husky .husky .idea .idea .vscode .vscode apps apps dockers dockers packages packages scripts scripts static/assets static/assets .codeclimate.yml .codeclimate.yml .dockerignore .dockerignore .gitattributes .gitattributes .gitignore .gitignore .gitpod.yml .gitpod.yml .ncurc.yml .ncurc.yml .npmrc .npmrc .nvmrc .nvmrc .prettierignore .prettierignore .prettierrc.js .prettierrc.js CODE_OF_CONDUCT.md CODE_OF_CONDUCT.md CONTRIBUTING.md CONTRIBUTING.md LICENSE LICENSE Makefile Makefile README.md README.md commitlint.config.js commitlint.config.js docker-bake.hcl docker-bake.hcl lint-staged.common.js lint-staged.common.js lint-staged.config.js lint-staged.config.js monorepo.code-workspace monorepo.code-workspace package.json package.json pnpm-lock.yaml pnpm-lock.yaml pnpm-workspace.yaml pnpm-workspace.yaml renovate.json5 renovate.json5 tsconfig.base.json tsconfig.base.json View all files Repository files navigation * README * Code of conduct * AGPL-3.0 license teable logo Postgres-Airtable Fusion Teable is a Super fast, Real-time, Professional, Developer friendly, No-code database built on Postgres. It uses a simple, spreadsheet-like interface to create complex enterprise-level database applications. Unlock efficient app development with no-code, free from the hurdles of data security and scalability. Home | Help | Blog | Template | Roadmap | Discord build Codefactor Maintainability Techdebt Codacy grade GitHub top language Licence teable interface Quick Guide 1. Looking for a quick experience? Select a scenario from the template center and click "Use this template". 2. Seeking high performance? Try the 1 million rows demo to feel the speed of Teable. 3. Want to learn to use it quickly? Click on this tutorial 4. Interested in deploying it yourself? Click Deploy on Railway Features Spreadsheet-like interface All you want is here * Cell Editing: Directly click and edit content within cells. * Formula Support: Input mathematical and logical formulas to auto-calculate values. * Data Sorting and Filtering: Sort data based on a column or multiple columns; use filters to view specific rows of data. * Aggregation Function: Automatically summarize statistics for each column, providing instant calculations like sum, average, count, max, and min for streamlined data analysis. * Data Formatting: formatting numbers, dates, etc. * Grouping: Organize rows into collapsible groups based on column values for easier data analysis and navigation. * Freeze Columns: Freeze the left column of the table so they remain visible while scrolling. * Import/Export Capabilities: Import and export data from other formats, e.g., .csv, .xlsx. * Row Styling & Conditional Formatting: Change row styles automatically based on specific conditions. (coming soon) * Charts & Visualization Tools: Create charts from table data such as bar charts, pie charts, line graphs, etc. (coming soon) * Data Validation: Limit or validate data that are entered into cells. (coming soon) * Undo/Redo: Undo or redo recent changes. (coming soon) * Comments & Annotations: Attach comments to rows, providing explanations or feedback for other users. (coming soon) * Find & Replace: Search content within the table and replace it with new content. (coming soon) [?] Multiple Views Visualize and interact with data in various ways best suited for their specific tasks. * Grid View: The default view of the table, which displays data in a spreadsheet-like format. * Form View: Input data in a form format, which is useful for collecting data. * Kanban View: Displays data in a Kanban board, which is a visual representation of data in columns and cards. (coming soon) * Calendar View: Displays data in a calendar format, which is useful for tracking dates and events. (coming soon) * Gallery View: Displays data in a gallery format, which is useful for displaying images and other media. (coming soon) * Gantt View: Displays data in a Gantt chart, which is useful for tracking project schedules. (coming soon) * Timeline View: Displays data in a timeline format, which is useful for tracking events over time. (coming soon) Super Fast Amazing response speed and data capacity * Millions of data are easily processed, and there is no pressure to filter and sort * Automatic database indexing for maximum speed * Supports batch data operations at one time Full-featured SQL Support Seamless integration with the software you are familiar with * BI tools like Metabase PowerBi... * No-code tools like Appsmith... * Direct retrieve data with native SQL Privacy-First You own your data, in spite of the cloud * Bring your own database (coming soon) [?][?] Real-time collaboration Designed for teams * No need to refresh the page, data is updated in real-time * Seamlessly integrate collaboration member invitation and management * Perfect permission management mechanism, from table to column level Extensions (coming soon) Expand infinite possibilities * Backend-less programming capability based on React * Customize your own application with extremely low cost * Extremely easy-to-use script extensions mode Automation (coming soon) Empower data-driven workflows effortlessly and seamlessly * Design your workflow with AI or Visual programming * Super easy to retrieve data from the table Copilot (coming soon) Native Integrated AI ability * Chat 2 App. "Create a project management app for me" * Chat 2 Chart. "Analyze the data in the order table using a bar chart" * Chat 2 View. "I want to see the schedule for the past week and only display participants" * Chat 2 Action. "After the order is paid and completed, an email notification will be sent to the customer" * More actions... [?] Support for multiple databases (coming soon) Choose the SQL database you like * Sqlite, PostgreSQL, MySQL, MariaDB, TiDB... --------------------------------------------------------------------- Structure Open in Gitpod . +-- apps | +-- electron (desktop, include a electron app ) | +-- nextjs-app (front-end, include a nextjs app) | +-- nestjs-backend (backend, running on server or inside electron app) +-- packages +-- common-i18n (locales) +-- core (share code and interface) +-- sdk (sdk for extensions) +-- db-main-prisma (schema, migrations, prisma client) +-- eslint-config-bases (to shared eslint configs) +-- ui-lib (ui component) Deploy Deploy with docker cd dockers/examples/standalone/ docker-compose up -d for more details, see dockers/examples Deploy with Railway Deploy on Railway Development 1. Initialize # Use `.nvmrc` file to specify node version(Requires pre `nvm` tools) nvm install && nvm use # Enabling the Help Management Package Manager corepack enable # Install project dependencies pnpm install # Build packages pnpm g:build 2. Select Database we currently support sqlite and postgres, you can switch between them by running the following command make switch-db-mode 3. Custom environment variables(optional) cd apps/nextjs-app copy .env.development .env.development.local 4. Run dev server you just need to start backend, it will start next server for frontend automatically, file change will be auto reload cd apps/nestjs-backend pnpm dev Why Teable? No-code tools have significantly speed up how we get things done, allowing non-tech users to build amazing apps and changing the way many work and live. People like using spreadsheet-like UI to handle their data because it's easy, flexible, and great for team collaboration. They also prefer designing their app screens without being stuck with clunky templates. Giving non-techy people the ability to create their software sounds exciting. But that's just the start: * As businesses expand, their data needs intensify. No one wishes to hear that once their orders reach 100k, they'll outgrow their current interface. Yet, many no-code platforms falter at such scales. * Most no-code platforms are cloud-based. This means your important data sits with the provider, and switching to another platform can be a headache. * Sometimes, no-code tools can't do what you want because of their limitations, leaving users stuck. * If a tool becomes essential, you'll eventually need some tech expertise. But developers often find these platforms tricky. * Maintaining systems with complex setups can be hard for developers, especially if these aren't built using common software standards. * Systems that don't use these standards might need revamping or replacing, costing more in the long run. It might even mean ditching the no-code route and going back to traditional coding. What we think the future of no-code products look like * An interface that anyone can use to build applications easily. * Easy access to data, letting users grab, move, and reuse their information as they wish. * Data privacy and choice, whether that's in the cloud, on-premise, or even just on your local. * It needs to work for developers too, not just non-tech users. * It should handle lots of data, so it can grow with your business. * Flexibility to integrate with other software, combining strengths to get the job done. * Last, native AI integration to takes usability to the next level. In essence, Teable isn't just another no-code solution, it's a comprehensive answer to the evolving demands of modern software development, ensuring that everyone, regardless of their technical proficiency, has a platform tailored to their needs. Sponsors [?] If you are enjoying some this project in your company, I'd really appreciate a sponsorship, a coffee or a dropped star. That gives me some more time to improve it to the next level. License AGPL-3.0 About A Super fast, Real-time, Professional, Developer friendly, No code database teable.io Topics postgres database sqlite realtime postgresql spreadsheet airtable low-code no-code nocode airtable-alternative Resources Readme License AGPL-3.0 license Code of conduct Code of conduct Activity Custom properties Stars 489 stars Watchers 4 watching Forks 9 forks Report repository Releases 1 tags Sponsor this project * ko_fi ko-fi.com/teable Packages 1 Contributors 6 * @tea-artist * @boris-w * @Sky-FE * @caoxing9 * @Pengap * @greattoymaker Languages * TypeScript 95.9% * JavaScript 2.8% * Handlebars 0.3% * ANTLR 0.3% * Makefile 0.3% * Shell 0.2% * Other 0.2% Footer (c) 2024 GitHub, Inc. Footer navigation * Terms * Privacy * Security * Status * Docs * Contact * Manage cookies * Do not share my personal information You can't perform that action at this time.