Skip to main content
Glama

db_execute

Run SQL (CREATE TABLE / INSERT / UPDATE / DELETE / ALTER) against this workspace's own database. Use db.schema first to see what exists, and db.query to read.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sqlYesSQL DDL/DML, e.g. CREATE TABLE records (id serial primary key, name text)
in_workspaceNoRun this one call in this workspace id instead of the session's. Nothing is stored; other sessions are not affected.

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed1 schema field changed
    • addedInput schema / properties / in_workspace
      Added value: +{
      +  "description": "Run this one call in this workspace id instead of the session's. Nothing is stored; other sessions are not affected.",
      +  "type": "integer"
      +}
  2. Added

TDQS

A3.8/5.0
Behavior1/5

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

The annotations declare destructiveHint=false, yet the description explicitly advertises DELETE and ALTER — irreversible data loss and schema mutation against a live database. An agent reading both gets directly conflicting safety signals about whether this call can destroy data, which is the highest-stakes fact for this tool. The dot-notation references ("db.schema", "db.query") also do not match the real sibling names db_schema/db_query.

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, zero filler, with the operation scope front-loaded ahead of the routing advice. Every clause earns its place.

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 2-parameter write tool with no output schema and full schema coverage, the description covers purpose, scope and sequencing adequately; return behavior need not be explained. It stops short of the completeness bar because it leaves the destructive/irreversible consequences of DELETE/ALTER unstated and conflicts with the safety annotations.

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 description coverage is 100% and both parameters are documented in the input schema, including the in_workspace isolation semantics ("Nothing is stored; other sessions are not affected"). The description adds no parameter-level detail of its own, so the baseline 3 applies.

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?

States a specific verb (Run SQL) plus the exact resource and scope: DDL/DML against "this workspace's own database," and enumerates the operations (CREATE TABLE / INSERT / UPDATE / DELETE / ALTER). It also positions itself against db_query (read) and db_schema (inspect), so an agent can distinguish it from its closest siblings without opening a schema.

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

Usage Guidelines5/5

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

Gives explicit sequencing and routing: "Use db.schema first to see what exists, and db.query to read." This is a when-to-use and when-to-use-something-else statement in one sentence, which is exactly what an agent needs to pick between db_execute, db_schema and db_query.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.