teableio/teable repository overview

⁠✨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...

⁠What's New

⁠release.2026-10-30T02-25-28Z.3658

Feature Updates

• Improved the resource pane with resizable lists, full-name tooltips for truncated items, quick access to open tabs when collapsed, and keyboard navigation.

Bug Fixes & Improvements

• Unread email reminders now apply only to Chat tasks that run for at least 10 minutes and remain unread for 30 minutes after completion, whether successful or failed. Emails identify the task by its prompt and link directly to the relevant project and conversation.
• Prevented duplicate conversations in the new layout while preserving normal conversation creation and retries after failed attempts.
• Archiving or deleting the active conversation now immediately opens a new conversation. Archived conversations can be restored with Undo if you have not navigated elsewhere.
• Stabilized the resource pane layout when switching between Resources and Artifacts.
• Reduced repeated sidebar tooltips with a short delay and kept them hidden while a conversation’s context menu is open.

⁠release.2026-10-29T13-13-24Z.3656

Feature Updates

• Redesigned the Template Center with industry and team browsing, responsive layouts, Featured and Newest views, direct install links, and AI-assisted recommendations.
• Editable projects can now be submitted as versioned templates, with snapshots, author notifications, and version history.
• Templates can be installed from the catalog, shared links, and conversation cards, with guided account connection and automation setup. Dedicated views organize installed apps, automations, and data.
• CLI users can now search, install, inspect, and submit templates. Template upgrades and rollback are not included in this release.
• An optional creator program adds creator profiles, revenue sharing, and settlement workflows. It remains disabled by default.
• Added consistent overlay scrollbars that appear during scrolling, support dragging, and fade when idle without taking up layout space. Mouse-wheel, horizontal, and nested scrolling remain accessible.

Bug Fixes & Improvements

• Improved security and reliability for linked records and data imports.
• Improved MCP connector compatibility.
• Improved initial page loading and in-app navigation, especially for non-English users and mobile WebViews, while preserving translation accuracy across supported languages.
• Fixed publish selection so selecting or clearing a folder updates all eligible descendants, including collapsed and search-hidden items. Partially selected folders now display correctly and are excluded from publishing, and cleared selections remain cleared after refreshing or reopening the selector.

⁠release.2026-10-27T02-17-21Z.3593

Feature Updates

• Added a unified Table Operations console for search and indexes, complexity assessment, schema integrity, and computed updates. Existing admin links retain their parameters.
• Instance administrators can assess table complexity without joining the project, including dependencies, workload estimates, field-level breakdowns, and estimate quality, without exposing record contents.
• MCP and CLI list-bases now support pagination and filtering by base name or space. Results default to 50 bases per page, with a maximum of 100; clients must follow nextOffset while hasMore is true.
• Streamlined personal settings into seven entries grouped under Account, Preferences, and a tabbed Developer Tools section. Existing links remain compatible.
• Added an Artifact Manager with a paginated, project-grouped view of accessible artifacts, share status, downloads, and direct access to the in-app viewer.
• “Fix with AI” now opens a new chat in the artifact’s project with the relevant context attached.
• Feishu IM bots can reuse skills already installed and enabled in the project space, keeping shared skills consistent without duplicate installation.
• Structured Query v2 now supports same-project relational reporting across one-to-one, one-to-many, many-to-many, and multi-hop relations, with related-record aggregates, filtering, grouping, sorting, timezone-aware calculations, and grouped totals. Permissions apply at every hop, and missing targets return null. Cross-project relations, cyclic paths, paths beyond three hops, and direct projection or sorting of to-many fields remain unsupported; relation queries do not automatically fall back to SQL.
• Added validation warnings for new SQL-based query definitions and an optional strict mode that rejects them. Existing SQL fallbacks remain supported.
• Added atomic record upsert for v2 tables, allowing integrations to create, ignore, or update records using one unique text, number, or date field. Each row reports a created, updated, unchanged, or skipped result. Composite and non-unique match fields and share-view requests are unsupported.
• Added an experimental headless runtime with embedded PGlite or PostgreSQL, HTTP and command-line interfaces, computed fields, local attachments, persistent local storage, and validated app bundles for repeatable installation of base structures and seed data. It does not include authentication, permissions, a UI, remote realtime transport, browser-based bundle installation, or S3 attachments; PGlite storage supports a single writer.

Bug Fixes & Improvements

