MCP PostgreSQL Server

MCPOpen SourceMIT31.5

by antonorlov • Data & Databases

An MCP server that enables AI models to interact with PostgreSQL databases through a standardized interface.

Example Use Cases

1
Connect to PostgreSQL databases securely
2
Execute and manage SQL queries and transactions
3
Automatic handling of database connections and schemas

Description

The MCP PostgreSQL Server facilitates operations on PostgreSQL databases for AI models using a Model Context Protocol. It ensures secure, efficient database interaction with automatic connection management and comprehensive error handling. The server supports multi-schema operations and is designed for flexibility with SQL query and execution capabilities.

Capabilities(6 total)

Tools (6)

connect_db

Connect to PostgreSQL database. NOTE: Default connection exists - only use when requested or if other commands fail

host:string*port:numberuser:string*password:string*database:string*

query

Execute a SELECT query

sql:string*params:array

execute

Execute an INSERT, UPDATE, or DELETE query

sql:string*params:array

list_schemas

List all schemas in the database

list_tables

List tables in the database

schema:string

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C56/100

6/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities6 Tools / 0 Prompts / 0 Resources

Ownerantonorlov

CategoryData & Databases

DependenciesStandalone

Set Your Username