Run a SQL write or schema change
executeRun INSERT, UPDATE, DELETE, or schema changes (CREATE, ALTER, DROP) on a SynapCores database, returning rows affected and execution time. Use dry_run=true to check syntax without modifying data.
Instructions
Run a SQL write (INSERT, UPDATE, DELETE) or schema change (CREATE, ALTER, DROP) against a SynapCores database and return rows_affected and execution_time_ms. Use query for SELECT/WITH, which this tool rejects, and validate_query or dry_run=true to check syntax without changing anything; Cypher statements sent here run on the graph, as with graph_query. Changes are permanent (DELETE and DROP remove data), and read-only API keys are refused.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sql": "<sql>"
},
"name": "execute"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The INSERT, UPDATE, DELETE, CREATE, ALTER or DROP statement to run. | |
| dry_run | No | true = only check the syntax and change nothing (default false). | |
| database | No | Database name; omit to use the default database. |