mcp-postgres

# Usage - Install latest Node.js. - Clone this repository. - Run command: `npm i && npm run build`. - Add configuration in you IDE or other supported AI agents. - In VScode: Configuration file path: `.vscode/mcp.json` ``` { "servers": { // you will see service start button here. "postgres": { "command": "node", "args": [ "/Users/xxx/project/personal/mcp-postgre/build/index.js" // the absolute path to your compiled JS file ], "env": { "POSTGRES_HOST": "localhost", "POSTGRES_PORT": "5432", "POSTGRES_DB": "postgres", "POSTGRES_USER": "postgres", "POSTGRES_PASSWORD": "123456", } } } } ``` - In Cursor You can also add configuration by UI in `Cursor Settings -> MCP`, or configuration file path: `.cursor/mcp.json`. ``` { "mcpServers": { "postgres": { "command": "node", "args": ["/Users/xxx/project/personal/mcp-postgre/build/index.js"], // the absolute path to your compiled JS file "env": { "POSTGRES_HOST": "localhost", "POSTGRES_PORT": "5432", "POSTGRES_DB": "postgres", "POSTGRES_USER": "postgres", "POSTGRES_PASSWORD": "123456" } } } } ``` - And then, you can switch your copilot to `Agent` mode and ask som questions in AI chat window. - If you are using Cursor, ask questions directly. - If you are using VScode, start server manuraly first in `mcp.json`. You can also use `Command` + `Shift` + `P`, and type `MCP` into input box to run some commands, including start and stop MCP servers.  > To avoid strange problems, make sure you are using the latest VScode and Cursor. > > See more details in `https://modelcontextprotocol.io/quickstart/server`