export_data
Export to CSV/JSON
How to use it
export_data is exposed by the Omnisql MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the export_data tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
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
Get connection details
Database statistics
Get connection pool statistics
Get table structure
List all database connections
Retrieve stored notes
List tables and views
Roll back a transaction
Test connectivity
Run INSERT/UPDATE/DELETE