list_insights
Retrieve stored notes
How to use it
Project documentation lists list_insights 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-mcpOther tools in Omnisql MCP (20)
Modify tables
Store analysis notes
Start a new transaction
Commit a transaction
Compare schemas between two connections
Create tables
Drop tables (requires confirmation)
Execute query within a transaction
Run read-only queries (SELECT, EXPLAIN, SHOW, DESCRIBE only)
Analyze query execution plan
Export to CSV/JSON
Get connection details
Database statistics
Get connection pool statistics
Get table structure
List all database connections
List tables and views
Roll back a transaction
Test connectivity
Run INSERT/UPDATE/DELETE