PostgreSQL MCP Server

PostgreSQL MCP Server

Public
HenkDz/postgresql-mcp-server

Provides comprehensive PostgreSQL database management for AI assistants via Model Context Protocol, featuring consolidated intelligent tools for schema, permissions, performance, indexing, functions, triggers, security, advanced query execution, comment management, and real-time monitoring.

typescript
0 tools
May 29, 2025
Updated Jun 4, 2025

Supercharge Your AI with PostgreSQL MCP Server

MCP Server

Unlock the full potential of PostgreSQL MCP Server through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.

Unified API Access
Complete Tracing
Instant Setup
Get Started Now

Free tier available • No credit card required

Instant Setup
99.9% Uptime
10,000+Monthly Requests
Configuration Requirements
none
Configure authentication and required variables to access this MCP server
Required Environment Variables
PGUSER
Optional
string

PostgreSQL username

DATABASE_URL
Optional
string

PostgreSQL connection string in the format postgresql://user:password@localhost:5432/dbname

PGDATABASE
Optional
string

PostgreSQL database name

PGHOST
Optional
string

PostgreSQL server host

PGPORT
Optional
string

PostgreSQL server port

PGPASSWORD
Optional
string

PostgreSQL password

Security Notice

Your environment variables and credentials are securely stored and encrypted. LangDB never shares these configuration values with third parties.

Related MCPs5
  • PostgreSQL Advanced MCP Server

    Provides full read-write access to PostgreSQL databases via Model Context Protocol, enabling safe query execution, transaction management, schema insights, and advanced safety controls for seamless LLM integration.

    Added May 29, 2025
  • Multi Database MCP Server

    Provides AI assistants with unified, multi-database access via the Model Context Protocol, enabling SQL query execution, transaction management, schema exploration, and performance analysis across MySQL, PostgreSQL, and TimescaleDB with dynamic tool generation and clean architecture.

    Added May 29, 2025
  • PostgreSQL MCP Server

    Provides Model Context Protocol-based PostgreSQL database management with features for configuration analysis, performance optimization, security assessment, setup guidance, and debugging common database issues.

    3 tools
    Added May 30, 2025
  • MCP PostgreSQL Server

    Enables AI models to securely interact with PostgreSQL databases via Model Context Protocol, supporting connection management, query execution with prepared statements, multi-schema operations, and comprehensive error handling.

    5 tools
    Added May 29, 2025
  • PocketBase MCP Server

    Provides advanced Model Context Protocol (MCP) tools for PocketBase databases, enabling comprehensive collection and record management, user authentication, schema handling, and database operations with seamless CRUD and pagination support.

    Added May 30, 2025