AI-native PostgreSQL health checker. 23 MCP tools, CI integration, migration safety checks, multi-env diff, production readiness audit. Free, self-hosted.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add pg-dash --env POSTGRES_CONNECTION_STRING='<POSTGRES_CONNECTION_STRING>' -- npx -y -p @indiekitai/pg-dash pg-dash-mcp postgresql://user:pass@host/db~/.codex/config.toml
[mcp_servers.pg-dash]
command = "npx"
args = ["-y", "-p", "@indiekitai/pg-dash", "pg-dash-mcp", "postgresql://user:pass@host/db"]
env = { POSTGRES_CONNECTION_STRING = "<POSTGRES_CONNECTION_STRING>" }
# codex mcp add pg-dash --env POSTGRES_CONNECTION_STRING='<POSTGRES_CONNECTION_STRING>' -- npx -y -p @indiekitai/pg-dash pg-dash-mcp postgresql://user:pass@host/db~/.cursor/mcp.json
{
"mcpServers": {
"pg-dash": {
"command": "npx",
"args": [
"-y",
"-p",
"@indiekitai/pg-dash",
"pg-dash-mcp",
"postgresql://user:pass@host/db"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<POSTGRES_CONNECTION_STRING>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"pg-dash": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"-p",
"@indiekitai/pg-dash",
"pg-dash-mcp",
"postgresql://user:pass@host/db"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<POSTGRES_CONNECTION_STRING>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"pg-dash": {
"command": "npx",
"args": [
"-y",
"-p",
"@indiekitai/pg-dash",
"pg-dash-mcp",
"postgresql://user:pass@host/db"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<POSTGRES_CONNECTION_STRING>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"pg-dash": {
"command": "npx",
"args": [
"-y",
"-p",
"@indiekitai/pg-dash",
"pg-dash-mcp",
"postgresql://user:pass@host/db"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<POSTGRES_CONNECTION_STRING>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"pg-dash": {
"command": "npx",
"args": [
"-y",
"-p",
"@indiekitai/pg-dash",
"pg-dash-mcp",
"postgresql://user:pass@host/db"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<POSTGRES_CONNECTION_STRING>"
}
}
}
}Environment variables
POSTGRES_CONNECTION_STRING
Replace the placeholders with your own credentials and keep them out of version control.