What are the runtime requirements for PostgreSQL MCP Server?
Node.js and npm are required. Access to a PostgreSQL database (host, port, credentials) is also needed.
PostgreSQL MCP Server
@assadnasser
Basic information
About PostgreSQL MCP Server
No overview available yet
PostgreSQL MCP Server config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryPostgreSQL MCP Server tools
47string
number
string
string
string
boolean (optional)
string
number
string
string
string
boolean (optional)
string
any[] (optional)
string
number
string
string
string
boolean (optional)
string
number
string
string
string
boolean (optional)
string
string (optional)
string
number
string
string
string
boolean (optional)
string
number
string
string
string
boolean (optional)
number (optional)
string
number
string
string
string
boolean (optional)
Overview
What is PostgreSQL MCP Server?
A Model Context Protocol (MCP) server that enables AI agents and applications to connect to PostgreSQL databases. It exposes resources, tools, and prompts for querying, managing schemas, and monitoring database activity via an SSE endpoint.
How to use PostgreSQL MCP Server?
Clone the repository, install dependencies (npm install), copy the .env.example to .env, configure environment variables (e.g., PGHOST, PGUSER, PGPASSWORD), and start the development server with npm run dev. Connect via the SSE endpoint at /sse and use the provided tools and prompts to interact with your PostgreSQL database.
Key features of PostgreSQL MCP Server
- Secure PostgreSQL connections with connection pooling and SSL
- SQL query execution with parameter binding and history tracking
- Schema exploration: list tables, describe columns, keys, indexes
- Database analytics: size, activity, and query performance stats
- API rate limiting and CORS support for security
- Graceful shutdown handling and Redis-backed storage option
Use cases of PostgreSQL MCP Server
- Query a PostgreSQL database using natural language descriptions
- Explore table schemas and column metadata without direct SQL
- Monitor database activity and query performance programmatically
- Automate database management tasks through MCP-enabled agents
Frequently asked questions
How does the server handle database credentials?
Credentials (host, port, user, password, database name) are passed as parameters to the MCP tools (e.g., `query`, `test-connection`) in each request.
Where is query history stored?
By default, query history is stored in memory. If `REDIS_URL` is provided, history is persisted in Redis.
Can I deploy PostgreSQL MCP Server to production?
Yes. The server is compatible with Vercel deployment. For production, configure a Redis URL for persistent storage.
What MCP capabilities does the server expose?
It exposes resources (database schema, table structure, query history), tools (execute SQL, list tables, describe table, get stats, clear history), and prompts (generate query, analyze query, explain schema).
More Databases MCP servers
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
1.9K
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
1.3K
Schemity
tbsonLocal database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
539
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero540
Comments