Read and write Rowflare bases (open-source Airtable alternative): records, tables, fields, totals.
Scored across 26 tools
Tools are grouped by resource and action, with clear distinctions between table, field, record, view, automation, and dashboard operations. The main possible confusion is among get_records (by id), query_records (filter/formula), and aggregate (metrics), but the descriptions mostly resolve this.
Most tools follow a predictable snake_case verb_noun pattern such as create_table, update_field, delete_records, and list_bases. A few names like aggregate, query_records, describe_base, and generate_ai_field deviate slightly but remain readable and understandable.
The server covers a broad platform surface including bases, tables, fields, records, views, automations, dashboards, and AI features, so 26 tools are largely justified. The set is heavy but not redundant, with each tool generally earning its place.
Core CRUD for records, tables, and fields is well covered, and describe_base gives needed context. However, views, automations, and dashboards have create/get/list/update but no delete operations, which are notable lifecycle gaps.
Count, total, average, min or max over a table, optionally grouped by up to 2 fields, computed in the database. Use this instead of reading all records to answer how many / how much questions. Multi-value fields (multiple select, links, users) count a record once per value. Dates group by day unless bucket is week, month or year.
Inputs: table (required), baseId (required), metrics (required), view, +3 more.
Create an automation from a trigger and steps, naming tables and fields. It starts switched off unless enabled is true. Triggers: recordCreated, recordUpdated, recordMatches, schedule, dateReached, webhook, button. Steps run in order: createRecord, updateRecords, findRecords, http, email, branch (one level, with then and else). Templates: {{trigger.record.}}, {{trigger.record}} (the record, for link fields), {{trigger.body.}} (webhook), {{steps..records[0].}}, {{steps..count}}, {{steps..status}}, {{steps..body.}}, {{now}}, {{record.url}}.
Inputs: name (required), baseId (required), trigger (required), steps, +1 more.
Create a dashboard, optionally with widgets. Widget types: metric (one number), bar, line, pie, pivot (summary table), text (Markdown). Charts group by a field (x for bar and line, group for pie, rows and columns for pivot); date fields are bucketed by month unless bucket says otherwise. metric is what each number is: count, or sum/avg/min/max of a field. Widgets without a position stack below each other on a 12-column grid.
Inputs: name (required), baseId (required), widgets.
Add a field to a table. Formulas use field names in braces. A pathLookup field collects the records of targetTable that this record reaches through any chain of links, to any depth, following each link's dependsOn direction; filter it with empty to find records with no such chain (for example emails never used on a platform).
Inputs: field (required), table (required), baseId (required).
Create 1 to 200 records.
Inputs: table (required), baseId (required), records (required), typecast.
Create a table. The first field is the primary field and must be a plain type (text, number, date...). Link, lookup, rollup and formula fields may reference fields listed earlier in the same call. Without fields you get Name, Notes and Status.
Inputs: name (required), baseId (required), fields.
Add a grid, kanban, calendar, timeline, gallery or form view with optional filter, sort, hidden fields and type-specific settings (grouping, date fields, lanes, cover).
Inputs: name (required), type (required), table (required), baseId (required), +11 more.
Permanently delete a field and its values. Deleting a link field also deletes its inverse.
Inputs: field (required), table (required), baseId (required).
Permanently delete 1 to 200 records by id.
Inputs: ids (required), table (required), baseId (required).
Permanently delete a table, its records, and link fields in other tables that point at it.
Inputs: table (required), baseId (required).
Show every table in a base with its fields (type and options), primary field, row count and views. Call this before reading or writing records so you use the right table and field names.
Inputs: baseId (required).
Queue AI generation for some records of an AI field, the records never generated (missingOnly), or the whole column. Generation runs in the background; read the records later to see the answers.
Inputs: field (required), table (required), baseId (required), records, +1 more.
An automation's trigger and steps with table and field names, its webhook URL if it has one, and its last 20 runs.
Inputs: baseId (required), automation (required).
A dashboard's widgets with their settings (table and field names) and each widget's current numbers over all time. Widgets with a problem (deleted field, unfinished) say so and carry no data.
Inputs: baseId (required), dashboard (required).
Fetch up to 100 records by id. Long text is cut at 2,000 characters unless fullText is true.
Inputs: ids (required), table (required), baseId (required), fields, +1 more.
Model services of the base's workspace, usable in AI fields (options.ai.service) and AI automation steps.
Inputs: baseId (required).
Automations of a base with their trigger type, whether they are on, and their last run. Editors and owners only.
Inputs: baseId (required).
List the Rowflare bases you can access, with their workspace and your permission (read, edit, create).
Inputs: no named parameters.
Dashboards of a base with their widget counts.
Inputs: baseId (required).
Find records in a table. Use filter (structured, fast) and/or formula (an Airtable formula such as AND({Status} = "Done", {Hours} > 5), slower). With view, the view's own filters and sorts apply and filter narrows them. Returns total and nextOffset for paging.
Inputs: table (required), baseId (required), sort, view, +5 more.
Rename an automation, switch it on or off, or replace its trigger or its steps (each is replaced as a whole when given). Templates: {{trigger.record.}}, {{trigger.record}} (the record, for link fields), {{trigger.body.}} (webhook), {{steps..records[0].}}, {{steps..count}}, {{steps..status}}, {{steps..body.}}, {{now}}, {{record.url}}.
Inputs: baseId (required), automation (required), name, steps, +2 more.
Rename a dashboard and add, change, move or remove widgets. update items name a widget id (from get_dashboard) and only the settings you pass change; position moves or resizes it. Names are checked before anything is written; changes then apply in order: rename, remove, update, add.
Inputs: baseId (required), dashboard (required), add, name, +2 more.
Rename a field, change its type or options, or set its description. For select fields send the full option list: existing options are kept by name, rename one with { name: new, renameFrom: old }, and options left out are removed from cells. Changing the type converts every cell.
Inputs: field (required), table (required), baseId (required), name, +3 more.
Update 1 to 200 records by id. Only the given fields change.
Inputs: table (required), baseId (required), records (required), typecast.
Rename a table or change its primary field.
Inputs: table (required), baseId (required), name, primaryField.
Rename a view or change its filter, sort, hidden fields or type-specific settings. Settings you leave out are kept; null clears one.
Inputs: view (required), table (required), baseId (required), name, +11 more.
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Read, search and add records in your Bionic Forms apps (hosted database apps for small teams).
Write rows to Google Sheets (append, replace, update by key) or read a tab. No OAuth needed.
Query your Google Sheets as structured JSON: list sheets and tabs, read schemas, filter rows.
Read and write Folk CRM people, companies, groups and notes.
Add one secure layer between your agents and this server.
