execute_in_transaction

MCP tool from Omnisql MCP by srthkdev

Execute query within a transaction

How to use it

Project documentation lists execute_in_transaction for the Omnisql MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

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