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-11-10T05-38-53Z.3830

Feature Updates

• Filter-based updates apply the same values to all matching records and evaluate filter conditions when the update runs. Updates that also require changes to relationships must still use record-based updates.
• JWT credentials can now be searched by app or project name or ID. Bulk operations are limited to apps that match the current search and filters.
• Published apps can now be refreshed with new credentials while retaining their last published code and login configuration. Apps with expired production credentials are now distinguished from apps whose refresh failed.
• Default Pi sessions now support structured queries for record lists, aggregations, and time-based grouping. Follow-up requests can adjust query parameters, and unsupported requests return clearer error messages.

Bug Fixes & Improvements

• Password changes now reject a new password that matches the current password, preventing misleading success messages and unnecessary sign-outs.
• Refreshing the chat page no longer restores tabs for tables hidden by role permission updates, preventing incorrect resource access restriction and “Table deleted” messages.
• Locked Grid views now prevent column dragging, column resizing, and column freezing. Personal views remain editable.
• Automations enabled by newly installed templates now correctly activate scheduled triggers and email receipt triggers.
• Fixed an issue where pasted text beginning with lowercase “rec” (such as “recipe” or “record”) was saved incorrectly in Single line text fields. Large-batch and streaming paste operations now also preserve text consistently; previously corrupted values will not be restored automatically.
• Improved the security and reliability of credential settings, management, sharing, and permanent deletion.
• Improved resource title bars, toolbar labels, and view lists to make actions and current, starred, locked, and draggable states easier to distinguish.
• Sharing and CSV export operations now apply to the selected view rather than the currently open view, including operations initiated from classic view tabs.
• Consolidated app settings actions and improved menu behavior for login configuration, GitHub integration, and version history.
• Fixed missing view information when creating, converting, changing the linked target of, or removing two-way linked record fields. Reciprocal linked fields now maintain consistent visibility and ordering, with improved reliability for self-links, linked tables, and undo/redo.
• The hidden and visible field panels now support reliable drag-and-drop reordering, with the order preserved after refreshing. Fixed a crash caused by reordering fields in Grid and Kanban views before view information had finished loading.

⁠release.2026-11-06T11-23-32Z.3804

Bug Fixes & Improvements

• Improved the security of key management.

⁠release.2026-11-06T08-34-24Z.3803

Feature Updates

• Added the read-only MCP query-data tool for structured record retrieval, filtering, pagination, aggregation, grouping, and bucketing without SQL. Queries follow existing access controls, and unsupported capabilities return explicit errors. The behavior of the existing sql-query and get-records tools remains unchanged.
• Mobile home page search now supports finding chats by title and message content, displays matching snippets, and sorts results by most recent activity. Selecting a matching message opens the conversation at that message and highlights the search terms. Matching older messages in the chat history is also supported.

Bug Fixes & Improvements

• Search index maintenance now provides persistent task status, controlled retries, and more accurate progress and failure reporting. Stalled queued tasks can be canceled without affecting running or unrelated tasks. The existing usable search index is preserved if replacement fails.
• Enhanced security for credentials, configurations, applications, automations, and administrative access.

⁠release.2026-11-06T03-08-47Z.3797

Feature Updates

• DATETIME_DIFF with day or days now returns the number of whole elapsed days truncated toward zero and uses the formula’s time zone to avoid one-day discrepancies caused by daylight saving time transitions. To retain fractional results in existing formulas, set the fourth argument to TRUE.

Bug Fixes & Improvements

• Improved date handling when copying content across time zones and when creating or installing templates, preserving calendar dates and local clock times. Fields with missing, empty, or unrecognized source time zones retain their stored values, and equivalent time zone aliases no longer trigger conversion. Hardcoded time zones in App Builder code are not updated automatically.
• Fixed an issue where previously saved app versions that use named queries could fail to publish after an upgrade.
• Fixed an issue where template previews could remain in a loading state after failing. Preview failures now provide actionable error details and allow retries.
• New chats created alongside open resources now persist after a page reload, including unsent drafts. Project navigation no longer reopens the previous conversation.
• In conversation-focused layouts, new chats now consistently display the full welcome screen and project bar at all supported column widths.

⁠release.2026-11-05T12-40-53Z.3790

Feature Updates

• Formulas created through the CLI and AI now use the time zones of the date fields they reference, ensuring accurate calculations for TODAY(), countdowns, and similar operations. Explicitly configured formula time zones still take precedence.
• Lookup and rollup fields created through the CLI and AI can now resolve linked tables and fields by name, including fields not previously loaded, and infer the correct type when no lookup type is specified. If a target field is missing, a clear error is now provided before any changes are made.

Bug Fixes & Improvements

• Fixed an issue where template previews could remain stuck on “Thinking deeply…” and improved template deployment error messages with specific operation details for detection and retries.
• Improved search count performance for wide tables while preserving accurate results, filters, permissions, hidden fields, and field-level search conditions.
• Unified time zone handling when creating formulas, fields, and tables to avoid setting unnecessary time zones for non-date formulas.

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