MCP.so
Sign In

MCP PostgreSQL Server

@antonorlov

Repository

About MCP PostgreSQL Server

MCP PostgreSQL Server

#postgres#database#mcp-server

Basic information

Category

Databases

License

MIT

Runtime

node

Transports

stdio

Publisher

antonorlov

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "postgres": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgres-server"
      ],
      "env": {
        "PG_HOST": "your_host",
        "PG_PORT": "5432",
        "PG_USER": "your_user",
        "PG_PASSWORD": "your_password",
        "PG_DATABASE": "your_database"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MCP PostgreSQL Server?

A Model Context Protocol server that enables AI models to interact with PostgreSQL databases through a standardized interface. It provides database operations such as connecting, querying, executing statements, and listing schemas and tables.

How to use MCP PostgreSQL Server?

Install via npm (npm install mcp-postgres-server) or run directly with npx mcp-postgres-server. Configure environment variables for database credentials (host, port, user, password, database). Then use the available MCP tools: connect_db, query, execute, list_schemas, list_tables, describe_table.

Key features of MCP PostgreSQL Server

  • Secure connection handling with automatic cleanup
  • Prepared statement support to prevent SQL injection
  • Supports PostgreSQL-style ($1, $2) and MySQL-style (?) parameter placeholders
  • Comprehensive error handling with detailed messages
  • TypeScript support
  • Automatic connection management
  • Multi-schema support for database operations

Use cases of MCP PostgreSQL Server

  • Querying data from PostgreSQL tables using SELECT statements
  • Executing INSERT, UPDATE, and DELETE operations securely
  • Exploring database structure by listing schemas, tables, and describing columns
  • Integrating AI models with existing PostgreSQL databases for data retrieval

FAQ from MCP PostgreSQL Server

How does the server prevent SQL injection?

It uses prepared statements for all queries, securely handling parameterized inputs to avoid injection.

What parameter placeholder styles are supported?

Both PostgreSQL-style ($1, $2) and MySQL

Comments

More Databases MCP servers

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Snowflake MCP Server

isaacwasserman

185

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

MCP Alchemy

runekaagaard

A 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