Tools
In the admin: Settings › Data API › MCP › Tools
The MCP server's tools, grouped as Settings › MCP switches them. R: read-only, offered in Read only mode. C: needs confirm=true in Full mode. S: not offered in Standard mode.
Always on
| Tool | |
|---|---|
whoami R | who the token is |
get_settings R | settings' values or their schema |
list_resources R | tables, views and functions |
list_roles R | |
sync_catalog | re-read PostgreSQL's catalog |
list_broken_references R | DataViews and dashboards naming what's gone |
get_openapi R | the Data API as a role sees it, or the Admin API |
Tables and schema
| Tool | |
|---|---|
describe_table R | columns, constraints, presentation |
create_schema | |
create_table | columns, primary key, foreign keys, UNIQUE, CHECK, exposure |
alter_table C (drops) | add, change or drop columns and constraints; preview=true shows the SQL |
delete_table C S | |
expose_resource | which methods the Data API offers |
set_column_presentation, set_column_presentations | labels, formats, value colors |
suggest_presentation R | |
set_row_presentation | how a referenced row shows |
Records
| Tool | |
|---|---|
query_records R | filters, relations, aggregates, grouping |
write_records C (delete) | create, update, delete, upsert, nested create |
upload_file | |
call_function |
Permissions
get_permissions R · grant_permission · grant_permissions · revoke_permission S · apply_default_permissions · set_capability
Users
list_users R · create_user (with a password or an invitation) · set_user_roles · send_user_link (invitation or reset)
DataViews and pages
list_dataviews R · get_dataview R · create_dataview · update_dataview · publish_dataview · delete_dataview C S · get_page R · set_page_variables · add_page_widgets · update_page_widget · move_page_widget · delete_page_widget C S · save_page_code · get_app_menu R · set_app_menu · check_app R
Dashboards
list_dashboards R · get_dashboard R · suggest_dashboard R · create_dashboard · update_dashboard · describe_dashboard_widgets R · preview_query R · save_widget · apply_dashboard (replaces the draft's widgets; dry_run) · delete_widget C S · list_embeds R · create_embed · update_embed · revoke_embed C S · publish_dashboard · delete_dashboard C S
Workflows
list_secrets R · set_secret (Settings > Secrets, write-only) · list_workflows R · get_workflow R · create_workflow · save_workflow · run_workflow (test runs) · get_workflow_runs R · publish_workflow · set_workflow_enabled · delete_workflow C S
Templates
list_templates R · save_template · test_template R
SQL
| Tool | |
|---|---|
execute_sql C (destructive SQL) | runs SQL as TotalBase's database role. Needs Allow API tokens in SQL Console; DROP, TRUNCATE, DELETE FROM, REVOKE and ALTER … DROP need confirm |
explain_sql R | a query's plan |
Every tool's call is an Admin API or Data API request, so its permissions, guardrails and audit are the same as in the admin.