PostgreSQL MCP Server for VS Code

{
  "inputs": [
    {
      "type": "promptString",
      "id": "postgres-host",
      "description": "POSTGRES_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "postgres-port",
      "description": "POSTGRES_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "postgres-user",
      "description": "POSTGRES_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "postgres-password",
      "description": "POSTGRES_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "postgres-db",
      "description": "POSTGRES_DB",
      "password": true
    },
    {
      "type": "promptString",
      "id": "postgres-read-query-limit",
      "description": "POSTGRES_READ_QUERY_LIMIT",
      "password": true
    }
  ],
  "servers": {
    "postgresql-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "${input:postgres-host}",
        "POSTGRES_PORT": "${input:postgres-port}",
        "POSTGRES_USER": "${input:postgres-user}",
        "POSTGRES_PASSWORD": "${input:postgres-password}",
        "POSTGRES_DB": "${input:postgres-db}",
        "POSTGRES_READ_QUERY_LIMIT": "${input:postgres-read-query-limit}"
      }
    }
  }
}