Skip to main content
Glama
cookieark7

DevVault MCP

by cookieark7

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

Tool

Purpose

db_info

Which database/user we're connected to (no credentials shown).

list_tables

Public tables + approximate row counts.

describe_table

Columns (name, type, nullable, default) for a table.

count_rows

Exact row counts for the main DevVault tables.

run_query

One read-only statement (SELECT/WITH/EXPLAIN/SHOW), run in a READ ONLY transaction. Supports $1,$2… params.

run_write

One INSERT/UPDATE/DELETE. DDL and unscoped UPDATE/DELETE (no WHERE) are refused unless allowDangerous=true.

seed_dummy

Insert dummy rows (valid cuid ids + timestamps) into snippets/bookmarks/notes/commands/prompts, attached to existing users.

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 %';

Available Tools

7 tools
count_rowsCount rowsB

Exact row counts for the main DevVault tables.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

B3.4/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden. It states the tool returns exact counts but reveals no behavioral details such as whether it is read-only, requires permissions, or has performance implications. It does not mention any side effects or limitations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, clear sentence that is front-loaded and concise. Every word serves a purpose, with no fluff or repetition.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool is simple (no parameters, no output schema), the description covers the core purpose. However, it lacks additional context such as the return format or specific tables included, which could be helpful. It is adequate but not exhaustive.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has zero parameters, and the schema coverage is 100% (none). The description does not need to explain parameters, as there are none. The description adds context about what is counted (main tables), which is clear.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool provides 'exact row counts for the main DevVault tables,' which identifies the specific verb ('count') and resource ('main DevVault tables'). It is not a tautology and differentiates from siblings like run_query or db_info, though it does not explicitly name alternatives.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies usage for getting table sizes, but does not specify when to use this over run_query or db_info. There is no explicit guidance on when not to use it or mention of alternatives, making it less explicit than ideal.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

db_infoDatabase infoA

Show which database this server is connected to (host/db only, no credentials).

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A4.5/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full behavioral burden. It discloses the informational/read-only nature of the operation and explicitly notes that credentials are not exposed, which is a valuable safety detail for an unannotated tool.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is one clear, front-loaded sentence. It communicates purpose and scope without filler or redundancy, and every word adds value.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

This is a low-complexity, zero-parameter informational tool. The description is sufficient context: it states what is shown and explicitly excludes credentials; no deeper output contract is necessary for such a simple operation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has zero parameters, so the baseline of 4 applies. The description correctly adds no misleading parameter details because there are no parameters to explain.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb ('Show') and clearly identifies the resource ('which database this server is connected to') with explicit scope ('host/db only'). This clearly separates it from query/run/write/listing sibling tools.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies a clear use case: when you need to know what database the server is connected to. It also explicitly notes that credentials are excluded, giving a boundary, though it does not explicitly name alternative tools for other database operations.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

describe_tableDescribe tableA

Show columns (name, type, nullable, default) for a table.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYesTable name, e.g. "snippets"

TDQS

