Postgres

v1.0.0APIsstable

This server enables interaction with PostgreSQL databases through the Model Context Protocol, optimized for the AWS Bedrock AgentCore Runtime. It provides tools for executing read-only queries, exploring database schemas, and monitoring table statist

postgresmcpai-integration
Share:
1
Stars
0
Downloads
0
Weekly
0/5

What is Postgres?

Postgres is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to this server enables interaction with postgresql databases through the model context protocol, optimized for the aws bedrock agentcore runtime. it provides tools for executing read-only queries, explor...

This server enables interaction with PostgreSQL databases through the Model Context Protocol, optimized for the AWS Bedrock AgentCore Runtime. It provides tools for executing read-only queries, exploring database schemas, and monitoring table statist

This server falls under the APIs and Databases categories on MCPgee, the world's largest MCP server directory with 33,000+ servers.

Features

  • list_schemas
  • list_objects
  • get_object_details
  • explain_query
  • analyze_workload_indexes

Use Cases

List all schemas in the database
List objects in a schema
Show detailed information about a database object
Explains the execution plan for a SQL query, showing how the database will execute it and provides detailed cost estimates.
Analyze frequently executed queries in the database and recommend optimal indexes
mirenqinggege

Maintainer

LicenseMIT License
Languagekotlin
Versionv1.0.0
UpdatedMar 14, 2026
Statushealthy
Maintenanceactive

Works with

ClaudeOpenAIwindowsmacoslinux

Installation

NPM

npx -y @modelcontextprotocol/server-postgres

Manual Installation

npx -y @modelcontextprotocol/server-postgres

Configuration

Configuration Details

Config File

claude_desktop_config.json

Performance

Response Metrics

Response Time< 200ms
ThroughputMedium

Resource Usage

Memory UsageLow
CPU UsageLow

Frequently Asked Questions about Postgres

What is Postgres?

Postgres is a Model Context Protocol (MCP) server that this server enables interaction with postgresql databases through the model context protocol, optimized for the aws bedrock agentcore runtime. it provides tools for executing read-only queries, exploring database schemas, and monitoring table statist It connects AI assistants to external tools and data sources through a standardized interface.

How do I install Postgres?

Install via npm with the command: npx -y @modelcontextprotocol/server-postgres. Then add the server configuration to your AI client's JSON config file (e.g., claude_desktop_config.json or .cursor/mcp.json).

Which AI clients work with Postgres?

Postgres works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.

Is Postgres free to use?

Yes, Postgres is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.

Postgres Alternatives — Similar APIs Servers

Looking for alternatives to Postgres? Here are other popular apis servers you can use with Claude, Cursor, and VS Code.

n8n-mcp

189.1k

A comprehensive MCP server that provides full control over n8n automation workflows through natural language. It offers 43 tools for managing workflows, executions, credentials, and data tables, with safety features like write-mode protection and dou

gemini-cli-mcp

104.5k

A secure MCP server that wraps the Google Gemini CLI, allowing clients to query Gemini models using local OAuth sessions without requiring an API key. It provides tools for model interaction and diagnostics with built-in protection against command in

TrendRadar

58.0k

A real-time hotspot monitoring and news aggregation assistant that provides AI-powered analysis of trending topics across multiple platforms via the Model Context Protocol. It enables users to track news and receive automated notifications through va

Context7 MCP

55.8k

A Model Context Protocol server that fetches up-to-date, version-specific documentation and code examples from libraries directly into LLM prompts, helping developers get accurate answers without outdated or hallucinated information.

MemPalace

52.6k

A local AI memory system that stores all conversations verbatim and organizes them into navigable structures. It provides 19 MCP tools for AI assistants to search and retrieve past decisions, debugging sessions, and architecture debates automatically

Chrome DevTools MCP

40.6k

AI-powered Chrome automation server with natural language element detection. Control Chrome browser through MCP protocol for testing, debugging, and performance analysis. Features 91% accuracy in element location, works with free AI models, and suppo

Browse More APIs MCP Servers

Explore all apis servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.

Quick Config Preview

{ "mcpServers": { "postgres": { "command": "npx", "args": ["-y", "@modelcontextprotocol/server-postgres"] } } }

Add this to your claude_desktop_config.json or .cursor/mcp.json

Read the full setup guide →

Ready to use Postgres?

Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.

33,000+ ServersFree & Open SourceStep-by-Step Guides