---
area: "tables"
title: "Tables"
tools: 12
mcp_server: "https://api.conecto.chat/mcp/tables"
auth: "Authorization: Bearer <conecto_sk_ key>"
docs_url: "https://conecto.chat/tools/tables"
---

# Tables

Tables the agent and the team share, like Airtable. Columns have types (numbers, dates, choices, files) and rows are checked on the way in, with filters, sorting, and CSV in and out.

Replaces: Airtable, Google Sheets, Notion databases.

## MCP server

`https://api.conecto.chat/mcp/tables` connects the Tables tools only, plus the account tools that come with every MCP server. It speaks MCP over Streamable HTTP; send the key as `Authorization: Bearer <conecto_sk_ key>`. Every tool here is also a REST call: `POST https://api.conecto.chat/v1/tools/<name>` with the arguments as a JSON object.

## ChatGPT and Claude

Add `https://api.conecto.chat/v1/mcp` as a connector in ChatGPT or Claude, one for every area, and tick Tables when you sign in. It signs in with OAuth: someone on the account signs in on conecto.chat, ticks the areas it may use and allows it, and it runs on a key of its own that the owner can revoke.

## OpenAPI

For a custom GPT's Actions: `https://api.conecto.chat/v1/openapi/tables.json` (OpenAPI 3.0, the key as a Bearer token). For Power Automate, Logic Apps and Copilot Studio connectors: `https://api.conecto.chat/v1/openapi/tables.swagger.json` (OpenAPI 2.0, the key in the X-Api-Key header). Both list this area's tools and the account tools.

Prices: Reading, summaries and deleting free · creating a table, changing columns or exporting $0.001 · adding, changing, syncing or importing rows $0.001 a row. A call that fails costs nothing.

## Tools

| Tool | What it does | Price |
|---|---|---|
| [tables_create](https://conecto.chat/tools/tables/tables_create.md) | Creates a table with typed columns: text, numbers with decimals or a currency, checkboxes, dates, choices, emails, links, phone numbers or files. | $0.001 a call. |
| [tables_list](https://conecto.chat/tools/tables/tables_list.md) | Every table with its columns and how many rows it has. | Free up to 1,000,000 reads a month. |
| [tables_change_columns](https://conecto.chat/tools/tables/tables_change_columns.md) | Adds, renames or removes columns; rows keep their values through a rename. | $0.001 a call. |
| [rows_add](https://conecto.chat/tools/tables/rows_add.md) | Adds up to 500 rows, each checked against its columns; if one is wrong, none is added. | $0.001 per row added. |
| [rows_update](https://conecto.chat/tools/tables/rows_update.md) | Changes values in up to 500 rows by row number; only the columns given change, and null clears a cell. | $0.001 per row changed. |
| [rows_upsert](https://conecto.chat/tools/tables/rows_upsert.md) | Updates the rows whose key column matches and adds the rest, so a list from anywhere syncs without reading the table first. | $0.001 per row added or updated. |
| [rows_query](https://conecto.chat/tools/tables/rows_query.md) | Rows matching filters, all or any of them, sorted by up to 3 columns, a page at a time. | Free up to 1,000,000 reads a month. |
| [rows_summarize](https://conecto.chat/tools/tables/rows_summarize.md) | Counts rows, and sums, averages, minimums and maximums of number columns, overall and per group, in one call. | Free up to 1,000,000 reads a month. |
| [rows_delete](https://conecto.chat/tools/tables/rows_delete.md) | Deletes rows by their numbers, for good. | Free. |
| [tables_export](https://conecto.chat/tools/tables/tables_export.md) | A CSV of a table, or of the rows matching filters, saved in the file store with a download link. | $0.001 a call. |
| [tables_import](https://conecto.chat/tools/tables/tables_import.md) | Adds the rows of a CSV in the file store to a table, or makes a new table from it. | $0.001 per row imported. |
| [tables_delete](https://conecto.chat/tools/tables/tables_delete.md) | Deletes a table and all its rows, for good. | Free. |

## Example jobs

- Keep a table of workshop jobs with each bike's work, due date and status.
- Every Friday, list the jobs due next week that are still waiting for parts.
- Turn a supplier's CSV price list into a table the agent can search.