PgVouch MCP
PgVouch is an MCP server and CLI tool designed for safe PostgreSQL migrations. It enables AI assistants to perform read-only schema drift detection, lock analysis, safe rewrites, and data checksum verification. By wrapping AI suggestions in deterministic checks, it helps prevent outages caused by schema changes and ensures data integrity during migrations.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
What you can do with it
- Detect schema drift between environments
- Analyze table locks before migration
- Verify data integrity via checksums
- Plan safe database rewrites
Source and maintenance
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
pgvouch 0.4.4
{
"version": "0.4.4",
"transport": "stdio",
"identifier": "pgvouch",
"registryType": "npm",
"registryBaseUrl": "https://registry.npmjs.org",
"packageArguments": [
{
"type": "positional",
"value": "mcp"
}
],
"environmentVariables": [
{
"name": "SOURCE_DATABASE_URL",
"isRequired": true,
"description": "Read-only postgres:// URL of the reference database"
},
{
"name": "TARGET_DATABASE_URL",
"isRequired": true,
"description": "Read-only postgres:// URL of the database to check"
},
{
"name": "PGVOUCH_LLM",
"default": "none",
"description": "Optional planner LLM: none (default), ollama or gemini"
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Connect from your client
Each snippet configures the same source-provided package; replace placeholders before use.
Cursor
{
"mcpServers": {
"pgvouch-mcp": {
"command": "npx",
"args": [
"-y",
"pgvouch@0.4.4",
"mcp"
],
"env": {
"SOURCE_DATABASE_URL": "<YOUR_SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<YOUR_TARGET_DATABASE_URL>",
"PGVOUCH_LLM": "<YOUR_PGVOUCH_LLM>"
}
}
}
}Cline
{
"mcpServers": {
"pgvouch-mcp": {
"command": "npx",
"args": [
"-y",
"pgvouch@0.4.4",
"mcp"
],
"env": {
"SOURCE_DATABASE_URL": "<YOUR_SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<YOUR_TARGET_DATABASE_URL>",
"PGVOUCH_LLM": "<YOUR_PGVOUCH_LLM>"
}
}
}
}VS Code
{
"servers": {
"pgvouch-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"pgvouch@0.4.4",
"mcp"
],
"env": {
"SOURCE_DATABASE_URL": "<YOUR_SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<YOUR_TARGET_DATABASE_URL>",
"PGVOUCH_LLM": "<YOUR_PGVOUCH_LLM>"
}
}
}
}Claude Desktop
{
"mcpServers": {
"pgvouch-mcp": {
"command": "npx",
"args": [
"-y",
"pgvouch@0.4.4",
"mcp"
],
"env": {
"SOURCE_DATABASE_URL": "<YOUR_SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<YOUR_TARGET_DATABASE_URL>",
"PGVOUCH_LLM": "<YOUR_PGVOUCH_LLM>"
}
}
}
}Let your agent find its tools
Find servers like PgVouch MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.