mcp-postgres-server

mcp-postgres-server

3

This project is a Model Context Protocol server designed for PostgreSQL databases. It enables AI models to perform database operations securely, supporting error handling and validation. A key feature is its multi-schema support.

connect_db

Establish a connection to the PostgreSQL database

query

Execute SELECT query, support parameterized query

execute

Perform INSERT, UPDATE, or DELETE operations, support parameterized query

list_tables

List all tables in the database

describe_table

View the structure of a specific table