get_records
Get Records
Read one exact record or a native page in a table from list_tables. Use list_table_views for a viewId. Optionally prepare a bounded JSON download of the returned record data; this does not create a provider export job.
Ask your agent in plain language. Each of these maps to a real tool on the server.
get_records
Read one exact record or a native page in a table from list_tables. Use list_table_views for a viewId. Optionally prepare a bounded JSON download of the returned record data; this does not create a provider export job.
list_tables
Discover table IDs and field definitions in a database from list_databases. No paging parameter is specified on the detailed native table-list route.
delete_record
Delete one exact record from a table discovered with list_tables. Requires a native 204 receipt, exact RESOURCE_NOT_FOUND readback and a still-accessible parent table. Deletion does not prove erasure of audit/history data and can have irreversible linked or automated effects.
manage_table
Create, get, update or delete a table in a database from list_databases. Discover existing tables with list_tables. fields and primaryFieldName apply only to creation. Delete requires an empty table unless force:true explicitly authorizes record removal. Native absence is checked; retained history is not erased.
sync_users
Request a user sync for explicit emails, or all users when emails is omitted. This may update many users and invoke configured data-source effects. An empty array is refused instead of silently syncing everyone. Acceptance is not completion; no documented polling endpoint is available. Verify in Softr before retrying.
create_record
Create one record in a table discovered with list_tables. Use native field IDs and value types; computed/system fields cannot be written. fieldNames retains the provider alias option, but IDs avoid ambiguous names. A retry after an uncertain receipt may create a duplicate.
update_record
Partially update an exact record using native PATCH. Only supplied fields are changed. Discover field IDs/types with list_tables; computed/system fields cannot be written. Reconcile uncertain writes before retrying.
list_databases
Discover authorized database IDs, names and workspace IDs. The detailed native endpoint defines a collection without paging parameters; oversized or explicitly incomplete collections are refused.
delete_user
Request deletion of an exact app user by email. The app must be published and selected in the connection. The documented API has no user readback, so acceptance does not confirm absence or erasure of retained data. Verify in Softr before retrying. Use manage_user_lifecycle to deactivate while retaining the record.
manage_database
Create, get, update or delete a Softr database. Discover IDs with list_databases; its workspaceId identifies an existing authorized workspace. A workspace with no databases requires its workspace ID from Softr settings. Delete requires an empty database unless force is explicitly true; forced deletion removes its tables and records. Native absence is checked after a 204 receipt; retained history is not erased.
search_records
Search native record pages in a table from list_tables using documented filters, sorting and offset pagination. Legacy field/value/values filter inputs map to native leftSide/rightSide; use two legacy values or native bounds for ranges.
generate_magic_link
Request a native magic sign-in link for an exact user in the selected published app. The link grants login and is sensitive; share it only with the intended user. No expiry or renewal is invented. Generating another link can have retained authentication effects, so reconcile an uncertain response before retrying.
create_user
Request creation of an app user with full name and email. Softr generates a password when omitted. Optionally return the requested native magic sign-in link; it is sensitive and grants login, so share it only with the intended user. The app must be published. Native acceptance is not an independently confirmed user record; check Softr before retrying an uncertain creation.
validate_user_token
Validate a supplied user JWT against the exact published app hostname selected in the connection. The personal access token is not forwarded to this endpoint. Only an explicit native boolean validation result is accepted; HTTP success alone is not valid:true. This is not connection identity discovery and does not decode or invent user claims.
manage_table_field
Add, read, update or delete an exact table field. Use list_tables to discover field IDs and native types. The documented write contract supports name, type and options. Retained description, allowMultipleEntries, required and defaultValue inputs are refused when supplied because the current write schema does not document them. Deleting a field removes its stored values; type/options changes can affect existing data.
manage_user_lifecycle
Request activation or deactivation of an exact app user. Deactivation prevents login and frees the user seat while retaining the user record; activation reverses it. The documented API has no independent user readback, so acceptance does not prove the resulting state. Verify in the selected published app before retrying.
list_table_views
Discover exact view IDs for the viewId filter in get_records. Discover the database and table with list_databases and list_tables.
Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.
{"mcpServers": {"metorial": {"url": "<your-magic-mcp-url>"}}}
claude mcp add --transport http metorial <your-magic-mcp-url>
codex mcp add metorial --url <your-magic-mcp-url>codex mcp login metorial
One governed layer for every app your agents reach, not a separate connector per tool.
Manage native Softr databases, tables, fields, records and table views. Request app-user creation, deletion, synchronization, activation or deactivation with truthful acceptance state; preserve sensitive magic-link and explicit JWT validation workflows. Read native pages and optionally prepare bounded JSON downloads.
Common questions about connecting Softr to AI agents with Metorial.