postgres-mcp-server
0
This project is a Model Context Protocol server for PostgreSQL, designed to allow large language models (LLM) to interact with a local database. It is currently experimental and not recommended for use with real databases.
postgres-mcp-server
This is a PostgresSQL Model Context Protocol server to enable your LLM to interact with your local database. Warning: This is still experimental, so DO NOT use this on a real database and exercise caution with write queries!
Prerequisites
- Have nodeJS installed.
- Run
npm installto install the project dependencies. - Set the following environment variables:
- DATABASE_NAME
- DATABASE_USER
- DATABASE_PASSWORD
- DATABASE_SCHEMA_name
Easy config for VSCODE settings.json
The required configuration includes enabling MCP chat discovery and setting up environment variables for the PostgreSQL database.