mcp-google-sheets vs mcp-obsidian (Obsidian Local REST API)
A side-by-side comparison of two Productivity servers — tools, transport, auth, maintenance, and copy-paste config for each.
| mcp-google-sheets Your AI assistant's gateway to Google Sheets — read, write, format, and chart spreadsheets via MCP. Unverified stdio (local) OAuth Python | mcp-obsidian (Obsidian Local REST API) Read, search, and edit your Obsidian vault through the Local REST API community plugin. Verified stdio (local) API key Python | |
|---|---|---|
| Category | Productivity | Productivity |
| Language | Python | Python |
| Transport | stdio (local) | stdio (local) |
| Auth | OAuth | API key |
| GitHub stars | 912 | 3.6k |
| Last commit | 1 month ago | 4 months ago |
| Verified | ||
| Actively maintained | ||
| Install | uvx mcp-google-sheets@latest | uvx mcp-obsidian |
| Repo | Open | Open |
Verdict
Pick mcp-google-sheets if you need the broadest set of tools.
Pick mcp-obsidian (Obsidian Local REST API) if you prefer the more popular, battle-tested option, and you want a verified, documented setup.
Add mcp-google-sheets
uvx mcp-google-sheets@latestPaste into ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"mcp-google-sheets": {
"command": "uvx",
"args": [
"mcp-google-sheets@latest"
],
"env": {
"SERVICE_ACCOUNT_PATH": "/full/path/to/your/service-account-key.json",
"DRIVE_FOLDER_ID": "your_shared_folder_id_here"
}
}
}
}Requires `uv` (the Python package runner). Install it from https://docs.astral.sh/uv/ if `uvx` is not found.
Add mcp-obsidian (Obsidian Local REST API)
uvx mcp-obsidianPaste into ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"mcp-obsidian-obsidian-local-rest-api": {
"command": "uvx",
"args": [
"mcp-obsidian"
],
"env": {
"OBSIDIAN_API_KEY": "<your-obsidian-rest-api-key>",
"OBSIDIAN_HOST": "127.0.0.1",
"OBSIDIAN_PORT": "27124"
}
}
}
}Requires `uv` (the Python package runner). Install it from https://docs.astral.sh/uv/ if `uvx` is not found.
FAQ
mcp-google-sheets or mcp-obsidian (Obsidian Local REST API) — which is better?
Pick mcp-google-sheets if you need the broadest set of tools. Pick mcp-obsidian (Obsidian Local REST API) if you prefer the more popular, battle-tested option, and you want a verified, documented setup.
Can I use both mcp-google-sheets and mcp-obsidian (Obsidian Local REST API)?
Yes — MCP clients let you enable multiple servers at once. Add both configs to your client's mcpServers and use whichever tool fits the task.
Do mcp-google-sheets and mcp-obsidian (Obsidian Local REST API) work with Claude, Cursor and Windsurf?
Both do. Copy the per-client config below into Claude Desktop, Cursor, or Windsurf.