# Stackby — MCP server on mcp.ai
> Connect your Stackby account and use 9 tools for spreadsheets straight from your AI agent. Connect with your own API key. Stackby combines spreadsheets, databases, and workflow automation so teams can organize data, collaborate, and manage business processes.

By: mcp.ai · official
Page: https://mcp.ai/stackby

## Connect (MCP protocol)
Remote MCP endpoint (HTTP, streamable): https://api.mcp.ai/p_stackby?ms=1787291460000
Add it as a custom/remote MCP connector, then authenticate when prompted.

## REST API (no MCP client required)
Every tool is also a REST endpoint, authed with a workspace API key.
Discover: GET https://api.mcp.ai/api/stackby/_endpoints   # public; lists every endpoint
Call:     POST https://api.mcp.ai/api/stackby/<endpoint>
  Authorization: Bearer sk_live_…   # create one at https://mcp.ai/settings/api-keys
  Content-Type: application/json
  Body: { …args }   →   { "ok": true, "tool": "<id>", "result": { … } }

## Developer docs
How to use (MCP or REST), markdown: https://mcp.ai/stackby/skill.md
Postman collection (v2.1): https://mcp.ai/stackby/postman.json

## Tools
- stackby_create_rows(records: object[], stack_id: string, table_id: string) — Create 1 to 10 rows in a Stackby table in one request.
- stackby_delete_rows(row_ids: string[], stack_id: string, table_id: string) — Delete 1 to 10 identified rows from a Stackby table.
- stackby_list_columns(stack_id: string, table_id: string) — List columns and their types for a Stackby table so row field names can be chosen correctly.
- stackby_list_rows(filter?: string, offset?: integer, row_ids?: string[], view_id?: string, stack_id: string, table_id: string, page_size?: integer, sort_field?: string, sort_direction?: string) — List one page of rows from a Stackby table, or retrieve specific rows by ID, with optional filtering, view selection, and single-field sorting.
- stackby_list_stacks(workspace_id: string) — List accessible Stackby stacks in a known workspace and return IDs needed for table discovery.
- stackby_list_tables(stack_id: string) — List tables in a Stackby stack and return their IDs and names.
- stackby_list_views(stack_id: string, table_id: string) — Return view IDs and names for a Stackby table for use in view-scoped row queries.
- stackby_list_workspaces() — List accessible Stackby workspaces and return the workspace IDs needed to discover stacks.
- stackby_update_rows(records: object[], stack_id: string, table_id: string) — Partially update 1 to 10 existing Stackby rows in one request.

## Example prompts
- "What can I do in Stackby?"
- "Show me a summary of my Stackby account"

## Links
Docs: https://mcp.ai/docs/mcps/stackby
Website: https://mcp.ai/mcps/stackby