SQL MCP server
✓ VerifiedMemungkinkan AI client untuk melakukan query read-only dan introspeksi schema pada database Postgres dan SQLite dengan kapabilitas write yang terkontrol.
Juga dikenal sebagai Abhishekkumar2021/mcp-suite, @abhishekmcp/sql
- Stars
- 1
- Tools
- —
- Unduhan, 30 hari
- 180
- Versi terbaru
- 0.1.0
- Commit terakhir
- 4 Jul 2026
- Lisensi
- MIT
Apa itu SQL MCP?
SQL adalah MCP server. Memungkinkan AI client untuk melakukan query read-only dan introspeksi schema pada database Postgres dan SQLite dengan kapabilitas write yang terkontrol.
Ringkasan dibuat dari README proyek
Tentang SQL MCP server
Server ini memungkinkan developer yang bekerja dengan data relasional untuk melakukan query dan inspeksi struktur database langsung dari dalam AI client. Server ini menyediakan kemampuan untuk menjalankan query read-only dan introspeksi schema pada database Postgres dan SQLite. Desain server ini mengutamakan keamanan dengan menggunakan kapabilitas write yang terkontrol (gated), guna memastikan setiap modifikasi data tetap terjaga.
Anda dapat menghubungkan tool ini ke client seperti Claude Desktop, Claude Code, atau Cursor. Tool ini tersedia sebagai npm package untuk MCP client apa pun atau sebagai bundle MCPB untuk Claude Desktop. Khusus untuk SQLite, server ini memanfaatkan engine sql.js WASM untuk menjaga arsitektur yang portable dan ringan tanpa banyak dependency. Setup ini memungkinkan eksplorasi data dan analisis schema yang efisien tanpa memerlukan native dependencies yang berat.
Apa yang bisa Anda lakukan dengannya
- 1Analisis database schemaMinta AI untuk menjelaskan struktur tabel dan relasi di dalam database Postgres atau SQLite.
- 2Eksekusi query dataMinta AI untuk mengambil record spesifik atau melakukan agregasi data dari tabel SQL Anda.
- 3Melakukan update data terkontrolInstruksikan AI untuk memodifikasi entri database melalui proses gated yang aman.
Ditulis berdasarkan README proyek. Setiap use case diperiksa terhadap kutipan dari README tersebut.
Cara menginstal SQL MCP
Format diverifikasi 10 Nov 2026Tambahkan ke CursorTambahkan ke GooseInstal SQL MCP di Claude Code
$ claude mcp add --env 'DB_CONN_default=<YOUR_DB_CONN_default>' sql -- npx -y @abhishekmcp/sqlInstal SQL MCP di Cursor
~/.cursor/mcp.json
{
"mcpServers": {
"sql": {
"command": "npx",
"args": [
"-y",
"@abhishekmcp/sql"
],
"env": {
"DB_CONN_default": "<YOUR_DB_CONN_default>"
}
}
}
}Instal SQL MCP di VS Code
.vscode/mcp.json
{
"servers": {
"sql": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@abhishekmcp/sql"
],
"env": {
"DB_CONN_default": "<YOUR_DB_CONN_default>"
}
}
}
}Instal SQL MCP di VS Code CLI
$ code --add-mcp '{"name":"sql","type":"stdio","command":"npx","args":["-y","@abhishekmcp/sql"],"env":{"DB_CONN_default":"<YOUR_DB_CONN_default>"}}'Instal SQL MCP di Claude Desktop
claude_desktop_config.json
{
"mcpServers": {
"sql": {
"command": "npx",
"args": [
"-y",
"@abhishekmcp/sql"
],
"env": {
"DB_CONN_default": "<YOUR_DB_CONN_default>"
}
}
}
}Instal SQL MCP di Codex
$ codex mcp add sql --env 'DB_CONN_default=<YOUR_DB_CONN_default>' -- npx -y @abhishekmcp/sqlInstal SQL MCP di Codex config.toml
~/.codex/config.toml
[mcp_servers.sql] command = "npx" args = ["-y", "@abhishekmcp/sql"] [mcp_servers.sql.env] DB_CONN_default = "<YOUR_DB_CONN_default>"
Instal SQL MCP di Gemini CLI
$ gemini mcp add -s user -e 'DB_CONN_default=<YOUR_DB_CONN_default>' sql npx -- -y @abhishekmcp/sqlInstal SQL MCP di Gemini settings.json
~/.gemini/settings.json
{
"mcpServers": {
"sql": {
"command": "npx",
"args": [
"-y",
"@abhishekmcp/sql"
],
"env": {
"DB_CONN_default": "<YOUR_DB_CONN_default>"
}
}
}
}Konfigurasi
DB_CONN_defaultRahasiaConnection URL for the 'default' connection (postgres://… or sqlite:/abs/path). Additional connections use DB_CONN_<name>. Carries credentials — treated as secret.
DB_WRITABLESet to 1 or true to enable the write tools (execute, execute_script).
NOTES_DIR
| Nama | Deskripsi | Tipe |
|---|---|---|
| DB_CONN_default | Connection URL for the 'default' connection (postgres://… or sqlite:/abs/path). Additional connections use DB_CONN_<name>. Carries credentials — treated as secret. | Rahasia |
| DB_WRITABLE | Set to 1 or true to enable the write tools (execute, execute_script). | |
| NOTES_DIR | — |
Pengecekan otomatis
Berjalan 14 Nov 2026Laporan lengkap →Lolos checks otomatis kami. Ini bukan audit keamanan: baca kodenya dan berikan server akses paling terbatas yang dibutuhkannya. Cara kerja checks
- Source repository terhubung dan dapat dijangkauabhishekkumar2021/mcp-suite is public and reachablegithub.com/abhishekkumar2021/mcp-suite ↗Lolos
- Nama paket mencantumkan repositori ini sebagai sumbernya@abhishekmcp/sql names abhishekkumar2021/mcp-suite as sourcenpmjs.com/package/@abhishekmcp/sql ↗Lolos
- Provenance build (atestasi Sigstore)No build attestation published for this releaseTidak diperiksa
- Lisensi open source (OSI)MITspdx.org/licenses/MIT.html ↗Lolos
- Ada commit atau release dalam satu tahun terakhirLast commit or release 2026-07-04github.com/abhishekkumar2021/mcp-suite ↗Lolos
- OpenSSF ScorecardTidak diperiksa
- Nama package tidak mirip dengan package populerNo popular package one edit away from @abhishekmcp/sqlLolos
- Tidak ada advisory kritis pada paket atau dependensinya114 resolved dependencies checked; no critical advisoryosv.dev ↗Lolos
- Tidak ada instruksi tersembunyi untuk model0 tool descriptions and the README read; no override phrases, credential paths or hidden charactersLolos
- Tools yang bersifat destruktif telah diberi labelTidak diperiksa
- Endpoint remote merespons handshake MCPTidak diperiksa
README
Lihat di GitHub🧰 mcp-suite
A collection of Model Context Protocol servers, built in TypeScript.
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
| Server | Description | Status |
|---|---|---|
notes |
Local markdown notes: ranked full-text and semantic search, tags, todos, a [[wiki-link]] knowledge graph, daily notes + templates, and slash-command workflows (prompts) |
✅ Stable |
files |
Sandboxed local filesystem: read, glob + content search, token-efficient edits, copy/move, soft-delete trash, zip, checksums, and dedup | ✅ Stable |
github |
GitHub: search repos/code/issues, read repos/issues/PRs/files, notifications, create issues — OAuth device flow or token | ✅ Stable |
git |
Git: status, log, diff, file history, branches/tags, gated stage/commit, and remote clone/fetch/pull/push — pure-JS, no git binary | ✅ Stable |
sql |
SQL databases: read-only query + schema introspection over Postgres & SQLite, gated writes | ✅ Stable |
http |
HTTP/REST client: ad-hoc requests + saved collections/environments, env secrets, host-allowlisted + SSRF-safe | ✅ Stable |
More on the way: a Spotify controller, and others.
Quickstart
git clone https://github.com/Abhishekkumar2021/mcp-suite.git
cd mcp-suite
npm install # installs deps for every workspace
npm run build # builds every server
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.
| Server | Claude Code plugin | npm (any client) | Claude Desktop (MCPB) | MCP registry |
|---|---|---|---|---|
notes |
/plugin install notes |
npx -y @abhishekmcp/notes |
drag notes-*.mcpb from the latest release |
io.github.Abhishekkumar2021/notes |
files |
/plugin install files |
npx -y @abhishekmcp/files |
drag files-*.mcpb |
io.github.Abhishekkumar2021/files |
github |
/plugin install github |
npx -y @abhishekmcp/github |
drag github-*.mcpb |
io.github.Abhishekkumar2021/github |
git |
/plugin install git |
npx -y @abhishekmcp/git |
drag git-*.mcpb |
io.github.Abhishekkumar2021/git |
sql |
/plugin install sql |
npx -y @abhishekmcp/sql |
drag sql-*.mcpb |
io.github.Abhishekkumar2021/sql |
http |
/plugin install http |
npx -y @abhishekmcp/http |
drag http-*.mcpb |
io.github.Abhishekkumar2021/http |
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:
claude mcp add notes --env NOTES_DIR=$HOME/notes -- node "$(pwd)/servers/notes/dist/index.js"
Or with Claude Desktop (claude_desktop_config.json):
{
"mcpServers": {
"notes": {
"command": "node",
"args": ["/absolute/path/to/mcp-suite/servers/notes/dist/index.js"],
"env": { "NOTES_DIR": "/absolute/path/to/your/notes" }
}
}
}
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.
npm install # install all workspace dependencies (run once at the root)
npm run build # build every server
npm run build -w servers/notes # build a single server
npm test --workspaces --if-present # run each server's test suite
npm run clean # remove all build output
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.
# bump servers/<name>/package.json, commit, then:
gh release create <name>-v<version> --title "<name> v<version>" --notes "…"
Contributing
Contributions are welcome! Please read CONTRIBUTING.md and our Code of Conduct. Found a security issue? See SECURITY.md.
License
MIT © Abhishek
Pertanyaan tentang SQL MCP
Bagaimana cara menambahkan SQL MCP ke Claude Code?
Jalankan claude mcp add --env 'DB_CONN_default=<YOUR_DB_CONN_default>' sql -- npx -y @abhishekmcp/sql di terminal Anda. Tambahkan --scope user agar tersedia di semua proyek.
Bagaimana cara menambahkan SQL MCP ke Cursor?
Buka ~/.cursor/mcp.json dan tambahkan server di bawah mcpServers, menggunakan config Cursor yang ditunjukkan di bagian instalasi di atas.
Database apa saja yang didukung oleh SQL server ini?
Server ini mendukung query dan introspeksi schema untuk Postgres maupun SQLite.
Bagaimana engine SQLite diimplementasikan?
Server ini menggunakan engine sql.js WASM untuk fungsionalitas SQLite.