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 "Install 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-serverread 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: ABSD DevOps MCP Server
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.
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/iKennas/local-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server