Tables
List tables
Every table with its columns and how many rows it has.
Free*
*Free up to 1,000,000 reads a month for the whole account, then $0.50 per 10,000 reads.
An example
What tables do we keep with you?
Your agent callstables_listFree*
The example business is Halverson Cycle & Repair, a bike shop with a repair workshop in Portland, Oregon. The reply is the one the tool really gives.
With these arguments
{}What comes back
Use it when
To find a table's name and its column names before reading or writing rows.
What it does
Every table with its columns and row count.
What comes back
tables: each with its table_id, name, description, row count and columns. Every reply also carries cost_usd and balance_usd.
The call
Over MCP, call tables_list on https://api.conecto.chat/mcp/tables. Over REST:
Terminal
curl -X POST https://api.conecto.chat/v1/tools/tables_list \
-H "Authorization: Bearer $CONECTO_KEY" \
-H "Content-Type: application/json" \
-d '{}'More Tables tools
All 12 tools- Create a table
tables_createCreates 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 - Change columns
tables_change_columnsAdds, renames or removes columns; rows keep their values through a rename.$0.001 a call - Add rows
rows_addAdds up to 500 rows, each checked against its columns; if one is wrong, none is added.$0.001 per row added - Change rows
rows_updateChanges values in up to 500 rows by row number; only the columns given change, and null clears a cell.$0.001 per row changed - Add or update rows by a key
rows_upsertUpdates 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 - Find rows
rows_queryRows matching filters, all or any of them, sorted by up to 3 columns, a page at a time.Free* - Summarize rows
rows_summarizeCounts rows, and sums, averages, minimums and maximums of number columns, overall and per group, in one call.Free* - Delete rows
rows_deleteDeletes rows by their numbers, for good.Free
Give this to your agent.
Set up Conecto from https://conecto.chat/SKILL.md