local-mcp-server
Provides tools for querying and executing SQL against SQLite databases defined via named aliases in the configuration, with restrictions on DROP/ALTER statements.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@local-mcp-server read the contents of my TODO.md file"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
local-mcp-server
A stdio MCP server that exposes local file I/O, a small shell whitelist, and SQLite helpers. Built for wiring Cursor/Claude Desktop to stuff on your machine without giving the model full shell access.
Setup
npm install
npm run build
cp config.example.json config.json
# edit allowedRoots to match your machineAdd to your MCP client config (Cursor example):
{
"mcpServers": {
"local": {
"command": "node",
"args": ["D:/path/to/local-mcp-server/dist/index.js"],
"env": {
"LOCAL_MCP_CONFIG": "D:/path/to/local-mcp-server/config.json"
}
}
}
}Related MCP server: local-os-brain
Tools
Tool | What it does |
| Scoped to |
| Host stats, no secrets |
| Whitelist only: |
| SQLite via named aliases in config |
Limitations
File access is path-jail'd but still powerful — don't point
allowedRootsat$HOME.Shell tool is intentionally useless for real admin work.
db_execblocksDROP/ALTER; everything else is on you.Windows:
unamewon't work unless you have it installed.
Dev
npm run dev # tsx, stdio — hard to debug interactively
npm testMIT licensed. PRs welcome for additional read-only system probes.
Available Tools
7 toolsdb_execC
Run a mutating SQL statement (INSERT/UPDATE/DELETE)
Inputs: alias (required), sql (required), params.
db_queryA
Run a read-only SQL query against a configured SQLite database
Inputs: alias (required), sql (required), params.
list_dirB
List entries in a directory
Inputs: path.
read_fileC
Read a text file from an allowed directory
Inputs: path (required).
run_commandC
Run a whitelisted shell command (no pipes)
Inputs: command (required), args.
system_infoA
Return basic host information
Inputs: no named parameters.
write_fileC
Write text to a file (creates parent dirs)
Inputs: path (required), content (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 7 tools
Each tool has a clear, distinct purpose: database operations separate read and write, file operations are split into listing, reading, and writing, and shell commands are distinct from system info. No overlapping responsibilities.
All tool names follow a consistent verb_noun pattern (e.g., db_query, list_dir, run_command), making the set predictable and easy to navigate.
With 7 tools, the server covers a broad range of basic local operations (database, file system, shell) without being bloated or insufficient. The scope is well-matched to a general-purpose utility server.
The tool surface covers essential CRUD-like operations for databases and files, plus command execution and system info. Minor gaps exist, like no explicit file deletion or directory creation, but write_file creates parent directories and the set is functional for common tasks.
Maintenance
Related MCP Connectors
Use your Mac, Windows or Linux computer from ChatGPT, Claude or Codex: files, commands, documents.
Operate Linux, macOS and Windows from your LLM. Every action runs through an auditable allowlist.
Work on your own computers from Claude or ChatGPT: run commands, edit and search files.
Connect ChatGPT, Claude, Cursor or VS Code to your Windows PC: files, terminal, browser, apps.
Related MCP Servers
- AlicenseAqualityDmaintenanceProvides filesystem, web search, SQLite, and system tools for AI assistants like Claude, enabling secure access to local resources and the web.6MIT
- FlicenseNot gradedqualityCmaintenanceEnables safe local system command execution, file operations, hardware diagnostics, and persistent cross-session memory storage via SQLite.1-
- FlicenseNot gradedqualityAmaintenanceExposes a governed, OAuth-gated suite of 38 tools that let web AI assistants like Claude, ChatGPT, and Grok work directly on your local machine — reading and editing files, running whitelisted shell commands, searching, querying SQLite, driving browsers and DevTools, managing background tasks and localhost services, and controlling Git, clipboard, notifications, and Postman. This lets users build, debug, and maintain projects, inspect databases and local APIs, and check on long-running jobs from a browser or phone without granting unrestricted shell access.-
- AlicenseNot gradedqualityBmaintenanceExposes a governed, OAuth-gated set of tools that let web-based AI chat clients read and write local files, run whitelisted shell commands, search code, inspect Git and SQLite data, automate browsers and DevTools, and manage background jobs, localhost services, clipboard, notifications, and Postman on the user's own machine.MIT