TrackVia MCP server

Walks every view in the account and returns the ones with an exact-matching name.

Returns a page of records from a view, with every column of the view on each record.

Creates a new view on the table.

Applies a partial update to a view (rename, edit filters, replace column projection).

Returns a single record from a view via the platform's RecordController.

Creates a record in a view.

Creates multiple records in a view in one request.

Updates a single record.

Downloads a file (or image) from a record field.

Uploads (or replaces) a file in a document or image record field.

Fetches the full definition of up to 10 forms on one table.

Lists every form defined on the given table, returning each form's id, name, tableId and appIds only.

Creates a new form on the table.

Applies a partial update to a form (rename, edit layout, replace projection).

Returns the account users as normalized {id, email, firstName, lastName, timeZone, status, groups, customFields} entries.

Creates a new account user.

Pages the account user list once, then builds a lookup map.

Fetches a single role by ID, including its full roleRules, resources, forms, and views tree.

Lists every role defined on the given app.

Creates a new role in the account.

PUT on /roles/{roleId}.

Lists dashboards in the account, returning each dashboard's id, name and appId only.

Creates a new dashboard in the account.

Creates a MANY_TO_ONE relationship between two tables and verifies it actually persisted on BOTH sides.

Returns the field metadata (structure) for a view plus the total record count.

Returns the record plus, for every field, its type, required flag, writability, and (for relationship fields) the linked id.

Fetches every app, every view, and (by default) a handful of sample field names per view in a single response.

The canonical 'load the entire schema' call.

Paginates a view's records, then applies filter / sort / select in the MCP server.

Runs /find?q=<keyword> in parallel across every view (optionally scoped to an app) and returns the top matches per view.

Looks up a record by uniqueField=uniqueValue.

Queries the view, evaluates the filter client-side, then PUTs the recordData to each matching record (bounded concurrency, default 4).

Takes {viewId, filter, recordData} for a filtered bulk record update but performs no writes.

Walks the parents of a record and the children that point back to it, in one call.

Paginates the view, groups records by the value of field (or a composite key from fields[]), and returns only the groups with count ≥ minCount.

Parses csv (or accepts a pre-parsed records array), optionally remaps column names via fieldMapping, casts values against the view's structure, then either batch-creates or upserts on uniqueField.

Same parse + cast + lint pipeline as importRecordsFromCsv but without writing.

Paginates the view (up to 10k records), optionally applies a filter, groups by field, then computes aggregate (count/sum/avg/min/max) over valueField.

Groups records into day/week/month/quarter/year buckets based on dateField, applies the aggregate, and returns [{bucket, value}] sorted ascending.

Returns {viewId, viewName, appName, isDefault} for the matching view, or {match: null, candidates: [...]} when the name is ambiguous.

Returns the metadata of one field on a view — type, fieldMetaId, required, unique, searchable, and choices (if applicable).

Scans the account-users list and returns the first match.

Creates a table with its fields in a single POST (the platform's TableCreateRequest accepts an inline fields array).

Creates an app, scaffolds each requested table (with fields inline), and by default creates at least one dashboard so the app has a landing surface from day one.

GETs the role, splices a {id, type:'resultProjection', actions[]} entry into resources.views[] (replacing any prior entry for that viewId), then PUTs the role back.

GETs the role, splices a {id, type:'form', actions[]} entry into resources.forms[], then PUTs the role back.

Creates a chartView of type LineChart.

Creates a chartView of type PieChart.

Creates a chartView of type ColumnChart (vertical bars).

Creates a junction table and two MANY_TO_ONE relationships (junction -> tableA, junction -> tableB).

GETs the dashboard, walks elements[] for embedded view IDs, grants the role read access on each, then grants the role the dashboard.