Spreadsheet DB MCP server
io.github.ManddarinShop/spreadsheet-db-mcp·v0.1.1·1 starsSQLite-authoritative entity database with an async Google Sheets projection for AI agents.
1 stars47 downloads/wk
Reviews
Write oneNobody has reviewed Spreadsheet DB yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
Spreadsheet DB tools (8, 3 write)
write = sends, deletes, buys or postsRead from the package source without running it. The installed server may list more.
create_recordwrite actionCreate one record in the local SQLite authority. Delivery to the Google Sheet is asynchronous; check get_sync_status afterwards. All non-nullable fields are required; dates are ISO 8601 strings.
delete_recordwrite actionDelete one record by primary key from the local SQLite authority.
find_recordsFind records in the local SQLite authority. `where` maps field names to a value (equality) or an operator object: eq, ne, gt, gte, lt, lte, in, nin, like.
get_recordFetch one record by its primary key from the local SQLite authority.
get_sync_statusReport whether sync is enabled, which spreadsheet is bound (ID only), pending/failed Sheet effect counts, and unresolved conflict counts. In local-only mode returns {mode: "local"}.
list_conflictsList unresolved conflicts where a human edited the Sheet and hikoutei kept SQLite authoritative. Read-only in v1: report these to the human; do not attempt automated resolution.
list_entitiesList the entities declared for this hikoutei runtime with their fields, types, and primary keys.
update_recordwrite actionUpdate one record by primary key (partial data; the primary key itself is immutable). Changes commit to SQLite first; the Sheet projection follows asynchronously.
Public scan report
scanner v0.1.10 · 2026-11-03 · same rubric, same numbers if you re-run it
- Code scan11 source files scanned25/25
- –Live reliabilityno gateway calls yet and no remote to proben/a
- –Tool poisoningtools not inspected (local package is not executed); not countedn/a
- Auth qualitystatic API keys via environment variables6/15
- Maintenancelast push 20 days ago15/15
- Maintainer identityregistry namespace matches repository owner6/10
How Spreadsheet DB compares
Against every graded Databases MCP server, from our own scans and uptime checks. Updated after each scan run.
- Safety score
- 80/100
- higher than 50% of 802 Databases servers
- Tools
- 8
- the typical Databases server has 8
- Tools that change things
- 38%
- typical: 10%. Fewer write tools means less an agent can break
- GitHub stars
- 1
- more than 45% of 602 Databases servers
- Downloads a week
- 47
- more than 33% of 328 Databases servers with a package
What its tools let an agent do: 5 read · 1 create · 1 change · 1 delete
Install Spreadsheet DB in Claude Code, Cursor or VS Code
Runs npx -y spreadsheet-db-mcp on your machine. Read the scan report first; the gateway never runs local packages.
claude mcp add spreadsheet-db-mcp -- npx -y spreadsheet-db-mcp
What the publisher says
From the Spreadsheet DB repository's README, as published. We do not edit it. Read it on GitHub
한국어 | 日本語
Hikoutei
Keep your app fast with SQLite. Keep your workflow visible in Google Sheets.
A typed repository and safe write layer for Google Sheets-backed MVPs: your application reads and writes local SQLite through typed entities, and committed changes are asynchronously projected to Google Sheets for human review and lightweight collaboration.
npm · Quick start · Issues
What is Hikoutei?
Hikoutei gives TypeScript applications a typed entity API backed by local SQLite, then asynchronously synchronizes committed changes to Google Sheets.
Your application does not wait on Google Sheets for normal reads and writes. Sheets remains available for inspection, operations, and lightweight human collaboration.
Hikoutei is not a raw Sheets API wrapper, not a replacement for PostgreSQL,
and it does not treat Google Sheets as the authoritative application
database. SQLite is the source of truth; Sheets is the human-facing view.
Why Hikoutei?
- Define typed entities instead of manually converting Sheet rows.
- Read and write through local SQLite without waiting for Google Sheets.
- Synchronize committed changes to Sheets in the background.
- Detect unexpected column changes and duplicate headers.
- Avoid overwriting newer Sheet edits during conflicting updates.
Hikoutei does not replace google-spreadsheet or @googleapis/sheets — it sits one level above them. If you only need raw spreadsheet access, use the API client directly.
Installation
npm install hikoutei @mikro-orm/core @mikro-orm/sqlInstalling the library does not touch Google Cloud — it runs local-only (SQLite) by default. Run the setup command below only when you want Sheet sync.
Setup (Google Sheets sync)
One-time, interactive. Install the gcloud CLI, then:
npx hikoutei setupThis creates the Cloud project, service account, key, and spreadsheet, and writes .env for you. Without HIKOUTEISYNCSPREADSHEET_URL, createTypedSheets() stays local-only (SQLite). Details, credential pools, quota guidance, and manual setup: Google Sheets setup.
Usage
Define a scalar entity and use the local SQLite authority through a request-local manager.
import { createTypedSheets, defineTypedSheetsEntity } from "hikoutei";
const User = defineTypedSheetsEntity({
name: "User",
tableName: "users",
properties: {
id: { type: "string", primary: true },
name: { type: "string" },
age: { type: "number" },
active: { type: "boolean" },
},
});
const hikoutei = await createTypedSheets({
dbName: "./hikoutei.sqlite",
entities: [User],
});
const em = hikoutei.em.fork();
const user = em.create(User, { id: "u1", name: "Ada", age: 36, active: true });
em.persist(user);
await em.flush();Shortened. The full README is on GitHub.
Nothing above is checked by us. What we check is on the safety report.
Spreadsheet DB: common questions
- Is Spreadsheet DB MCP server safe?
- Mostly: it is graded B (80/100). Read the Spreadsheet DB safety report
- How do I install Spreadsheet DB?
- It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
- Does Spreadsheet DB need an API key?
- Yes. The registry entry asks for
GOOGLE_APPLICATION_CREDENTIALS. - Is Spreadsheet DB maintained?
- The last commit was 21 days ago (2026-10-14). The latest release is v0.1.1.
- What can I use instead of Spreadsheet DB?
- Servers from other publishers that do the same job: DBHub MCP server, Faucet MCP server and Sqlite Tools MCP server. Compare all Spreadsheet DB alternatives.
- How does Spreadsheet DB compare with other Databases MCP servers?
- safety score 80/100 (higher than 50% of 802 Databases servers); tools 8 (the typical Databases server has 8); tools that change things 38% (typical: 10%. Fewer write tools means less an agent can break). Full comparison.
Alternatives to Spreadsheet DB
Same job from other publishers: the closest match first, then the best rated.
- DBHubToken-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLitenot reviewedWidely usedA
- FaucetSQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.not reviewedEstablishedA
- Sqlite ToolsMCP server for local SQLite database operationsnot reviewedGrowingA
- QuarrySafety-railed database access: Postgres, MySQL, SQLite, Redis. Read-only by default.not reviewedGrowingA
- EmeraldThe database under the chat: a local SQLite file a model asks for rows, not notes to re-read.not reviewedGrowingA