Omnisql MCP
未认领omnisql-mcp
claude-aidatabasemcp-servers
安装
$
npm install -g omnisql-mcp工具(21 个)
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_in_transaction
Execute query within a transaction
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