PostgreSQL (MCP) MCP Server
Query and manage PostgreSQL databases directly from your AI agent. Read schemas, run queries, and manage data.
Quick Start Summary
The PostgreSQL (MCP) MCP server is a Model Context Protocol bridge that connects AI assistants — including Claude Desktop, Cursor, Windsurf, and VS Code Copilot — to the PostgreSQL (MCP) API through natural language. It exposes 2 API endpoints as callable tools, such as Execute SQL query, Get database schema. Authentication requires Database Credentials credentials, and setup takes approximately 2 minutes. The server uses STDIO transport and can be installed by running npx -y @modelcontextprotocol/server-postgres. This integration is sourced from the official PostgreSQL (MCP) OpenAPI specification (v16) and has a quality score of 70/99 (fair documentation coverage).
Server Details
- Category
- Databases
- Authentication
- Database Credentials
- Endpoints
- 2 operations
- Transport
- STDIO
- Spec Version
- v16
- Install Command
npx -y @modelcontextprotocol/server-postgres
Environment Variables
DATABASE_URLExample: postgresql://user:pass@host:5432/db
Top Endpoints
/queryExecute SQL query
/schemaGet database schema
Read the Guide
Step-by-step walkthrough for setting up and using the PostgreSQL (MCP) MCP server.
PostgreSQL (MCP)MCP Setup Guide →One-Click Install
Copy the snippet for your MCP client and paste it in — zero editing required.
Claude Desktop
Add to claude_desktop_config.json
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres"
],
"env": {
"DATABASE_URL": "postgresql://user:pass@host:5432/db"
}
}
}
}Cursor
Settings → MCP Servers → Add
{
"mcpServers": {
"postgres": {
"url": "https://mcpbridge.org/config/postgres.json"
}
}
}Saves as .cursor/mcp.json in the download. Move it to your project root.
VS Code
Use with MCP extension
{
"mcpServers": {
"postgres": {
"url": "https://mcpbridge.org/config/postgres.json"
}
}
}Endpoints Explorer
Search and browse the 2 operations supported by this server.
Multi-Language Code Examples
Executable code snippets for calling PostgreSQL (MCP) endpoints in curl, TypeScript, or Python.
curl -X POST "https://api.example.com/query" \ -H "Content-Type: application/json" \ -H "Authorization: YOUR_API_KEY"
Manual Configuration
Directly add this block to your JSON config file, or use the hosted config registry URL.
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["-y","@modelcontextprotocol/server-postgres"],
"env": {
"DATABASE_URL": "postgresql://user:pass@host:5432/db"
}
}
}
}Authentication Details
This API requires Database Credentials credentials.
Variables to configure:
DATABASE_URL
Documentation Links
Error Handling & HTTP Status Code Matrix
Common status codes, error causes, and resolution steps when invoking PostgreSQL (MCP) endpoints.
400 Bad RequestCause: Malformed payload parameters or missing required fields.
Resolution: Verify request schema in Endpoints tab before calling tool.
401 UnauthorizedCause: Missing or invalid API key credentials.
Resolution: Set environment variable in MCP client config under env object.
403 ForbiddenCause: Insufficient scope permissions for requested resource.
Resolution: Verify key permissions in developer dashboard.
404 Not FoundCause: Resource URL path or requested entity ID does not exist.
Resolution: Check path variables and parameters.
429 Rate Limit ExceededCause: API rate limit quota exceeded.
Resolution: Implement exponential backoff retry in tool call.
500 Internal ErrorCause: Upstream server runtime fault.
Resolution: Inspect STDIO stderr output for log trace.
Quality Score
Checked against our protocol-compliance rules.
Specification Version: v16
Page compiled on: June 13, 2026
This listing has been claimed and verified by the API owner.
Similar APIs
Other APIs in the Databases category.
Notion API
The Notion API is a comprehensive RESTful interface provided by Notion, the popular all-in-one workspace platform, enabling programmatic interaction with its rich set of collaborative objects. It grants developers and automated systems the ability to read, create, update, and manage core Notion entities such as blocks (the fundamental building blocks of content like text, lists, and media), databases (structured tables with properties), pages (containers for content and databases), and comments. Typical use cases span enterprise and consumer scenarios, including automating team workflows, syncing data between Notion and other business systems (like CRM, project management, or analytics tools), building custom dashboards, generating dynamic reports, and enhancing content collaboration through programmatic updates. Organizations leverage this API to break down data silos, enforce process automation, and create tailored integrations that extend Notion's native capabilities for specific departmental or cross-functional needs.
Amazon CloudWatch Application Insights
Amazon CloudWatch Application Insights is a specialized observability service provided by Amazon Web Services (AWS) designed to simplify the monitoring and troubleshooting of applications, particularly those built on Microsoft IIS and .NET frameworks running on EC2 instances or within Elastic Beanstalk environments. Its core capability lies in automatically discovering application components, analyzing correlated metrics, logs, and traces to identify anomalies, and then surfacing actionable insights that pinpoint the root cause of common operational issues. By integrating seamlessly with other AWS services like CloudWatch, AWS X-Ray, and AWS Systems Manager, it provides a unified view of application health, reducing the mean time to resolution (MTTR) for performance degradations and errors. The typical use case spans enterprise environments managing distributed microservices or monolithic .NET applications, where teams need to proactively detect issues such as memory leaks, high CPU utilization, or specific application errors without manually configuring complex monitoring dashboards and alarms.
Application Auto Scaling
The Application Auto Scaling API, provided by Amazon Web Services (AWS), is a robust service designed to automate the scaling of computing resources for a wide array of AWS services, ensuring optimal performance, availability, and cost efficiency. Its core capability is to define policies that automatically adjust the provisioned capacity of supported resources in response to changing demand, as measured by CloudWatch metrics or predefined schedules. Beyond the initially listed resources, it supports scaling for Amazon DynamoDB tables and global secondary indexes, Amazon ECS services running on Fargate or EC2, Amazon ElastiCache replication groups, Amazon Neptune clusters, Amazon SageMaker endpoint variants, and custom resources via the AWS Lambda-backed scalable target. This makes it a central tool for architects and DevOps engineers in building resilient, self-optimizing cloud architectures. Typical enterprise use cases include dynamically adjusting the number of Aurora read replicas to handle database query load spikes, scaling ECS task counts during peak traffic for a microservices application, or optimizing costs by scaling down SageMaker inference endpoints during off-hours.
AWS Cost Explorer Service
The AWS Cost Explorer API, provided by Amazon Web Services, serves as the programmatic backbone for the Cost Explorer service, a powerful tool designed to help organizations visualize, understand, and manage their AWS cloud spending. At its core, this API enables developers and financial operations (FinOps) teams to move beyond the web console and directly query their cost and usage data, unlocking the ability to build custom dashboards, automated reports, and sophisticated cost management applications. Its capabilities range from retrieving high-level aggregated data, such as monthly service costs or daily usage totals, to drilling down into granular, resource-level details, including the specific write operations of a DynamoDB table or the data transfer metrics of an EC2 instance. This granular access is critical for enterprises implementing showback/chargeback models, identifying optimization opportunities, and enforcing budget guardrails across complex, multi-account AWS environments.
Related MCP Server Integrations
Notion API MCP Setup
The Notion API is a comprehensive RESTful interface provided by Notion, the popular all-in-one workspace platform, enabling programmatic interaction with its rich set of collaborative objects. It grants developers and automated systems the ability to read, create, update, and manage core Notion entities such as blocks (the fundamental building blocks of content like text, lists, and media), databases (structured tables with properties), pages (containers for content and databases), and comments. Typical use cases span enterprise and consumer scenarios, including automating team workflows, syncing data between Notion and other business systems (like CRM, project management, or analytics tools), building custom dashboards, generating dynamic reports, and enhancing content collaboration through programmatic updates. Organizations leverage this API to break down data silos, enforce process automation, and create tailored integrations that extend Notion's native capabilities for specific departmental or cross-functional needs.
Amazon CloudWatch Application Insights MCP Setup
Amazon CloudWatch Application Insights is a specialized observability service provided by Amazon Web Services (AWS) designed to simplify the monitoring and troubleshooting of applications, particularly those built on Microsoft IIS and .NET frameworks running on EC2 instances or within Elastic Beanstalk environments. Its core capability lies in automatically discovering application components, analyzing correlated metrics, logs, and traces to identify anomalies, and then surfacing actionable insights that pinpoint the root cause of common operational issues. By integrating seamlessly with other AWS services like CloudWatch, AWS X-Ray, and AWS Systems Manager, it provides a unified view of application health, reducing the mean time to resolution (MTTR) for performance degradations and errors. The typical use case spans enterprise environments managing distributed microservices or monolithic .NET applications, where teams need to proactively detect issues such as memory leaks, high CPU utilization, or specific application errors without manually configuring complex monitoring dashboards and alarms.
Application Auto Scaling MCP Setup
The Application Auto Scaling API, provided by Amazon Web Services (AWS), is a robust service designed to automate the scaling of computing resources for a wide array of AWS services, ensuring optimal performance, availability, and cost efficiency. Its core capability is to define policies that automatically adjust the provisioned capacity of supported resources in response to changing demand, as measured by CloudWatch metrics or predefined schedules. Beyond the initially listed resources, it supports scaling for Amazon DynamoDB tables and global secondary indexes, Amazon ECS services running on Fargate or EC2, Amazon ElastiCache replication groups, Amazon Neptune clusters, Amazon SageMaker endpoint variants, and custom resources via the AWS Lambda-backed scalable target. This makes it a central tool for architects and DevOps engineers in building resilient, self-optimizing cloud architectures. Typical enterprise use cases include dynamically adjusting the number of Aurora read replicas to handle database query load spikes, scaling ECS task counts during peak traffic for a microservices application, or optimizing costs by scaling down SageMaker inference endpoints during off-hours.
AWS Cost Explorer Service MCP Setup
The AWS Cost Explorer API, provided by Amazon Web Services, serves as the programmatic backbone for the Cost Explorer service, a powerful tool designed to help organizations visualize, understand, and manage their AWS cloud spending. At its core, this API enables developers and financial operations (FinOps) teams to move beyond the web console and directly query their cost and usage data, unlocking the ability to build custom dashboards, automated reports, and sophisticated cost management applications. Its capabilities range from retrieving high-level aggregated data, such as monthly service costs or daily usage totals, to drilling down into granular, resource-level details, including the specific write operations of a DynamoDB table or the data transfer metrics of an EC2 instance. This granular access is critical for enterprises implementing showback/chargeback models, identifying optimization opportunities, and enforcing budget guardrails across complex, multi-account AWS environments.
AWS Data Pipeline MCP Setup
AWS Data Pipeline, offered by Amazon Web Services (AWS), is a fully managed orchestration service designed to automate the movement and transformation of data between disparate compute and storage systems. Its core capability lies in defining, scheduling, and monitoring data-driven workflows called pipelines, which encapsulate a series of data processing activities and their dependencies. The service abstracts the operational complexities of scheduling and dependency management, allowing developers to focus on the logic of data processing tasks such as ETL (Extract, Transform, Load), data migration, and periodic report generation. Typical enterprise use cases include nightly aggregation of sales data from multiple regional databases into a central data warehouse, processing and archiving log files from applications, and triggering machine learning model training pipelines after new datasets are ingested. By providing a managed scheduler and a framework for defining data sources, activities, and compute resources, AWS Data Pipeline serves as a reliable backbone for time-sensitive and dependency-aware data workflows in the cloud.