{"name":"io.github.ManddarinShop/spreadsheet-db-mcp","slug":"manddarinshop-spreadsheet-db-mcp","title":"Spreadsheet DB","description":"SQLite-authoritative entity database with an async Google Sheets projection for AI agents.","url":"https://mcp.market/server/manddarinshop-spreadsheet-db-mcp","rating":null,"grade":"B","score":80,"certified":false,"status":"active","category":"data","tags":["data","productivity"],"presence":{"score":26,"stars":1,"forks":0,"downloads_week":47,"last_push_at":"2026-10-14T07:04:17.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/ManddarinShop/Hikoutei","website":null,"version":"0.1.1","remotes":[],"packages":[{"registryType":"npm","identifier":"spreadsheet-db-mcp","version":"0.1.1","transport":{"type":"stdio"},"environmentVariables":[{"description":"Path to the entity configuration file (hikoutei.config.json). Optional; the server also looks for ./hikoutei.config.json in the working directory.","format":"string","name":"HIKOUTEI_MCP_CONFIG"},{"description":"Google Sheets spreadsheet URL. Absent means local-only mode (no Google contact); when set, the Google Sheets projection is enabled and GOOGLE_APPLICATION_CREDENTIALS must also be set.","format":"string","name":"HIKOUTEI_SYNC_SPREADSHEET_URL"},{"description":"Path to a Google service-account key file (JSON) used for the Sheets projection. Only needed when HIKOUTEI_SYNC_SPREADSHEET_URL is set.","format":"string","isSecret":true,"name":"GOOGLE_APPLICATION_CREDENTIALS"}]}],"tools":[{"name":"create_record","description":"Create 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.","write_action":true,"price_micros":0,"input_schema":null},{"name":"delete_record","description":"Delete one record by primary key from the local SQLite authority.","write_action":true,"price_micros":0,"input_schema":null},{"name":"find_records","description":"Find 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.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_record","description":"Fetch one record by its primary key from the local SQLite authority.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_sync_status","description":"Report 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\"}.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_conflicts","description":"List 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.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_entities","description":"List the entities declared for this hikoutei runtime with their fields, types, and primary keys.","write_action":false,"price_micros":0,"input_schema":null},{"name":"update_record","description":"Update one record by primary key (partial data; the primary key itself is immutable). Changes commit to SQLite first; the Sheet projection follows asynchronously.","write_action":true,"price_micros":0,"input_schema":null}],"scan":{"score":80,"grade":"B","scanned_at":"2026-11-03T14:21:03.681Z","report":{"scannerVersion":"0.1.10","scannedAt":"2026-11-03T14:21:03.569Z","components":{"code":{"score":25,"max":25,"notes":["11 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 20 days ago"]},"identity":{"score":6,"max":10,"notes":["registry namespace matches repository owner"]}},"findings":[],"inputs":{"packages":[{"registryType":"npm","identifier":"spreadsheet-db-mcp","version":"0.1.1","found":true,"license":"MIT","hasInstallScripts":false,"dependencyCount":4,"publishedAt":"2026-08-17T06:51:05.746Z","repositoryUrl":"git+https://github.com/ManddarinShop/Hikoutei.git","weeklyDownloads":47}],"repo":{"found":true,"owner":"ManddarinShop","repo":"Hikoutei","archived":false,"pushedAt":"2026-10-14T07:04:17Z","stars":1,"forks":0,"openIssues":681,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/297782097?v=4","ownerCreatedAt":"2026-06-29T04:32:04Z","license":"MIT"},"icon":{"url":null,"source":"none"},"presence":{"stars":1,"forks":0,"downloadsWeek":47,"license":"MIT","lastPushAt":"2026-10-14T07:04:17.000Z","score":26}}}},"grade_history":[],"reviews":[]}