PostgreSQL server with catalog introspection, validated query execution, index tuning and pgvector, TimescaleDB and AGE support.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add mcpg -- uvx mcpg~/.codex/config.toml
[mcp_servers.mcpg]
command = "uvx"
args = ["mcpg"]
# codex mcp add mcpg -- uvx mcpg~/.cursor/mcp.json
{
"mcpServers": {
"mcpg": {
"command": "uvx",
"args": [
"mcpg"
]
}
}
}.vscode/mcp.json
{
"servers": {
"mcpg": {
"type": "stdio",
"command": "uvx",
"args": [
"mcpg"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"mcpg": {
"command": "uvx",
"args": [
"mcpg"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"mcpg": {
"command": "uvx",
"args": [
"mcpg"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"mcpg": {
"command": "uvx",
"args": [
"mcpg"
]
}
}
}