Omnisql MCP
Unclaimedomnisql-mcp
Set up this server
01 / Choose your client
02 / Before you connect
Authentication is not specified. Check the project instructions before connecting.
Project instructions03 / Add the configuration
claude mcp add --transport stdio 'omnisql-mcp' -- 'npx' '-y' 'omnisql-mcp'04 / Check it in your client
Open your client’s MCP settings and confirm the server connects and lists its tools. A copied configuration does not confirm a working connection.
More in Databases
Browse the full directoryUnclaimed listing
Is this your MCP server?
This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.
Claim this serverSecurity profile
Claimed and verified servers get a weekly static scan that shows what the code can reach: external services, environment variables, shell commands, agent configuration folders, plus any dependencies with known advisories. Claim this listing to get one. How the security profile works
21 of 21 tools
Documented tools (21)
From project documentation. A server handshake does not verify each tool’s description or behavior.
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
Tool change history
FAQ
Questions about Omnisql MCP Server
- How do I connect Omnisql MCP Server to Claude?
- Run `claude mcp add omnisql-mcp -- npx -y omnisql-mcp` in Claude Code, or add the same command and arguments under mcpServers in Cursor's mcp.json or Claude Desktop's claude_desktop_config.json, then restart the client. The blocks above are ready to paste.
- Is Omnisql MCP Server free?
- The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.
- What can Omnisql MCP Server do?
- Omnisql MCP Server documents 21 tools to the agent, including alter_table, append_insight, begin_transaction. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.