PgVouch
Safe PostgreSQL migrations: schema drift, lock analysis, safe rewrites, data checksums…
- Pricing
- Open source
- Runs
- Locally
- Version
- 0.4.4
- Listing updated
- 2 months ago
About PgVouch
PgVouch is an open-source MCP server. It runs locally on your machine and is started by your AI client.
Safe PostgreSQL migrations: schema drift, lock analysis, safe rewrites, data checksums. Read-only.
Install
Run in a terminal
claude mcp add pgvouch --env SOURCE_DATABASE_URL='<SOURCE_DATABASE_URL>' --env TARGET_DATABASE_URL='<TARGET_DATABASE_URL>' -- npx -y pgvouchAdd to claude_desktop_config.json
{
"mcpServers": {
"pgvouch": {
"command": "npx",
"args": [
"-y",
"pgvouch"
],
"env": {
"SOURCE_DATABASE_URL": "<SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<TARGET_DATABASE_URL>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"pgvouch": {
"command": "npx",
"args": [
"-y",
"pgvouch"
],
"env": {
"SOURCE_DATABASE_URL": "<SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<TARGET_DATABASE_URL>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"pgvouch": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"pgvouch"
],
"env": {
"SOURCE_DATABASE_URL": "<SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<TARGET_DATABASE_URL>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"pgvouch": {
"command": "npx",
"args": [
"-y",
"pgvouch"
],
"env": {
"SOURCE_DATABASE_URL": "<SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<TARGET_DATABASE_URL>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"pgvouch": {
"command": "npx",
"args": [
"-y",
"pgvouch"
],
"env": {
"SOURCE_DATABASE_URL": "<SOURCE_DATABASE_URL>",
"TARGET_DATABASE_URL": "<TARGET_DATABASE_URL>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
SOURCE_DATABASE_URLRead-only postgres:// URL of the reference databaseRequiredTARGET_DATABASE_URLRead-only postgres:// URL of the database to checkRequiredPGVOUCH_LLMOptional planner LLM: none (default), ollama or gemini
Pricing
Open source
PgVouch FAQ
Is PgVouch free?
Yes. PgVouch is open source, so you can use and self-host it for free.
How do I add PgVouch to Claude Code?
Run this command in your terminal: claude mcp add pgvouch --env SOURCE_DATABASE_URL='<SOURCE_DATABASE_URL>' --env TARGET_DATABASE_URL='<TARGET_DATABASE_URL>' -- npx -y pgvouch
Where this comes from
- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.