pgmcp

PGMCP allows users to interact with their PostgreSQL databases using plain English, transforming natural language questions into structured SQL queries. This server facilitates seamless communication between AI assistants and databases, enabling users to retrieve information effortlessly without needing to write SQL code themselves. With robust error handling and automatic streaming of results, PGMCP enhances the user experience by providing quick and accurate responses to database queries.

{
  "mcpServers": {
    "pgmcp": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-pgmcp"
      ]
    }
  }
}