• Fixed saving, rollback, import, and duplication failures for apps whose generated query files came from an older host version. Failed saves and imports no longer leave apps in an unusable state, and imports preserve unrelated source files and binary assets.
• Query validation errors now identify the affected field, field type, rejected operator, and generator version when authorized.
• Stale table links now return a clear not-found response, and calculation update lists retain instance-wide results, statistics, and project filters.
• Large base listings now return valid, complete pages instead of oversized responses that could be truncated.
• Pages opened inside the mobile app now recognize cookie consent completed at sign-in, preventing the banner from reappearing or reopening through Cookie settings. External-browser behavior is unchanged.
• Improved artifact browsing and viewing, including project visibility, pagination, download error feedback, share-password handling, and transitions from dialogs to AI chats.
• Improved error messages across all 12 supported languages. Field renaming now explains duplicate or invalid database names and keeps the editor open for correction; custom domain verification and removal failures provide clearer reasons.
• Improved reliability and localized feedback for view updates, imports, record reordering, field time zones, and sidebar renaming.
• Task cards now retain their original titles while progress notes stream and remain visible until follow-up questions are ready.
• Improved Structured Query reliability for grouped reports, weighted averages, repeated relation paths, filters, timezone buckets, pagination, totals, and parameter validation.
• Improved BYODB reliability during concurrent computed writes, reducing server errors and prolonged delays under heavy load.
• Improved concurrent record updates involving type conversion, reducing unnecessary delays and timeouts while preserving consistent select options and coordination with field changes.
• Concurrent upserts using the same unique key now avoid duplicate records, partial updates, and auto-number gaps for skipped rows while respecting permissions and workspace row limits.
• Fixed linked-record copy-and-paste matching after changing the display column. Pasted values now use the selected display field; unmatched values remain unchanged and do not create linked records.
• Improved the reliability of large computed-field cascades and backfills during sustained concurrent updates.
• Improved security for authentication, form submissions, upserts, and application dependencies while preserving normal mobile sign-in behavior.

⁠release.2026-10-23T02-23-06Z.3549

Feature Updates

• Structured Query V2 now supports same-project, single-hop lookups through to-one Link fields, including related stored and system values. Each source’s permissions are respected, and missing linked records return null. Inverse relationships, multi-record relationships, cross-project queries, and related filtering, sorting, and aggregation are not supported; totals remain root-only, and relation queries no longer automatically fall back to SQL.
• Internal and shared forms now support URL-based pre-filling for visible text, number, and single-select fields. Pre-filled values remain editable, and hidden fields cannot be pre-filled.
• Added a Trash entry to the chat-first sidebar for easier recovery of deleted projects.
• New App Builder apps now use structured queries for single-table lists and aggregations, with SQL fallback for more complex queries. Query guidance follows each app’s configuration, while existing apps retain their current query workflow.
• Routine creation now opens a new AI conversation with guided prompts and five examples. The redesigned routine page brings together details, run history, and linked conversations, with controls for editors to continue chats and launch runs. Manual configuration becomes available after creation.

Bug Fixes & Improvements

• Improved AI response cancellation so immediate stop requests work reliably and delayed requests do not interrupt newer replies.
• Improved AI conversation reliability during long-running tools and response cleanup, preventing new messages from being rejected while the previous response is still finishing.
• Fixed repeated errors when opening, refocusing, or reconnecting a new AI chat before its first message is sent.
• Field creation now shows a loading state and prevents duplicate submissions until saving completes, including when saving through the unsaved-changes dialog.
• Improved the reliability of computed-field updates and imports interrupted by database connection issues.
• Fixed configured defaults not being applied to blank fields in records created through the grid’s add-record dialog. Previously populated fields can still be explicitly cleared.
• Share settings now reflect changes immediately and consistently preserve the latest selection during rapid permission updates.
• The chat-first sidebar now refreshes automatically when projects are moved, copied, imported, created from templates, or restored.
• Improved load times for synchronization run records.
• Automation Script nodes now run on Node.js 24 instead of Node.js 22. Review scripts that depend on Node.js 22-specific behavior or compatibility.
• Improved routine ownership, alerts, conversation visibility, unread status, and run history, including reliability when owners or permissions change. Editing controls are now hidden for members without update permission.

⁠release.2026-10-22T04-57-21Z.3531

Feature Updates

• New apps with structured queries enabled now use queries.yaml for supported record and aggregate queries, including filtering, sorting, pagination, and parameters. Unsupported query shapes are clearly rejected with alternatives, while existing apps retain their current SQL behavior.
• Routines now have a dedicated page for configuration and run history, with direct access to each run’s conversation. Editing includes autosave and next-run visibility, and ownership transfers to an eligible base or space owner when needed.
• The command palette, opened with Cmd+K on macOS or Ctrl+K on Windows, provides quick access to project resources and common actions. It supports keyboard navigation, recent items, permission-aware results, and natural-language questions through Cuppy.
• Structured sorting now supports explicit NULLS FIRST and NULLS LAST ordering for records and aggregate queries while preserving existing defaults.
• AI image generation and regeneration are no longer available for lookup, formula, or other computed attachment fields. Editable source attachment fields continue to support generation, and lookup attachments continue to display, preview, and synchronize normally.

Bug Fixes & Improvements

• Fixed an issue preventing Claude.ai and Claude Desktop custom connectors from connecting to Teable MCP. Existing connectors may need to be removed and added again.
• Fixed conditional rollups with multi-value filters so totals refresh correctly when source values change, including for newly created equivalent fields.
• Improved field deletion dependency checks to use the current version of each authorized App, reducing response time and ensuring results reflect current dependencies.
• Field deletion confirmations now identify referencing Apps and named queries, including the App, query, version, field, and usage. Queries with unresolved dependencies are marked as unknown, and checks remain advisory without changing queries or blocking deletion.
• Improved routine permissions and mobile behavior so read-only members can view routine details without restricted controls, and opened run chats are titled and marked as read correctly.

All releases: https://github.com/teableio/teable/releases⁠