• AGGREGATION
  • FILTERING
  • SCHEMA
  • HUMAN

How to run SQL queries on SeaTable with your AI

Connect your AI to SeaTable once. From then on, your agent handles the database work while you just ask questions.

Ask AI about this page

Short answer

Can I use my AI to run SQL on SeaTable?

Yes. Your agent uses the SeaTable MCP to inspect your tables and run SQL commands to filter or aggregate your data. You'll get precise answers to your questions through the following breakdown.

Data outcomes

What you get back

The results your agent pulls from your bases.

AGGREGATION

Summarized totals

The AI calculates sums, averages, or counts across your rows. You get a single number or a summary instead of a raw list.

FILTERING

Specific row sets

Your agent pulls only the records that match your criteria. This lets you isolate exactly what you need from a large base.

SCHEMA

Table structure

The AI identifies which tables and columns exist in your base. This ensures the queries it writes actually work.

HUMAN

Manual verification

You check the results to make sure the logic is right. The AI provides the data, but you decide if it's what you wanted.

The workflow

What your AI does when the request arrives.

Your agent translates your English into database actions.

  1. Map the base

    The agent looks at your SeaTable structure to find the right tables and columns for your question.

    list_tableslist_columns

  2. Write the SQL

    Your AI converts your plain English request into a valid SQL statement.

    query_sql

  3. Run the command

    The agent executes the command against your SeaTable base to pull the data.

    query_sql

  4. Present results

    The AI takes the raw data and shows it to you in a readable format.

    query_sql

Try it

Copy these to start.

Paste these into your chat to test the connection.

Starting points

Swap out the names in quotes for your actual SeaTable table or column names.

SeaTable Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_EcrX5RuTBwMiiV5mY6fQqN7e2NIAfxegGUxfqa1y/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — SeaTable capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "seatable-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_EcrX5RuTBwMiiV5mY6fQqN7e2NIAfxegGUxfqa1y/mcp"
    }
  }
}
Copy into chat04

  • Show me all rows in the 'Orders' table where 'Status' is 'Shipped'.

  • What is the total sum of the 'Price' column in my 'Inventory' table?

  • List all the columns in the 'Customer_List' table.

  • Find the average value in the 'Sales' column for the 'North' region.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect SeaTable once, then ask.

Connect your account in one click. Your login stays encrypted on our side, and the full walkthrough lives on the Connector page.

Connect SeaTable to your AI

FAQ

How this task behaves

  • 01

    Can the AI delete my data?

    No. The tools only allow the AI to read and list data. It cannot delete or modify your rows.

  • 02

    Can the AI add new rows to my base?

    No. The current tools are for querying and inspecting data, not for writing or inserting new records.

  • 03

    Do I need to know SQL?

    No. You just ask questions in plain English, and your agent handles the SQL part.

  • 04

    How does the AI know my table names?

    The agent uses the list tools to inspect your base structure before it attempts to run a query.

  • 05

    Can the AI change my column names?

    No. The agent cannot perform any structural changes to your SeaTable base.

  • More questions about SeaTable? The Connector page answers them. See everything the SeaTable Connector can do

Connect SeaTable to Claude, Cursor, ChatGPT & more