query_data
Run SQL against stored SQLite DB. Supports SHOW TABLES, DESCRIBE <table>, DROP TABLE <table>, CTEs, window functions, and more. Results can also be post-processed with apply.
How to use it
query_data is exposed by the MCP Massive MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the query_data tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install MCP Massive
claude mcp add massive -e MASSIVE_API_KEY=your_api_key_here -- mcp_massiveOther tools in MCP Massive (2)
Call any Massive.com REST API endpoint. Supports storing results as an in-memory database table (storeas) and applying post-processing functions (apply). Paginated responses include a next-page hint.
Search for API endpoints and built-in functions by natural language query. Returns titles, path patterns, and descriptions. Set detail to "more" for query parameter docs, or "verbose" for full documentation. Use maxresults to limit results.