A3.8/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the burden of conveying safety. The word 'Show' implies a read-only operation, which is useful, but it does not disclose error behavior (e.g., what happens if the table doesn't exist) or whether any side effects occur. The description adds minimal behavioral context beyond the obvious read-only intent.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, front-loaded sentence that states the action and the output attributes without any wasted words. It is appropriately concise for the tool's simplicity.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The tool is simple (one parameter, no output schema, no annotations), and the description covers the essential aspects: what it does and what fields are returned. It lacks details like error handling or prerequisites, but given the low complexity, it is nearly complete. The mention of returned columns compensates for the absence of an output schema.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema provides 100% coverage for the single 'table' parameter with a clear description and example ('Table name, e.g. "snippets"'). The tool description does not add additional parameter semantics beyond what the schema already includes, so the baseline of 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses the specific verb 'Show' with the resource 'columns for a table', listing the exact attributes returned (name, type, nullable, default). This clearly distinguishes it from sibling tools like list_tables (which lists tables) and count_rows (which counts rows).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The purpose is implicitly clear from the description: use this tool to inspect a table's schema. However, there is no explicit guidance on when to choose this over alternatives like run_query or list_tables, nor any mention of prerequisites (e.g., table existence or permission requirements).

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_tablesList tablesA

List public tables with their live row estimates.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A4.2/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It discloses scope ('public tables') and the behavioral nuance of 'live row estimates,' but it does not mention output shape, ordering, or potential cost. This is adequate but not rich.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

A single front-loaded sentence that communicates the tool's purpose, scope, and a key behavioral detail without any wasted words.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The tool is simple and has no parameters, and the description covers what the tool returns at a high level ('public tables with live row estimates'). It is complete enough for typical selection, though output details are left unspecified.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

There are zero parameters, so the baseline is 4. The description adds nothing about parameters because there is nothing to add; schema coverage is trivially complete.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb ('List') and resource ('public tables') and adds the scope of 'live row estimates,' making the tool's purpose distinct from siblings like describe_table and count_rows.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The context is clear: use this to enumerate public tables and see approximate row counts. It does not explicitly state when to prefer alternatives, but the scope and phrasing make the intended use obvious for a zero-parameter listing tool.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

run_queryRun read-only queryA

Run a single read-only SQL statement (SELECT/WITH/EXPLAIN/SHOW). Executes inside a READ ONLY transaction. Use $1, $2… placeholders with params.

ParametersJSON Schema
NameRequiredDescriptionDefault
sqlYesA single read-only SQL statement.
limitNoMax rows to return (default 500).
paramsNoPositional parameters for $1, $2, …

TDQS

A4.7/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, but the description explicitly states it executes within a read-only transaction, clarifying side-effects and parameter usage, providing transparency about behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is concise, consisting of three sentences conveying the essential information without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the schema covers parameters, the description covers purpose, behavior, and parameter usage, making it complete for the tool's scope.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The description adds context by explaining that $1, $2 placeholders are used with the params parameter, and reiterates the read-only nature, complementing the schema descriptions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states it runs a read-only SQL statement, specifying allowed statement types (SELECT/WITH/EXPLAIN/SHOW), distinguishing it from write operations.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It specifies the tool is for read-only queries, implying use for data retrieval, and explains parameter placeholder usage, but does not explicitly mention when not to use or alternatives, though the sibling 'run_write' is evident.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

run_writeRun write statementA

Run a single INSERT/UPDATE/DELETE. DDL (DROP/TRUNCATE/ALTER/…) and unscoped UPDATE/DELETE (no WHERE) are refused unless allowDangerous=true. Add "RETURNING *" to see affected rows.

ParametersJSON Schema
NameRequiredDescriptionDefault
sqlYesA single write statement.
paramsNoPositional parameters for $1, $2, …
allowDangerousNoOverride guards for DDL / unscoped writes.

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the burden of disclosing side effects. It clearly indicates this performs writes surfaces safety guards, and explains how to obtain returned rows, covering the key runtime behaviors.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two concise sentences, front-loaded with the core purpose and immediately followed by critical constraints. Zero filler or redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a write tool with no output schema, the description covers the essential behavior (what it executes), safety guards, and return-value control. Minor gap: no statement about what happens without RETURNING (e.g., whether affected row count is returned), but this is acceptable.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema has 100% coverage, but the description adds valuable context: allowDangerous overrides guards and RETURNING usage. This goes beyond the schema's simple field descriptions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool runs a single INSERT/UPDATE/DELETE statement, with a specific verb and resource. It distinguishes from siblings like run_query (reads) and other DB introspection tools.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides explicit safety constraints (refuses DDL/unscoped writes unless allowDangerous=true) and practical guidance (add RETURNING to see rows). While it doesn't explicitly name alternatives like run_query, the scope is clear.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

seed_dummySeed dummy dataA

Insert dummy rows (with valid cuid ids + timestamps) into snippets/bookmarks/notes/commands/prompts, attached to existing users. Great for filling the empty prompts/commands tables. Returns how many rows were inserted.

ParametersJSON Schema
NameRequiredDescriptionDefault
notesNo
userIdNoAttach everything to this user id. Default: spread across all users.
promptsNo
commandsNo
snippetsNo
bookmarksNo

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It discloses that it inserts rows, uses valid cuid ids and timestamps, attaches to existing users, and returns the number of rows inserted. This gives the agent a solid understanding of side effects, though it could have mentioned edge cases like what happens if no users exist.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is only two sentences long, gets straight to the point, and uses no fluffy language. Every word adds value, making it easy for the agent to parse quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a seeding tool with no output schema and no annotations, the description covers the essential aspects: purpose, attachment behavior, and return value. It doesn't address idempotency or validation, but those may not be critical for a dummy data seeder in this context.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is low (17%, only userId has a description). The description partially compensates by listing the target tables ('snippets/bookmarks/notes/commands/prompts') that match the parameter names, implying each parameter is a count. However, it doesn't explicitly state that the integer values represent row counts per table, leaving some ambiguity for the agent.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses the specific verb 'Insert' and enumerates the exact resources ('snippets/bookmarks/notes/commands/prompts'), clearly defining what the tool does. It differentiates itself from siblings like run_query and db_info by focusing on populating tables with dummy data. The title and description align perfectly.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The phrase 'Great for filling the empty prompts/commands tables' provides a concrete scenario for when to use the tool. It doesn't explicitly mention alternatives, but the sibling tools are distinct enough that the intended usage is clear without further explanation.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. 7 tool updatesv1.0.0
    • First observedcount_rows
    • First observeddb_info
    • First observeddescribe_table
    • First observedlist_tables
    • First observedrun_query
    • First observedrun_write
    • First observedseed_dummy

TDQS

A4/5.0
Disambiguation4/5

Most tools have distinct purposes: querying, writing, seeding, and introspection. However, run_query and run_write are clear opposites, and count_rows overlaps slightly with db_info/list_tables in terms of database introspection, though they serve different specific needs.

Naming Consistency5/5

All tool names use a consistent verb_noun pattern: run_query, run_write, seed_dummy, db_info, list_tables, describe_table, count_rows. Each name clearly indicates the action and the target, making the set highly predictable.

Tool Count4/5

With 7 tools, the count is well within the ideal range for a database management server. Each tool covers a core operation (query, write, seed, introspect), and none feel redundant. A couple more tools for advanced operations (e.g., transactions, backups) could be added, but the current count is appropriate.

Completeness4/5

The server covers essential database operations: querying, writing, seeding dummy data, and introspection (list tables, describe schema, row counts). It lacks tools for schema modification or data deletion scoped by ID, but the primary workflows for development (read, write, seed, introspect) are well covered.

Maintenance

ActivityMaintained
ResponsivenessNo issues

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • F
    license
    Not graded
    quality
    D
    maintenance
    Provides read-only access to PostgreSQL databases with schema inspection, query execution in multiple formats (JSON, CSV, Markdown), and query history tracking with built-in security features.
    -
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables AI assistants to query and manage local PostgreSQL databases through SQL execution and schema exploration tools. It supports both read-only queries and write operations including table creation and data modification via natural language.
    29
    ISC
  • A
    license
    A
    quality
    D
    maintenance
    Enables Claude to interact with a local PostgreSQL database through SQL queries, schema inspection, and CRUD operations.
    8
    121
    MIT
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables safe interaction with PostgreSQL databases through read-only queries, schema exploration, and performance analysis.
    121
    MIT

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/cookieark7/devvault-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server