Skip to main content
Glama
Sign In
db-mcp-server

db-mcp-server

by stucchi
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

execute

Execute write queries on an SQLite database that is set to read-write mode, enabling data modification.

Instructions

Execute a write query on the SQLite database. Only works if the database is configured with mode='read-write'.

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "query": "<query>"
    },
    "name": "execute"
  }
}

Input Schema

NameRequiredDescriptionDefault
queryYes

Output Schema

NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv1.2.1

TDQS

B3.3/5.0
Behavior2/5

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

No annotations are provided, so the description must fully disclose behavioral traits. It confirms the tool is write-only (mutation) but fails to mention error behavior, transaction handling, return value format, or impact on database state. The existence of an output schema partially compensates, but the description itself lacks detail.

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 sentences, front-loaded with purpose and critical condition. No redundant information; every word is necessary.

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

Completeness2/5

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

For a tool with one required parameter, no annotations, and an output schema not described, the description is incomplete. It does not explain what the tool returns or error scenarios. While the output schema might cover return values, the agent cannot infer behavior from the description alone.

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

Parameters1/5

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

The input schema has zero description coverage for the 'query' parameter. The description merely refers to it as a 'write query' with no additional context on allowed SQL syntax, statement composition, or parameter handling. This provides minimal added value beyond the schema itself.

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 'Execute a write query on the SQLite database', specifying both the action (execute) and resource (SQLite database). It implicitly distinguishes from sibling tools like 'query' (likely read) and 'describe'/'list_tables' (schema exploration).

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 provides a clear condition: 'Only works if the database is configured with mode='read-write''. This tells agents when to use the tool and implicitly when not to (read-only mode). However, it does not explicitly name alternative tools for read operations.

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

Deploy Server

Other Tools