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
基本信息
关于 PostgreSQL MCP Server
暂无概览
PostgreSQL MCP Server 配置
PostgreSQL MCP Server 工具
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)
概览
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
常见问题
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).
数据库 分类下的更多 MCP 服务器
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
498
MCP Alchemy
runekaagaardA MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.
412
Expired Domains MCP | Karma.Domains
karma-domainsConnect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note
Database Gateway
centralmindUniversal MCP-Server for your Databases optimized for LLMs and AI-Agents.
531
Sqlite
modelcontextprotocolModel Context Protocol Servers
88.1K
评论