Skip to main content
Glama

apply_migration_plan

Apply a reviewed migration plan atomically with forward SQL and rollback steps, using a stable name and review hash for consistent ledger updates.

Instructions

Apply a reviewed fully transactional migration and its ledger row atomically

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
nameYesStable migration name
stepsYesThe exact reviewed ordered statement pairs
review_hashYesExact 64-character review hash from create_migration_plan
timeout_secondsNo
lock_timeout_secondsNo
Behavior3/5

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

With no annotations, the description partially discloses behavior by stating 'fully transactional' and 'atomically', implying atomic commit/rollback. However, it does not specify whether locks are acquired, what happens on failure, or the effect on the ledger row beyond atomicity.

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, efficient sentence that conveys the core purpose without extraneous words. It is front-loaded and immediately actionable.

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?

Given 5 parameters, no output schema, and no annotations, the description is too brief. It fails to explain the review_hash requirement, timeout meaning, or what the tool returns on success/failure, leaving significant gaps for an agent.

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

Parameters2/5

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

The description adds no detail about parameters (name, steps, review_hash, timeouts) beyond what the schema provides. Schema coverage is 60%, but the description does not compensate for the missing descriptions of timeout_seconds and lock_timeout_seconds.

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 ('apply') and resource ('migration plan'), and adds the qualifiers 'reviewed', 'fully transactional', and 'ledger row atomically', which clearly distinguishes it from siblings like create_migration_plan and rollback_migration.

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

Usage Guidelines2/5

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

No guidance is provided on when to use this tool versus alternatives (e.g., create_migration_plan, rollback_migration). The description does not mention prerequisites or context for invocation.

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

Install Server

Other Tools

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/surajmandalcell/pgsql-mcp'

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