alter_table
Modify existing table schema (add columns, rename tables, etc.)
LABSCO SUMMARY
Your DBeaver connections, without re-entering a single password.
Reusing the workspace's saved connections is the whole convenience: the databases you already set up in DBeaver are immediately reachable, so there is no second credential store to manage. The read/write split and the connection whitelist give you a real safety boundary — execute_query is read-only, write_query is where mutations live, and OMNISQL_ALLOWED_CONNECTIONS lets you decide which databases an assistant can touch at all.
What it is
A universal database server (OmniSQL) that reuses the connections already configured in your local DBeaver-compatible workspace: 21 tools for querying, writing, schema management, transactions and export across PostgreSQL, MySQL/MariaDB, SQL Server and SQLite natively, with Postgres-compatible engines routed automatically.
What you get
- Connections come from DBeaver: list_connections shows what is configured, get_connection_info details one, and test_connection checks it — no duplicate credential setup
- Reads and writes kept separate: execute_query runs read-only SQL, and write_query handles INSERT, UPDATE and DELETE
- Schema management: create_table, alter_table (add columns, rename), drop_table with a safety confirmation, get_table_schema and list_tables
- Transactions handled explicitly — begin_transaction, execute_in_transaction, commit_transaction and rollback_transaction
- explain_query returns the execution plan, compare_schemas diffs two connections, get_database_stats and get_pool_stats report on the database and the connection pool
- export_data writes query results to CSV, JSON and other formats
- append_insight and list_insights keep a memo of business insights and analysis notes alongside the data
Requirements
A local DBeaver-compatible DB client with at least one configured connection — the server reads those. Node.js 18 or later, installed with npm install -g omnisql-mcp. OMNISQL_PROJECT names the workspace folder if it is not the default General, OMNISQL_ALLOWED_CONNECTIONS whitelists which connections are reachable, and OMNISQL_CLI_PATH points at an external CLI for databases without a native driver.
Setup effort
One command — npm install -g omnisql-mcp
USE CASES
01
Answering a question from the database
List the configured connections, pick the right one, and run a read-only query — with the execution plan on hand when a query is slow.
02
Making a change safely
Wrap the writes in a transaction, run them, and commit only if everything went as expected — or roll back if it did not.
03
Working the schema
Inspect a table's schema, add or rename columns, and create new tables — with a safety confirmation before anything gets dropped.
04
Planning a migration between environments
Compare the schemas of two connections to see what differs, then export the query results you need to hand off.
21 tools
Counted once with only startup setup. Other versions, modes or optional credentials may expose a different list.
append_insight
Add a business insight or analysis note to the memo
begin_transaction
Start a new database transaction
commit_transaction
Commit an active transaction
compare_schemas
Compare schemas between two database connections
create_table
Create new tables in the database
drop_table
Remove a table from the database with safety confirmation
execute_in_transaction
Execute a query within an active transaction
execute_query
Execute a SQL query on a specific database connection (read-only queries)
explain_query
Get the execution plan for a SQL query
export_data
Export query results to various formats (CSV, JSON, etc.)
get_connection_info
Get detailed information about a specific database connection
get_database_stats
Get statistics and information about a database
get_pool_stats
Get connection pool statistics for a connection
get_table_schema
Get schema information for a specific table
list_connections
List all available database connections
list_insights
List all stored business insights and analysis notes
list_tables
List all tables in a database
rollback_transaction
Rollback an active transaction
test_connection
Test connectivity to a database connection
write_query
Execute INSERT, UPDATE, or DELETE queries on a specific database connection
BEFORE YOU INSTALL
What to know first
Tools you get
21 tools when we connected. OMNISQL_READ_ONLY=true limits execute_query to SELECT, EXPLAIN, SHOW and DESCRIBE and disables the transaction tools; OMNISQL_DISABLED_TOOLS removes tools by name. By default write_query, drop_table and alter_table are all available.
Requires
- A local DB client (DBeaver-compatible) with at least one configured connection
- Node.js 18+
Where it runs
All 3 documented clients run the server on your machine.
CONTEXT COST
Light Standing cost
Rated by the size of the 21 tool definitions that ride along on every turn, not by how many there are
INSTALLATION
Connect your client
Server setup
TERMINAL
npm install -g omnisql-mcpMCP Clients
Claude Desktop, Claude Code, Cursor
JSON
{
"mcpServers": {
"omnisql": {
"command": "omnisql-mcp"
}
}
}
