devvault-mcp

A small MCP server that gives Claude Code structured access to DevVault's local Postgres database — inspect schema, run read-only queries, make guarded writes, and seed dummy data for testing.

Connection

DATABASE_URL is resolved in this order:

1. process.env.DATABASE_URL

2. DEVVAULT_ENV_PATH (path to an .env file), if set

3. ../devvault-backend/.env

So the DB password stays in the backend .env and is not duplicated into any MCP config.

Related MCP server: PostgreSQL MCP Server

Tools

Safety guards

• run_query rejects anything that isn't read-only and blocks statement stacking (;).

• run_write refuses DROP/TRUNCATE/ALTER/CREATE/GRANT/… and refuses UPDATE/DELETE with no WHERE clause, unless you pass allowDangerous: true.

• Writes run inside a transaction and roll back on error.

Registering with Claude Code

Already wired up via ../.mcp.json (project scope):

{
  "mcpServers": {
    "devvault-db": {
      "command": "node",
      "args": ["/Users/cookie/project-git/devvault_2/devvault-mcp/server.js"]
    }
  }
}

MCP servers load at Claude Code startup, so restart / reconnect the session for the devvault-db tools to appear.

Local checks (no MCP client needed)

npm install
node smoke.js     # connectivity + row counts
node mcptest.js   # full MCP handshake: list tools + call a few

Dummy data

Seed rows created by seed_dummy all have titles beginning with Dummy . To remove them:

DELETE FROM prompts  WHERE title LIKE 'Dummy %';
DELETE FROM commands WHERE title LIKE 'Dummy %';
DELETE FROM snippets WHERE title LIKE 'Dummy %';
DELETE FROM bookmarks WHERE title LIKE 'Dummy %';
DELETE FROM notes    WHERE title LIKE 'Dummy %';