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-02T04-02-20Z.3278

Feature Updates

• iOS sign-in now requires an existing Teable account and a server version that supports browser-based mobile authentication. Account creation through the iOS sign-in flow and sign-in to older, unsupported servers are no longer available.
• The mobile app now requests AI data-processing consent before sign-in, with consent applying separately to each server. Users are prompted on launch if they have not accepted the current consent version; declining signs them out.

Bug Fixes & Improvements

• Fixed conditional lookups returning unrelated records when matching fields are empty, and improved comparison consistency between single-value and multi-value fields. Results may change for filters that previously relied on empty values matching each other.

⁠release.2026-09-30T04-47-05Z.3276

Feature Updates

Bug Fixes & Improvements

• Fixed a failure when duplicating Bases with link fields containing previously tolerated references.
• Improved link fields so repeated linked records are saved only once, and fixed cases where duplicate links could prevent links, lookups, and rollups from updating.

⁠release.2026-09-27T02-14-26Z.3273

Feature Updates

• “Contact Support” in the web user menu and mobile settings now opens a Teable Community feedback form instead of the previous anonymous form. Users can submit feature requests and issue reports to the Teable team publicly or privately.
• Users can request a data export before deleting their account or permanently deleting a space from the recycle bin. The export includes CSV data, app packages, and record attachments in a downloadable archive, with a download link sent by email. Administrators can also request and send an export link when deactivating or deleting a user.

Bug Fixes & Improvements

• Improved export completeness and reliability: account exports now include spaces owned by the user that have been moved to the recycle bin; archives have a clearly defined root folder; missing attachments are reported without stopping the export; and failed app package downloads are retried. Export emails use the recipient’s language.
• Fixed export confirmation prompts and success messages in the admin interface. The confirmation prompt now appears only after an export request is accepted. The self-service export quota message now correctly states “5 exports within 24 hours”; the limit has not changed.
• Fixed retry behavior when loading more execution records fails while offline. Users can continue loading after reconnecting without duplicate entries or unstable retries.
• Improved the reliability of login and publish status after startup or a connection interruption.

⁠release.2026-09-25T09-38-50Z.3268

Feature Updates

• OAuth apps can send in-app notifications with user consent. Users can mute individual apps, and revoking authorization stops their notifications.
• OAuth apps can request access to paid-plan and active self-hosted license information. Consent is required for newly requested permissions, so forum users may need to sign in or authorize again for badges and notifications to work.
• Audit logs now cover more security and administration actions, including membership and role changes, sign-in failures, account changes, and OAuth app activity.
• Password-protected shares now generate a password when protection is enabled. Share owners can edit or regenerate it in the share panel and copy the link and password together. For artifact shares, the password is masked after the panel is reopened; change it to copy a usable password again.
• App Builder recognizes GitHub-linked repositories without requiring a separate personal authorization and offers a direct “Merge on GitHub” option for sync conflicts.
• Scrape triggers now reserve estimated credits before starting, use the latest balance, and release reserved credits when setup or a job fails. The public scrape parameter limit is now limitPerInput; integrations, CLI usage, and agent tools must update.

Bug Fixes & Improvements

• OAuth connection popups now show authorization progress and confirm success before closing. Failed or declined requests remain visible with a reason and Close button. The popup also respects dark mode and reduced-motion preferences.
• Editing AI field prompts with blank lines, Backspace, or arrow keys no longer turns referenced field tags into plain text.
• Paid-space information shared with authorized OAuth apps now follows organization and space billing rules more accurately.
• Notification delivery has been strengthened so users receive only their own notifications.
• Deactivated accounts are now consistently prevented from continuing sessions, AI usage, app generation, and background work. Users must sign in again after reactivation.

⁠release.2026-09-25T04-01-19Z.3254

Feature Updates

• Administrators can pause new AI sandbox sessions during maintenance, with an optional notification, while allowing existing conversations to finish. When the service is unavailable, affected AI features show a clear notice before users submit requests.
• Agents can select a model tier when creating or updating scheduled tasks. Existing selections are retained unless explicitly changed, and subsequent messages use the selected tier.
• Event-triggered scheduled task chats receive titles that reflect the triggering event without overwriting titles edited by users. Run details also show why a scheduled task started.
• Sign-in protection is now enabled by default and locks accounts after consecutive failed sign-in attempts. Administrators who do not want account lockout must explicitly set SIGNIN_ACCOUNT_LOCKOUT_ENABLED=false.
• Free workspaces now receive a one-time welcome award of 200 credits instead of 200 credits each month. Existing free workspaces receive the one-time award, while new accounts receive it for their automatically created workspace.
• After a Business plan expires, custom domains remain available during a one-week grace period. Owners are notified when the plan expires and when domain resolution is disabled; renewing during the grace period keeps the domain available.

Bug Fixes & Improvements

• Fixed an issue where chained calculation formulas failed when blank text results were treated as numbers. Blank text now remains blank instead of becoming 0.
• Comments on deleted records are no longer accessible. When a record is permanently deleted, its comments and subscriptions are also removed.
• Shared grid views and expanded record cards now show all visible fields, including columns that have not yet been scrolled into view.
• Fixed an issue with Base editing permissions when a user's space role outranked their department's Base role. Record visibility and field permissions are also more consistent in wide tables with multiple permission roles.
• Search results for users with multiple permission roles now respect both the search term and row-level permissions. For large tables, searches may pause if there is no safe scan path or usable index, until a table administrator configures searchable fields.
• Fixed inconsistent display of large numbers in cells, record details, copied values, and API results. Small Number and Percentage fields now preserve visible digits beyond JavaScript's safe integer range.
• Summary fields now recalculate for both the original and new linked records when relationships change. Refreshes of dependent fields are also more reliable after relationship conversions.
• Improved manual row ordering in large grids, including during concurrent changes and when records are restored. Creating or copying a view no longer performs unnecessary full-table sorting, and copied tables retain correct sorting behavior.
• Fixed an issue where a table could be hidden but not deleted after deletion failed, and improved recovery when deletion fails partway through.
• Fixed an issue where moving and reordering tables in the sidebar did not persist after a refresh. Failed table entries that cannot be used no longer appear in the sidebar; import errors remain visible in the import flow.
• Fixed an issue where statistics in nested grouped views could remain stuck, particularly when using date-based formula fields. Changing a field's summary method no longer causes unrelated results to flicker.
• Fixed an issue where linked records with titles briefly appeared as “Untitled” in linked-record cells after bulk updates.
• Improved the reliability of large CSV and Excel imports, reducing import failures and temporary errors in related requests.
• Fixed blank thumbnails for SVG attachments in grid views.
• Improved AI chat queue visibility, message ordering, and recovery after refreshes or reconnections. Queued messages immediately show a pending status and are removed if rejected.
• AI conversations render more smoothly during streaming. Base and space pages load certain previews and selectors only when needed, improving load speed.
• Improved AI field autofill performance during large batch operations and fixed generation failures for some existing fields using space-level custom providers.
• Improved App Builder recovery after preview restoration fails or a workspace becomes unavailable, reducing the likelihood of imports and publishing remaining blocked.
• BYODB space usage and row-limit checks now use real-time row counts, reducing inaccurate totals and incorrect quota decisions.
• The organization user API now returns only the departments to which the specified user belongs. Integrations that need all departments should use the dedicated department list API.
• Improved account, license, integration, and sign-in security. Adding a space already linked to an organization no longer returns an unnecessary error.

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