_app_get_table_rules
ChatGPTGet the rules that determine which rows the interactive viewer locks against editing.
Overview
Syntropic is the front door to your data warehouse. Give employees, customers, vendors, and AI agents a governed way to submit and edit business data, with permissions, validation, approvals, and audit history. From ChatGPT and Codex, work with authorized tables in Snowflake, Databricks, Amazon S3, and MotherDuck: discover workspaces and connections, review workspace membership as an administrator, open an interactive grid, create or update rows and schemas, manage quality rules, and explain recorded changes. You can also inspect webhook metadata, edit non-secret settings, and copy existing webhooks between authorized tables in the same organization. All actions run with the signed-in user's Syntropic permissions; stored connection and webhook credentials stay server-side.
Tools
_app_get_table_schema
ChatGPTGet table schema and approval settings for the interactive viewer.
_app_read_table
ChatGPTReturn table rows for the interactive viewer.
connect_existing_table
ChatGPTRegister an existing warehouse table with Syntropic. Requires workspace Creator access or higher.
copy_connection
ChatGPTCopy a connection to another workspace in the same organization and test it. Requires internal organization admin or owner access. The copy remains if the test fails. When automatic connection access is enabled, all destination workspace members, including pending invitees, receive access to the copy.
copy_webhook
ChatGPTCopy an existing webhook's stored request configuration to a table in the same organization. Requires workspace Creator access or higher within one workspace, or Admin access to both workspaces for a cross-workspace copy.
create_table
ChatGPTCreate an empty warehouse table and register it with Syntropic. Requires workspace Creator access or higher.
create_table_with_data
ChatGPTCreate a warehouse table with initial rows and register it with Syntropic. Requires workspace Creator access or higher. Initial rows are validated before the table is created.
create_workspace
ChatGPTCreate a workspace. Requires organization admin access.
disconnect_table
ChatGPTDisconnect a table and delete its Syntropic metadata, change history, rules, saved views, and webhooks without deleting the warehouse table or its data. Requires workspace Creator access or higher.
edit_webhook
ChatGPTEdit a webhook's non-secret settings. Requires workspace Creator access or higher. Provide at least one setting; omitted settings remain unchanged. The stored request URL, method, credentials, payload, and parameters cannot be edited with this tool.
get_change_diff
ChatGPTShow a preview of row changes, schema conflicts, approval status, and approver decisions for a table-history entry.
get_existing_table_schema
ChatGPTGet a warehouse table's column definitions before connecting it to Syntropic. Requires workspace Creator access or higher.
get_table_history
ChatGPTList a Syntropic table's change history, including change IDs, authors, timestamps, messages, and approval status.
get_table_schema
ChatGPTGet a Syntropic table's schema, including column IDs, types, constraints, and quality rules.
invite_workspace_users
ChatGPTAdd users to a workspace, sending invitation emails when needed. Requires workspace admin access. New members receive access to existing connections when the organization's automatic connection access setting is enabled.
list_connections
ChatGPTList connections, including IDs, types, and status.
list_existing_database_tables
ChatGPTList tables available through a connection, indicating which are already connected to Syntropic. Requires workspace Creator access or higher.
list_tables
ChatGPTList Syntropic-managed tables, including table IDs, connection IDs, workspace IDs, and row counts.
list_webhooks
ChatGPTList a table's webhooks, including IDs and activation status. Excludes URLs, header values, payloads, and request parameters.
list_workspace_members
ChatGPTList active and pending workspace members. Requires workspace admin access.
list_workspaces
ChatGPTList workspaces and their organizations, including IDs and effective workspace roles.
manage_quality_rules
ChatGPTAdd, replace, or clear quality rules on a table column. Requires workspace Creator access or higher. Rules are enforced when saving new or updated values.
read_table
ChatGPTDisplay a Syntropic table in the interactive viewer, or return a text preview when the viewer is unavailable. Viewer mode returns an acknowledgement rather than row data.
test_connection
ChatGPTTest a connection and update its saved health status and last-checked time, including on failure. Requires workspace Admin access. MotherDuck also performs a rolled-back write-access check. Reported connection failures return `
healthy: false`.update_rows
ChatGPTInsert, update, or delete rows in a Syntropic table's backing warehouse. Requires workspace Editor access or higher. Changes are validated and may require approval before being applied. Applied changes can trigger active table webhooks.
update_table_schema
ChatGPTAdd, drop, or modify columns in a Syntropic table's backing warehouse. Requires workspace Creator access or higher. Changes apply without the row-approval flow and can delete column data.
Capabilities
WritesInteractive
Example Prompts
Click any prompt to copy it.
