sql_query
Execute a read-only SQL SELECT (supports JOINs across sheets, GROUP BY, aggregates, subqueries)
How to use it
Project documentation lists sql_query for the MCP Server Spreadsheet 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 MCP Server Spreadsheet
uvx mcp-server-spreadsheetOther tools in MCP Server Spreadsheet (24)
Add a new sheet (optional name and position)
Append rows after the last used row
Clear values in a range without removing rows/columns
Copy a block of cells to another location (optionally to a different sheet)
Duplicate a sheet within a workbook (optional new name and position)
Copy an existing file to a new path
Create a new empty spreadsheet file (format by extension)
Delete columns by index
Delete rows by index (shifts rows up)
Delete a sheet by name
Inspect column names, inferred types, row count, and sample values
Get row and column count of the used range
Insert blank columns at a position
Insert blank or pre-filled rows at a position (shifts rows down)
List all sheet names in a workbook
List all spreadsheet files in a directory (non-recursive)
Read a single cell value, e.g. B3
Read a rectangular range, e.g. A1:D10
Read entire sheet as rows (optional row/column bounds)
Rename an existing sheet
Search for a value or regex pattern, returns matching cell references
Execute INSERT INTO, UPDATE, or DELETE FROM — writes changes back to the file
Write a value to a single cell
Write a 2D array starting at a given cell