MCPVault

execute_in_transaction

MCP tool from Omnisql MCP by srthkdev

Execute query within a transaction

How to use it

execute_in_transaction is exposed by the Omnisql MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the execute_in_transaction tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Omnisql MCP

$npm install -g omnisql-mcp
FULL OMNISQL MCP LISTING

Other tools in Omnisql MCP (20)

alter_table

Modify tables

append_insight

Store analysis notes

begin_transaction

Start a new transaction

commit_transaction

Commit a transaction

compare_schemas

Compare schemas between two connections

create_table

Create tables

drop_table

Drop tables (requires confirmation)

execute_query

Run read-only queries (SELECT, EXPLAIN, SHOW, DESCRIBE only)

explain_query

Analyze query execution plan

export_data

Export to CSV/JSON

get_connection_info

Get connection details

get_database_stats

Database statistics

get_pool_stats

Get connection pool statistics

get_table_schema

Get table structure

list_connections

List all database connections

list_insights

Retrieve stored notes

list_tables

List tables and views

rollback_transaction

Roll back a transaction

test_connection

Test connectivity

write_query

Run INSERT/UPDATE/DELETE