LoginSign Up
← Back to all sparks
T

Teable

COLLAB
Velocity7.5

Open-source no-code database and Airtable alternative

teable.io ↗

Teable's Structured Query v2 now reports across multi-hop relations, with a strict mode against SQL.

no-code-databaseai-agentsmcpstructured-queriesadmin-tooling
◆Current state
Teable ships near-daily. The October 27 release extends Structured Query v2 to same-project relational reporting across one-to-many, many-to-many and up to three-hop relations, with aggregates, grouping and permissions checked at every hop; new SQL-based query definitions now get warnings, with an optional strict mode that rejects them. The same release adds atomic record upsert on a unique field, a Table Operations console for admins, an Artifact Manager, and paginated base listing over MCP and CLI.
◆Where it's heading
Since the chat-first preview on October 21, each release has moved more of the product onto structured queries that agents can use safely, and away from raw SQL. Admin and integration tooling (upsert, complexity assessment, MCP pagination) is now arriving to support larger workspaces built this way.
◆Prediction
Expect strict mode to tighten toward a default and the remaining query gaps, such as cross-project relations and sorting by to-many fields, to close next.

◆Recent moves

  1. 2d ago

    Multi-hop Structured Queries, SQL strict mode, atomic upsert

    Structured Query v2 gains multi-hop relational reporting with per-hop permissions, and a strict mode can now reject new SQL-based queries, pushing further from raw SQL. Atomic upsert, an Artifact Manager and a Table Operations console fill in integration and admin gaps.

    View source ↗
  2. 6d ago

    Structured Query V2 lookups, form pre-fill, AI-guided routines

    Structured Query V2 adds lookups through to-one links, new apps default to structured queries, forms accept URL pre-fill, and routines are created through a guided AI conversation. It extends the chat-first preview with safer, permission-aware data access.

    View source ↗
  3. 7d ago

    queries.yaml for apps, routines page, Cmd+K command palette

    New apps declare queries in queries.yaml, routines get a page with run history, and a Cmd+K palette adds natural-language questions. It moves App Builder off raw SQL and makes routines manageable.

    View source ↗
  4. 8d ago

    Query dependencies via CLI/MCP and schema impact analysis

    Chat-first workspaces open straight into the project conversation, query dependencies are available via CLI and MCP, and field-level impact analysis shows which apps a schema change will break. Governance tooling for agent-built apps.

    View source ↗
  5. 8d ago

    Chat-first workspace preview, named queries, data-retention controls

    ⚡ SPARK

    The chat-first workspace extends the week's agent push from outside clients (MCP) to Teable's own front door. Named queries and the query debugger give those conversations and apps a stable read layer, and retention controls add the governance that larger accounts need.

    View source ↗
  6. 13d ago

    Official MCP server with OAuth for Claude Code, Codex and Cursor

    ⚡ SPARK

    The official MCP server is the outward-facing step after a week of internal agent plumbing: external coding agents can now list, query and edit Teable data within user permissions. It turns Teable from an app with built-in AI into a data source other agents call.

    View source ↗