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).
「データベース」の他のコンテンツ
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
1.3K
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
mcp-server-qdrant: A Qdrant MCP server
qdrantAn official Qdrant Model Context Protocol (MCP) server implementation
637
golfdata.online - Verified Golf Clubs
golfdata.onlineVerified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
3.1K
コメント