detect_migration_state

Probe the database for migration tool tracker tables (Liquibase, Flyway, Alembic, Prisma, Knex, Sequelize, Django, Rails, Goose, TypeORM). Returns which tools are detected, the schema and table holding their state, the count of applied migrations, and the latest version. AI agents use this to imm...

Server Postgres teja-sudo/postgres-mcp-server
Category Read
Risk class Low
Parameters 00 required

What detect_migration_state does on Postgres

AI agents call detect_migration_state to retrieve information from Postgres without modifying anything — typically the context-gathering step in research, monitoring, and reporting workflows, before the agent takes action elsewhere.

Why detect_migration_state needs a policy

This tool performs schema discovery and metadata inspection—querying system tables to detect the presence of migration management tools and retrieve their state information. It has no side effects; it only reads and reports existing data. It does not execute migrations, modify tables, or trigger any operations.

From the tool's definition Tool probes and returns information about migration tracker tables: 'which tools are detected, the schema and table holding their state, the count of applied migrations, and the latest version.' Uses introspection verbs like 'probe' and 'returns' indicating…

Questions about detect_migration_state

What does the detect_migration_state tool do? +

Probe the database for migration tool tracker tables (Liquibase, Flyway, Alembic, Prisma, Knex, Sequelize, Django, Rails, Goose, TypeORM). Returns which tools are detected, the schema and table holding their state, the count of applied migrations, and the latest version. AI agents use this to immediately understand whether the DB is managed by a migration tool before suggesting changes. It is categorised as a Read tool in the Postgres MCP Server, which means it retrieves data without modifying state.

How do I enforce a policy on detect_migration_state? +

Register the Postgres MCP server in PolicyLayer and add a rule for detect_migration_state: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Postgres. Nothing to install.

What risk level is detect_migration_state? +

detect_migration_state is a Read tool with low risk. Read-only tools are generally safe to allow by default.

Can I rate-limit detect_migration_state? +

Yes. Add a rate_limit block to the detect_migration_state rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block detect_migration_state completely? +

Set action: deny in the PolicyLayer policy for detect_migration_state. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides detect_migration_state? +

detect_migration_state is provided by the Postgres MCP server (teja-sudo/postgres-mcp-server). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

// LOOK UP ANOTHER SERVER

Every MCP server has a record like this.

Type a name, get the same breakdown: verified identity, auth posture, risk grade, capabilities, recommended policy.

Teams ship this data inside their own products. See what a licence covers →

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.