Skip to main content
Glama

Preview migration SQL (structured)

liquibase_update_sql
Read-only

Render the SQL Liquibase would run for pending changesets as structured per-changeset summaries with SQL Server batch linting; preview only, no changes applied.

Instructions

Render the SQL Liquibase would run for pending changesets (updateSQL) as structured per-changeset summaries with a SQL-Server batch lint. Does NOT apply changes. SQL bodies are omitted unless includeRaw or changesetId is set. liquibase is on PATH — no mise/wrapper needed.

Input Schema

NameRequiredDescriptionDefault
cwdNoDirectory to run liquibase in (where the defaults file / changelog live).
labelsNoLabel expression to filter changesets (--labels).
contextsNoContext expression to filter changesets (--contexts).
maxItemsNoItem cap; overrides detailLevel
batchLintNoLint each changeset for the SQL-Server 'routine DDL must lead its GO-batch' rule (default true).
extraArgsNoAdditional raw arguments appended to the liquibase invocation.
includeRawNoInclude raw/verbose fields
changesetIdNoReturn only this changeset's full rendered SQL (matches the changeset id).
detailLevelNoItem preset: summary 20, normal 100, full (default; also skips the response budget)
defaultsFileNoPath to the Liquibase defaults file (--defaults-file), e.g. db-dev.properties. Usually carries the JDBC URL, credentials, and changelog path.
changelogFileNoChangelog path (--changelog-file); usually set in the defaults file instead.

Output Schema

NameRequiredDescriptionDefault
totalNo
retainedNo
truncatedNo
changesetsYes
changesetCountYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv5.0.1

TDQS

A4.7/5.0
Behavior5/5

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

Beyond the readOnlyHint annotation, the description discloses key behavior: output is structured per changeset, a SQL-Server batch lint is included, and SQL bodies are omitted unless includeRaw or changesetId is set. It also clarifies the environment expectation that liquibase is on PATH and no wrapper is needed.

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 three tightly written sentences with the core behavior front-loaded. Every sentence contributes useful information: purpose, non-mutation guarantee, output omission rules, and environment note.

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?

For a complex 11-parameter tool with a full schema and an output schema, the description supplies the essential behavioral context an agent needs. It covers purpose, safety, output shape, SQL omission rules, linting, and environment assumptions without duplicating schema documentation.

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 coverage is 100%, so the baseline is 3. The description adds important cross-parameter meaning by explaining that SQL bodies are omitted unless includeRaw or changesetId is set, which is not obvious from the individual schema fields alone.

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 and resource: render the SQL Liquibase would run for pending changesets as structured per-changeset summaries. It also clearly distinguishes this preview operation from applying changes by stating 'Does NOT apply changes.'

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 establishes clear context for previewing pending migration SQL and explicitly notes that it does not apply changes. It does not name sibling alternatives such as liquibase_status or liquibase_validate, so the when-to-use guidance is strong but not exhaustive.

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