
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 分