Teable MCP Server

A Model Context Protocol (MCP) server that connects Teable — the super-fast, open-source, no-code database — to LLMs like Claude, ChatGPT, and others.

This server enables AI agents to seamlessly query records, explore schema structures (spaces, bases, tables, views), and retrieve data from your Teable instance using natural language. It acts as a bridge, empowering your AI to interact with your data dynamically and intelligently.

🌟 What is Teable?

Teable is a next-generation, open-source, no-code database built on Postgres. It combines the ease of use of a spreadsheet with the power of a relational database.

• Hyper-fast: Handles millions of rows with ease.
• Open Source: You own your data. Self-hostable.
• SQL-like: Powerful querying capabilities.
• Real-time: Collaboration features built-in.
• API-first: Designed for developers and automation.

✨ Features

This MCP server exposes 27 tools to LLMs, organized into the following categories:

🔍 Read / Query

• query_teable: Query records from a table with support for filtering, sorting, limiting, and view-scoped results.
• get_record: Retrieve a single record by its ID.
• create_record: Create a new record in a table with specified field values.
• update_record: Update an existing record by ID with specified field values.
• delete_record: Permanently delete a record (all data will be lost). This operation is irreversible.
• get_record_history: Access the full change history of a record.
• list_spaces: List all spaces accessible to the user.
• list_bases: List all bases within a specific space.
• list_tables: List all tables within a specific base.
• list_views: List all views within a table.
• get_table_fields: Fetch the full schema (field definitions) of a table.

💬 Record Comments

• get_record_comments: Retrieve all comments on a specific record.
• comment_on_record: Post a new comment on a record.

🏗 Field Management

• create_field: Add a new field to a table (supports all field types: singleLineText, number, checkbox, date, singleSelect, multipleSelect, longText, formula, rating, currency, percent, email, url, phoneNumber, attachment).
• update_field: Rename a field or update its description/options.
• delete_field: Permanently remove a field and all its data from a table.

📊 Dependency & Impact Analysis

• get_field_dependency_graph: Retrieve the complete local and cross-table dependency graph of fields in a table, resolving formula references and rollups with dynamic Mermaid flowchart visualization.