
SQL
io.github.Abhishekkumar2021由 GitHub 帳號 Abhishekkumar2021 發布v0.1.0更新於 Oct 24, 2026
Read-only SQL querying + schema introspection over Postgres & SQLite, with a gated write mode.
概覽
一個本機 MCP 伺服器,讓助理對 Postgres 與 SQLite 執行唯讀 SQL 查詢並檢視資料表結構,寫入模式需明確開啟。
- 可以做什麼
- 對 Postgres 或 SQLite 連線執行唯讀 SQL 查詢,並檢視資料庫結構、資料表與欄位,方便在查詢前了解資料模型。在明確開啟寫入模式後,可執行會修改資料的語句與多語句指令碼。可設定多個具名連線,分別存取。
- 適用情境
- 適合讓助理探索或彙報 Postgres、SQLite 資料庫,依據資料回答問題,或在對話中經明確開關後對資料庫進行有意的修改。
- 執行需求
- 透過 npx 在本機執行(需要 Node.js)。需在 DB_CONN_default 提供連線 URL(postgres://… 或 sqlite:/絕對路徑);其他連線使用 DB_CONN_ 。只有將 DB_WRITABLE 設為 1 或 true 時,寫入工具才會啟用。
安裝
README
🧰 mcp-suite
A collection of Model Context Protocol servers, built in TypeScript.
[CI] [License: MIT] [PRs Welcome] [Node.js]
[@abhishekmcp/notes] [@abhishekmcp/files] [@abhishekmcp/github] [@abhishekmcp/git]
Each server lives in its own folder under servers/ and publishes to npm as an independent package, while sharing tooling through an npm workspace. Connect them to any MCP client — Claude Desktop, Claude Code, Cursor, and more.
Table of contents
- Servers
- Quickstart
- Install
- Connecting to a client
- Architecture & conventions
- Development
- Adding a new server
- Publishing
- Contributing
- License
Servers
More on the way: a Spotify controller, and others.
Quickstart
Install
Every server ships through every common channel. For the Claude Code plugin, add the marketplace
once — /plugin marketplace add Abhishekkumar2021/mcp-suite — then install per the table. See each
server's README for full config.
notesdefaults to~/notes;filesrequiresFS_ROOTS(the directories it may touch). MCPB bundles install via Claude Desktop → Settings → Extensions.
Connecting to a client
Each server's README has full configuration instructions. As an example, to use the notes server with Claude Code:
Or with Claude Desktop (claude_desktop_config.json):
Architecture & conventions
A few principles hold across every server:
- Pure-JS/WASM by default; native only when genuinely required. Servers run via
npx/MCPB on any machine, so portable pure-JS/WebAssembly is strongly preferred and a native dependency is used only when genuinely required (gated + documented). In practice these servers are dependency-light:notesuses MiniSearch + WebAssembly embeddings,sqluses thesql.jsWASM SQLite engine, andfilesusesfast-globinstead of ripgrep.npm auditstays clean. - Sandbox-first, layered design. Each server keeps a thin
index.ts(tool registration only) over focused modules, with a single security boundary every path must pass through (realpath-containment, symlink-escape rejection, atomic writes). - Token-efficient by default. Pagination, head/tail/section reads, snippets, and compact graph refs keep tool output small.
- Automated, hands-off releases. A GitHub Release tagged
<server>-v<version>publishes to npm (with provenance), the official MCP registry, and attaches an MCPB bundle — all via OIDC, no secrets. - Tested in CI. Each server ships a committed
node:testsuite (unit + integration/security) run on every push.
Development
This is an npm workspaces monorepo.
Adding a new server
- Create
servers/<name>/with its ownpackage.json(unique npmname) and atsconfig.jsonthatextends: "../../tsconfig.base.json". - Put source in
servers/<name>/src/. - Run
npm installat the root so the workspace picks it up. - Add a row to the Servers table above.
All servers follow the naming standard (@abhishekmcp/<slug>). See CONTRIBUTING.md for detailed guidelines.
Publishing
Releases are automated. Cutting a GitHub Release tagged <server>-v<version> triggers
publish.yml, which — authenticated entirely via GitHub OIDC (no
NPM_TOKEN) — publishes the package to npm with provenance, registers it on the official MCP
registry, and builds + attaches the MCPB bundle to the release.
Contributing
Contributions are welcome! Please read CONTRIBUTING.md and our Code of Conduct. Found a security issue? See SECURITY.md.
License
MIT © Abhishek
來源:README.md,提交 dec6a82
工具
0版本歷史
1- v0.1.0最新Sep 16, 2026
評分
已滿足適用檢查項的 50%
該評分衡量此收錄條目的完整程度,依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價,也不表示伺服器安全或目前可用:可連通性是帶日期的檢查結果,評分也不包含安裝量或使用者評價。
- 近 30 天內可連通25 分
請保持端點能夠回應 MCP 握手;SourceWeft 每 30 天探測一次。
- 已宣告認證方式10 分
請在註冊中心條目中宣告憑證請求標頭,或保持端點能夠回應探測,以便判定其認證方式。
- 已列出工具15 分
請讓伺服器在無憑證時回應 tools/list,或發布可在沙箱中無憑證啟動的軟體包。
- 描述必需15 分
- 圖示10 分
- 文件15 分
- 授權條款10 分